I would like an Excel/CSV table with event details from my Outlook calendar

Kelly C 20 Reputation points
2026-10-30T11:16:09.3866667+00:00

I would like an Excel/CSV table with event details from my Outlook calendar

Outlook | Windows | New Outlook for Windows | For home
0 comments No comments

2 answers

Sort by: Oldest
  1. AI answer

    2026-10-30T11:17:11.0766667+00:00

    New Outlook for Windows does not provide a direct calendar-to-Excel export, so publish the calendar as an ICS file, convert that file to XLSX, and then save it as CSV if needed.^1^

    1. Export the calendar as an ICS file

    1. In new Outlook, select Calendar in the navigation pane.
    2. Select View → Calendar settings.
    3. Go to Calendar → Shared calendars.
    4. Under Publish a calendar:
      • Select the calendar.
      • Choose the highest detail level appropriate for the data you need.
    5. Select Publish.
    6. Copy the ICS link, open it in a browser, and download the .ics file.^2^

    Publishing creates a read-only link that can expose calendar information to anyone who receives it. After downloading the file, return to the same settings page and select Unpublish if the link is no longer needed.^2^

    2. Convert ICS to Excel

    The matching Q&A resolution uses this converter:

    https://www.coolutils.com/online/ICS-to-XLSX

    This is a third-party, non-Microsoft service. Do not upload the calendar if it contains confidential, medical, financial, or otherwise sensitive information.

    1. Open the converter.
    2. Upload the downloaded .ics file.
    3. Select XLSX as the output format.
    4. Convert and download the workbook.^1^
    5. Open it in Excel and remove or rearrange columns as required.
    6. For CSV, select File → Save As and choose CSV UTF-8 (Comma delimited) (*.csv).

    The resulting columns depend on the publication detail level, account policy, information contained in the ICS file, and converter support. Fields such as attendees, organizer, description, recurrence details, or private-event information might be absent.

    If “Publish a calendar” is missing

    Calendar publishing may be unavailable for the account or disabled by an organization’s sharing policy. For a work or school account, ask the Microsoft 365 administrator whether external calendar publishing is permitted. If classic Outlook is available, it can coexist with new Outlook, but the supplied Microsoft documentation does not establish a direct calendar-to-CSV workflow in new Outlook itself.


    References

    1. export calendar meetings to Excel - Microsoft Q&A
    2. [New Outlook](https://support.microsoft.com/outlook/sharing/share-an-outlook-calendar-as-view-only-with-others)
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Vikki-T 13,320 Reputation points Microsoft External Staff Moderator
    2026-10-31T08:49:29.7266667+00:00

    Hello Kelly C,

    If you still have access to classic Outlook for Windows, you may be able to export the calendar directly to a CSV file without uploading your calendar data to a third-party converter:

    • Open classic Outlook.
    • Go to File > Open & Export > Import/Export.
    • Select Export to a file, then choose Comma Separated Values.
    • Select the Calendar folder you want to export.
    • Choose a save location and complete the export.

    You can then open the CSV file in Excel and rearrange or remove columns as needed.

    If you only have access to new Outlook, could you confirm whether this is a personal Outlook.com account or a work/school Microsoft 365 account? The available export and calendar-publishing options may depend on the account type and the organization’s sharing policies.

    For calendars containing private or work-related information, I would avoid uploading the ICS file to an external conversion website. Thank you so much for your understanding.     


    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.