Which Way Exports an Outlook Calendar to Excel?
Outlook has no Excel option. You save the Outlook calendar as a CSV file, then open the file in Excel.
| Method | Output | Use case |
|---|---|---|
| Import/Export wizard | CSV file with a date range | Clean data for reports |
| List view copy | Rows pasted into Excel | A few weeks of events |
| OLM Converter | CSV from a Mac Outlook OLM file | Mac Outlook users |
How does Outlook Export a Calendar to CSV?
Method #1: Import/Export Wizard (Free)
Who it suits. Classic Outlook for Windows users. Extra application. Excel.
- Select File, then Open & Export, then Import/Export.
- Choose Export to a file and move on with Next.
- Choose Comma Separated Values and move on with Next.
- Open your account, choose the Calendar folder and continue.
- Use Browse to name the file and continue.
- Select Finish. Outlook asks for a start date and an end date. Enter both and select OK.
A Microsoft community answer lists the same path, including the date range prompt.
Select Map Custom Fields on the last screen to limit the columns to Subject, Start Date, Start Time, End Date, End Time and Location. Open the CSV in Excel afterward and apply the Short Date format if the dates look like text.
Outlook warns that the CSV format does not directly support recurring appointments. Check recurring events in the file after the export.
Does New Outlook have a CSV Export?
Microsoft states that new Outlook cannot save calendar and contact items in PST files. Third party guides report that Outlook on the web has no Import/Export wizard either.
Set the New Outlook toggle to off to switch to classic Outlook, then follow Method #1. Need a data file instead? Our guide on how to export Office 365 calendar explains ICS and PST output.
Is There a Faster Way for a Short Date Range?
Method #2: List View Copy (Free)
Who it suits. Users who need a few weeks of events. Extra application. Excel.
- Open the Calendar and select the View tab.
- Open Change View and select List.
- Click one row and press Ctrl+A to select all rows.
- Press Ctrl+C, open Excel and press Ctrl+V.
Third party guides describe this copy method and Microsoft gives no steps for it. Check the pasted dates and times in Excel before you use them.
How do Mac Users Export Calendars to CSV?
Method #3: OLM Converter (Paid After Demo)
Who it suits. Mac Outlook users. Extra application. OLM Converter.
Mac Outlook exports an OLM file. OLM Converter lists CSV among its export formats and adds a date filter.
- Export the calendar from Mac Outlook to an OLM file.
- Start the software and add the OLM file.
- Select CSV as the format and set the date filter.
- Select the destination folder and start the export.
Read how to convert OLM to CSV on Mac for the full flow. The Mac demo exports 25 items per folder for calendars, according to the vendor page.
What should You Check in the Excel File?
- Format the date columns as Short Date.
- Check recurring events, because Outlook warns that CSV does not directly support them.
- Save an XLSX copy. The CSV remains your raw export.
- Need ICS instead? See how to convert OLM calendar to ICS.
Frequently Asked Questions
Can Outlook Export a Calendar to Excel?
Outlook saves the Outlook calendar as CSV and Excel opens CSV files. Use the Import/Export wizard in classic Outlook.
How do You Set a Date Range for the Export?
Classic Outlook asks for a start date and an end date after you select Finish in the wizard.
Can New Outlook Export to CSV?
Third party guides report no Import/Export wizard in new Outlook. Switch to classic Outlook for the CSV export.
What does Map Custom Fields do?
It limits the CSV to the fields you choose, for example Subject, Start Date and Location.
Why do the Dates Look Like Text in Excel?
Excel reads some CSV dates as text. Select the columns and apply the Short Date format.
Does a CSV Export Store Recurring Events?
Outlook warns that the CSV format does not directly support recurring appointments. Check the file after the export.
How do Mac Users Get a CSV File?
Export the calendar as an OLM file, then use an OLM converter that lists CSV as an output format.
Author's Verdict
Use the wizard for a clean CSV with a date range.
Use OLM Converter when the Outlook calendar sits in Mac Outlook.
Key Takeaways
- Excel opens the CSV file from the Outlook calendar.
- The wizard prompts for a date range before the export.
- New Outlook needs a switch to classic Outlook for the wizard.
Related Guides