Home > Ask the Microsoft Exchange Experts > Patricia Guerrero: Clients and Mobility Questions & Answers > How to export data from a Microsoft Outlook calendar to Microsoft Excel
Ask The Exchange Expert: Questions & Answers
EMAIL THIS

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

Patricia Guerrero EXPERT RESPONSE FROM: Patricia Guerrero

Pose a Question
Other Exchange Categories
Meet all Exchange Experts
Become an Expert for this site


Exchange Server tips, tutorials and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 25 October 2006
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?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Microsoft Outlook and Exchange Server Calendar and Contact Management
Exchange Mailbag: POP3 settings and Outlook issues
Synching public and private Exchange calendars
Preventing duplicate SMTP addresses on Exchange
Prevent duplicate appointments in Microsoft Outlook 2003 calendar
Troubleshoot 'System Attendant' error messages in OWA
Stop personal calendar appointments from showing on Exchange Server
Pushing a public calendar out from a private Exchange account
Problems arise after downloading email to .PST files
How to copy and transfer a Microsoft Outlook 2007 auto fill list
Troubleshooting Apple iPhone and Exchange Server integration issues
Microsoft Outlook and Exchange Server Calendar and Contact Management Research

Microsoft Outlook
Microsoft Outlook and SharePoint interoperability considerations
Outlook 2007 shut-down problems and fixes
Microsoft Outlook and SharePoint calendar dos and don'ts
Free tools facilitate large-scale Outlook and SharePoint integrations
Exchange Mailbag: POP3 settings and Outlook issues
Pros and cons of Outlook 2007's storage engine redesign
Fix Outlook 2007 and SharePoint synchronization breaks
Email issues after configuring hosted Exchange server on laptop
Avoid Outlook 2007 performance issues during repairs
A behind-the-scenes look at Outlook 2007 and SharePoint integration
Microsoft Outlook Research

Patricia Guerrero: Clients and Mobility
How to create a server-side forwarding rule to send email to a BlackBerry
OWA error: 'Page cannot be displayed. Internal server error.'
Marking calendar appointments 'private' in Outlook Web Access
Outlook Web Access won't let user reply to messages
IM options with Exchange 2003
Forwarding Exchange email using a different email account
Store terminates unexpectedly after attaching documents via OWA
Corrupt Active Server Pages causing OWA malfunctions
Access .PST files through Outlook Web Access
Problems viewing attachments in OWA

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
bacn  (SearchExchange.com)
email bankruptcy  (SearchExchange.com)
offline folder file  (SearchExchange.com)
OST file  (SearchExchange.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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

    		•



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice



    Outlook Web Access (OWA) Tips and Advice
    HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2004 - 2009, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts