Export Outlook 2007 calendar to Excel spreadsheet

5 pts.
Tags:
Excel workbooks
Microsoft Excel
Microsoft Outlook
Outlook 2007 calendar
Outlook calendar
Windows Vista
How do I export Outlook calendar 2007 to Excel spreadsheet?

Software/Hardware used:
vista
ASKED: October 27, 2010  1:28 PM
UPDATED: August 15, 2013  6:55 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It is a very simple task, just follow the following steps.

1.
•Open Microsoft Outlook 2007.

•2
Click on “File,” “Import and Export.” The “Import and Export” wizard will begin.

•3
Click “Export to a file” and click “Next.”

•4
Choose the file type to export it to. If you want to keep it in the regular Outlook format, choose “Personal Folder File (.pst).” To export it into another program like Excel, you can choose “Microsoft Excel 97-2003″ or for Access “Microsoft Access 97-2003.” For another program, choose one of the other options, such as comma-separated or tab-separated delimited file types. Click “Next.”

•5
Click “Calendar” in the next window. This will ensure that the calendar is what you are exporting. Click “Next.”

•6
Choose a location to export the calendar to by clicking “Browse.” Click “Finish” once you are done to export the calendar to the location you specified.

If you need help with this contact us and we can help you out remotely.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Cwessner
    [...] Export Outlook 2007 calendar to Excel spreadsheet 27 Oct 2010. how do I export outlook calendar 2007 to excel spreadsheet. another program like Excel, you can choose "Microsoft Excel 97-2003" or for Export Outlook 2007 calendar to Excel spreadsheet [...]
    0 pointsBadges:
    report
  • TinaMunch
    What if the application "Import/export" is not to be found under yhe file menu. (using Outlook 2010)?
    10 pointsBadges:
    report
  • duie06
    Is there a way to do this and have it automatically update the excel file as the outlook calendar updates, like being linked?
    10 pointsBadges:
    report
  • Michael Tidmarsh
    Welcome to ITKE, duie06! The best idea is to start a new question so our experts can try to help you with your issue.

    For more information on our community, check out our FAQ.
    25,225 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following