Q

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

SearchExchange.com expert Patricia Guerrero explains how to export Microsoft Outlook calendar data to a Microsoft Excel file.

I need to manually copy the start and stop times of my monthly appointments (in my Microsoft Outlook 2003 calendar...

running on Exchange Server 2003) to a Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I spent on an appointment. Is there a way to export the fields from a Microsoft Outlook/Exchange Server calendar to specified fields in Microsoft Excel or Microsoft Access?

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:

 

This was last published in October 2006

Dig Deeper on Microsoft Outlook and Exchange Server Calendar and Contact Management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

there is no export import option on the latest outlook version.
Cancel

-ADS BY GOOGLE

SearchWindowsServer

SearchEnterpriseDesktop

SearchCloudComputing

SearchSQLServer

Close