Guide · Office and email
How to export your Outlook calendar to Excel (new Outlook, classic Outlook, the web and Mac)
By Blink Brief · Updated · How pages are made
To export your Outlook calendar to Excel, take it out of Outlook as an .ics file, then turn that file into a CSV, which Excel opens. In new Outlook or Outlook on the web, publish the calendar (Shared calendars › Publish a calendar) and open its ICS link to download the file. In classic Outlook for Windows, File › Save Calendar saves it. Then choose the file in the converter on this page and press Download CSV, or open it in the free ICS viewer and press Download for Excel (.csv): every event becomes a row with its title, date, start and end time, time zone and place.
Short answer
- New Outlook or Outlook on the web: Shared calendars › Publish a calendar › Publish › open the ICS link › the .ics downloads.
- Classic Outlook for Windows: File › Save Calendar › More Options › Date Range › OK › Save.
- To Excel: the converter below › Choose an .ics file › Download CSV. Print or save as PDF gives the same list on paper.
Which Outlook you have decides the first step
Every Outlook can give you the calendar as an .ics file, the standard calendar format. The routes differ:
- New Outlook for Windows and Outlook on the web publish the calendar: Publish a calendar gives you an ICS link, and the link downloads the file. Use this route rather than new Outlook's export to a .pst file: Microsoft says "Calendar and contacts items saved in .pst files is not available in new Outlook at this time."
- Classic Outlook for Windows (Outlook for Microsoft 365, Outlook 2024 and Outlook 2021) saves the .ics directly with File › Save Calendar.
- Outlook for Mac goes through Outlook on the web (the Mac section below).
If your Outlook has no File › Save Calendar, use the publish route. A meeting from Teams is in the same calendar: exporting a Teams calendar follows these steps too.
New Outlook or Outlook on the web: publish, then download the .ics
Microsoft's steps for new Outlook for Windows; Outlook on the web differs only in step 2:
- From the navigation pane, select Calendar.
- On the View tab, select Calendar settings › Calendar › Shared calendars. In Outlook on the web, select Settings, then Shared calendars.
- Under Publish a calendar, choose the calendar from the dropdown, then the permissions. For a spreadsheet with titles and places, choose the level that shows all details: with a busy-only level, the file holds times without titles.
- Select Publish. An HTML link and an ICS link appear below.
- Copy the ICS link, paste it into your browser's address bar and press Enter. The calendar downloads as an .ics file.
Microsoft describes the ICS link as the one with which "recipients can download the ICS file". When the file is on your computer, unpublish the calendar (the last section). The full walk-through, with the permission levels, is in exporting your calendar from new Outlook.
Classic Outlook for Windows: File › Save Calendar
Microsoft's steps for classic Outlook:
- Open the Calendar and select the calendar you want to export.
- Click File › Save Calendar.
- Use the default name or type one in the File name box.
- Click More Options.
- Click the Date Range arrow and choose how much to include, or click Specify dates for your own range.
- Click the Detail arrow and choose how much detail to include. Full details put the notes in the spreadsheet too.
- Click OK, then Save.
Microsoft calls the file "a snapshot of the calendar" and warns that Whole calendar or a large date range "might create a large iCalendar file". For a report of one quarter or one project, Specify dates keeps the spreadsheet to the rows you need.
Turn the .ics file into a CSV for Excel
Choose the file you downloaded or saved. The converter lists the events sorted by start, shows the first 20, and Download CSV saves every event as one row. Print or save as PDF prints the whole list on US Letter or A4, without the rest of this page.
Turn the Outlook .ics file into a CSV for Excel
The .ics file from Outlook
or drop it on this box
The file is read in this tab and never uploaded.
| Date | Time | Title | Location | Repeats |
|---|
In the print window, choose Portrait and your paper, US Letter or A4: the list fits either.
The converter needs JavaScript. To make the list by hand:
- Open the .ics file in a text editor, such as Notepad or TextEdit.
- Each event runs from
BEGIN:VEVENTtoEND:VEVENT. Copy itsSUMMARY(title),DTSTART(start),DTEND(end) andLOCATIONinto one spreadsheet row. - Read
20261116T090000as 16 November 2026, 9:00. AZat the end means UTC.
The file is read in this browser tab and never uploaded; close the tab and it's gone. The CSV is saved as UTF-8 with a byte order mark, and Microsoft says such a file opens normally in Excel, so accented names keep their letters: double-click it. If every value lands in one column, converting an .ics file to Excel shows how to import it from Excel's Data tab instead.
The ICS viewer does the same from its own page and adds more: each event in your own time zone, and Add to Google Calendar or Add to Outlook on each event. The file you open there is read in the browser tab and never uploaded. When you press Add to Google Calendar or Add to Outlook, that one event's title, times, place and notes go to Google or Microsoft in the link that opens their calendar.
What each column holds
The CSV has 13 columns, in this order:
- Title, then Start date and Start time, End date and End time: dates as 2026-11-18, times as 09:30, in the zone the Outlook file gives them (a time it gives in UTC in your own time zone).
- All day (Yes or No) and Hours: the length of each meeting, 1.5 for 90 minutes, ready to add up in Excel (a repeating meeting counts once).
- Time zone: the zone the file names for that event, or your own zone for a time the file gives in UTC, so a team across zones can see whose time each row is in.
- Location and Notes: filled when you published or saved with enough detail.
- Repeats in words ("Weekly on Mon until 2026-12-14") and Repeat rule as the file writes it. A repeating meeting is one row, not one row per date.
- Link: the event's web address when the file has one.
A cell that starts with =, +, - or @ gets an apostrophe in front, so Excel shows it as text and never runs it as a formula.
Classic Outlook's own CSV export
A Microsoft community moderator's answer on Microsoft Q&A (30 January 2023) gives this path for classic Outlook: File › Open & Export › Import/Export › Export to a file › Comma Separated Values, then the calendar under your account, a place to save, Finish, and a date range. The converter on this page makes the CSV from the .ics of any Outlook (new, classic, web or Mac), with Hours, Time zone and Repeats columns.
Outlook for Mac
Microsoft's export page for Outlook for Mac says: "The only export option available at this time is the .olm archive file." Excel can't open an .olm. If the calendar belongs to a Microsoft 365 or Outlook.com account, sign in to Outlook on the web in Safari or Chrome with the same account, publish the calendar as above, and download the .ics. The converter on this page runs in the Mac's browser too.
Publishing is turned off (a work or school account)
Microsoft notes: "Calendar sharing may not be available for your account, or may be limited to people in your organization, depending on your organization settings." If Publish a calendar is missing, or offers busy times only, the organization's settings decide it. Then:
- Use classic Outlook's File › Save Calendar, if your organization still gives you classic Outlook.
- Ask IT to turn publishing on. The admin settings behind it are named in exporting your calendar from new Outlook.
Unpublish when you have the file
While the calendar is published, anyone who has its links can read it at the level you chose. Once the .ics is on your computer, go back to Shared calendars and select Unpublish (Microsoft's steps). Next month, publish again and download a fresh file: the spreadsheet is a copy of the day you made it.
Going the other way, from a spreadsheet into Outlook, is in importing an Excel schedule into Outlook Calendar.
Questions
Can you export a new Outlook calendar to Excel?
Yes, through an .ics file. Publish the calendar (View › Calendar settings › Calendar › Shared calendars › Publish a calendar), open its ICS link in a browser to download the .ics, and turn it into a CSV with the converter on this page or the ICS viewer's Download for Excel (.csv). Excel opens the CSV.
How do I export my Outlook calendar to Excel with date and time?
Use the converter on this page. Its CSV gives each event Start date, Start time, End date and End time in their own columns (2026-11-18 and 09:30), plus Hours, All day and Time zone, so Excel sorts and filters by them. Each time keeps the zone the Outlook file gives it; a time given in UTC is shown in your own time zone.
Can you export an Outlook calendar to Excel on a Mac?
Yes, through Outlook on the web. Sign in to Outlook on the web in Safari or Chrome with the same account, publish the calendar, download the .ics from its ICS link, and convert it here. The converter runs in the Mac's browser.
Sources
- Microsoft: Share an Outlook calendar as view-only with others: new Outlook for Windows: View › Calendar settings › Calendar › Shared calendars › Publish a calendar; HTML and ICS links; Unpublish. Read on 18 November 2026.
- Microsoft: Share your calendar in Outlook on the web: Settings › Shared calendars › Publish a calendar; recipients can download the ICS file; organization settings. Read on 18 November 2026.
- Microsoft: Export an Outlook calendar to Google Calendar: classic Outlook (Outlook for Microsoft 365, 2024, 2021): File › Save Calendar › More Options. Read on 18 November 2026.
- Microsoft: Export emails, contacts, and calendar items to Outlook using a .pst file: calendar items in .pst files not available in new Outlook. Read on 18 November 2026.
- Microsoft: Export items to an archive file in Outlook for Mac: the .olm archive is the only export option. Read on 18 November 2026.
- Microsoft: Opening CSV UTF-8 files correctly in Excel: a UTF-8 CSV saved with a byte order mark opens normally. Read on 18 November 2026.
- Microsoft Q&A: How do I download my Outlook calendar as an Excel sheet?: a Microsoft community moderator's answer, 2023-01-30: Import/Export › Export to a file › Comma Separated Values. Read on 18 November 2026.