Move to Microsoft Exchange

Export Oracle Calendar Data for Excel 2007

To export data from your Oracle Calendar (CorporateTime) into spreadsheet format in Microsoft Excel 2007 for Windows:

  1. Export your Oracle Calendar entries into a data file, then
  2. Import the file into Excel 2007.

Export Data from Oracle Calendar

  1. Sign in to your Oracle calendar.
  2. From the File menu, choose Export Data...
  3. Choose Comma-delimited text file for Agendas.
  4. Click Continue.
  5. Under Period:, select a suitable range.
    • Note: You can go as far back in time as you need, and proceed into the future if you already have appointments planned. The longer the time period you select, the longer it will take to make the export file.
  6. Under People/Resources:, be sure that the calendar selected is the correct one to export.
  7. Then click the Browse... button to choose a location and file name (keep .txt at the end of the file name).
    • Note: Make sure you remember where this file is located, because you will have to find it again when you import the file into Excel. Your computer's desktop is the easiest place to find the file.
  8. Click OK.

Import Oracle Calendar Data into Excel 2007

  1. Open Excel.
  2. Click on the Microsoft Office button and select Open.
  3. Browse to the location where the exported file from Oracle Calendar was saved. This may require you to change the Files of type: to All Files.
  4. Highlight the file and click Open.
  5. In the Text Import Wizard window, under Original data type, select Delimited.
  6. Click Next.
  7. Select Comma under Delimiters on Step 2 of the Text Import Wizard window.
  8. Click Next.
  9. Click Finish on Step 3 of the Text Import Wizard window.
  10. The data from Oracle should now be displayed in the Excel Spreadsheet. You may have to expand the cell size to see all of the data.

© 2008 by the Rector and Visitors of the University of Virginia.

The information contained on the University of Virginia’s Department of Information Technology and Communication (ITC) website is provided as a public service with the understanding that ITC makes no representations or warranties, either expressed or implied, concerning the accuracy, completeness, reliability or suitability of the information, including warrantees of title, non-infringement of copyright or patent rights of others. These pages are expected to represent the University of Virginia community and the State of Virginia in a professional manner in accordance with the University of Virginia’s Computing Policies.