How to export data from a Microsoft Outlook calendar to Microsoft Excel

VIEW MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A.

Follow these steps to export your calendar to a Microsoft Excel file:

1. Select the Microsoft Outlook calendar.
2. Go to File -> Import and Export.
3. Click Export to a file.
4. Choose Comma Separated Values (DOS) for Microsoft Excel or Microsoft Access.
5. Select the Microsoft Outlook calendar.
6. Type a name for the new file.
7. Set a date range to narrow your data.
8. Open the file using Microsoft Excel.

MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:

Yes, it works, but it didn't export the attendees list.
—Dayalan P.

**************************************************

I have exported my Microsoft Outlook 2003 calendar to Microsoft Excel, but not all of the items showed up. I have some recurring items that show, and some that do not. How can I fix this so I can see everything?
—Eric G.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchExchange.com:

• Expert Advice: Exporting Exchange public folder contacts to Microsoft Excel
• Tip: How to export data from a Microsoft Outlook .PST file to a .CSV file
• Tip: Fix mangled directory imports
• Reference Center: Exchange Server contacts and calendars resources
• Reference Center: Microsoft Outlook tips and resources