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

Question

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

Kelly C 20

0 comments

2 answers

Your answer

Answer 1

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.

Vikki-T 13,320 Reputation points Microsoft External Staff Moderator

2026-11-03T11:39:57.8933333+00:00

Hello Kelly C,

It has been a while and I am writing to see how things are going with this issue.

Have you had a chance to check the replies provided?

Any update would be appreciated.

Answer 2

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

In new Outlook, select Calendar in the navigation pane.
Select View → Calendar settings.
Go to Calendar → Shared calendars.
Under Publish a calendar:
- Select the calendar.
- Choose the highest detail level appropriate for the data you need.
Select Publish.
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.

Open the converter.
Upload the downloaded .ics file.
Select XLSX as the output format.
Convert and download the workbook.^1^
Open it in Excel and remove or rearrange columns as required.
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