+ Reply to Thread
Results 1 to 3 of 3

Export "other" (SharePoint) calendar from Outlook into csv

  1. #1
    Registered User
    Join Date
    12-30-2022
    Location
    Hamburg, Germany
    MS-Off Ver
    Microsoft 365
    Posts
    10

    Export "other" (SharePoint) calendar from Outlook into csv

    Hello,

    I want to export a calendar from outlook that is listed under "other calendars".

    The specialty here is that it is a SharePoint calendar on a SharePoint site, which I connected to Outlook. When I want to do a regular export into Excel, however, only my normal calendars (like standard calendar, birthday, holiday) is listed.

    In Outlook I looked at the file structure to see where the calendar is located, it is shown under "sharepoint lists" (see screenshot). However, as described above, sharepoint lists are not displayed under the export function (see screenshot "Outlook Export").

    So far I use a workaround by sending the calendar via e-mail to myself, import it again and then export it into csv and then delete it again, which is not very convenient.

    An export via Sharepoint directly is not my preferred solution, as the data is very limited and Oulook has much more data that is needed in Excel format.

    Does anyone have a suggestion on how to solve that? Or is it simply not possible due to MS Office limitations?

    Best regards
    excelwoman
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    01-09-2021
    Location
    Dundas, ON Canada
    MS-Off Ver
    MS Office 365
    Posts
    16

    Lightbulb Re: Export "other" (SharePoint) calendar from Outlook into csv

    Hello,

    I have found a way to natively export a "Sharepoint" shared calendar directly from outlook to excel; hopefully, this helps!

    I think that is less of an MS Office Limitation and more a lack of use cases with everything going to "Just share it with me" and nobody keeping any data, but who knows!
    1. Select only the calendar you wish to export
    2. Click "File" (Main Outlook button)
    3. Click "Open & Export"
    4. Click "Import/Export"
    5. Select "Export to a File" and Click Next
    6. Select "Comma Separated Values" and Click next
    7. Select the Calendar that is shown and click next
    8. Name and select where the file will be saved.
    9. Click Next
    10. Enjoy the CSV (Lol)
    Adam Seidlitz

  3. #3
    Registered User
    Join Date
    08-28-2023
    Location
    https://peryourhealth.ninja/patientnotebook/
    MS-Off Ver
    ms office 2010
    Posts
    1

    Re: Export "other" (SharePoint) calendar from Outlook into csv

    With patientnotebook, you have a simple and convenient way to pay your bills with 180 Medical. You can access your current balance, which updates daily.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sharepoint upload sticks on "Uploading to SharePoint" but still uploads
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2021, 04:19 PM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Linking dates in a work book to "Outlook Calendar"?
    By MrBigStyx in forum Excel General
    Replies: 1
    Last Post: 08-19-2015, 02:17 PM
  4. Opening SharePoint file with VBA - disable SharePoint "Contacting the server" message
    By kopite2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 01:56 AM
  5. Managing "delegated tasks" in an Outlook "Send Only" account
    By on_way_to_fame in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-13-2013, 12:21 AM
  6. Replies: 0
    Last Post: 11-20-2012, 10:22 AM
  7. MSoffice Outlook 2003 message to be saved in C dir with the file name "From" "Sent" "Sub"
    By shailendra0509 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 01:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1