Move to Microsoft Exchange

Export Oracle Calendar Data for Excel 2004 for Mac

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

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

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 OK.
  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. Click OK.
  7. In the Save window, select where you want to save the file.
    • 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 Save.

Import Oracle Calendar Data into Excel 2004

  1. Open Microsoft Excel 2004.
  2. On the Project Gallery window, click Open Other.
  3. Browse to the location where the exported file from Oracle Calendar was saved.
  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.