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

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

1 comment

Oldest 

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:

SearchWindowsServer

SearchEnterpriseDesktop

SearchCloudComputing

SearchSQLServer

Close