HomeHow ToHow to Export Microsoft Outlook Calendar to Excel CSV File

How to Export Microsoft Outlook Calendar to Excel CSV File



Outlook Calendar from Microsoft helps us organize events and important dates in our year. It is easy to forget meetings or deadlines when we are swamped with a lot of work and activities each day. We need a constant reminder of what our days ahead will be like for us to keep up with all our responsibilities.

When you want to see all your events in one place, you can do so through a CSV file. An Excel spreadsheet file will converge all of the events in your calendar for you to see what happened on certain dates of the year.


You may look back to events months before. It is easier to recall deadlines for different dates. Exporting your Outlook Calendar to a CSV file will allow you to sort and organize the information. You can easily search for information through the Excel file rather than on your Calendar.

So, how to export Outlook Calendar to a CSV file that you can open in Microsoft Office Excel? Check out the steps below.

Exporting Outlook Calendar to a CSV File

  1. First, launch your Outlook app.
  2. Click File.
  3. Go to Open & Export.
  4. Click the Import/Export button.
  5. Choose Export to a file.
  6. Click Next.
  7. Select Comma Separated Values.
  8. Click Next.
  9. Click Calendar and click Next.
  10. Type the location and filename of your CSV file. You can click Browse and look for it on your Computer.
  11. Click Next.
  12. Now, click the Finish button.
  13. A new window will appear asking you to set the date range. Enter the start and the end dates that you want to export.
  14. Click OK.
  15. Wait for the process to finish. Once done, you can check the exported file to the file location you have set earlier.

That’s it! You can create multiple CSV files for different date range depending on how you want it to organize. Are you also planning to export your Outlook Calendar to an Excel file? What are your reasons? Tell us in the comments below.



Please enter your comment!
Please enter your name here

Recent Articles