Ask the Expert

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

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?

    Requires Free Membership to View

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 first published in October 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: