How to Export iCal to Excel

Written by dan howard
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Export iCal to Excel
iCal exports calendar information into an ICS text file. (Jupiterimages/Brand X Pictures/Getty Images)

Apple's iCal is a calendar application that you can use to plan and display events on a graphical calendar. If you export iCal information to a file then the application saves your calendar information to a delimited text file with the ICS file extension. You can view your ICS in any text editor such as Notepad or Microsoft Word. You can also import ICS files into Microsoft Excel using Excel's Text Import Wizard.

Skill level:


  1. 1

    Run the iCal application.

  2. 2

    Click the name of the calendar that you wish to export to Excel under the "Calendars" heading.

  3. 3

    Click "File" in the menu bar and click "Export." Select a location for the file. iCal exports your calendar information into an ICS delimited text file.

  4. 4

    Run the Microsoft Excel application.

  5. 5

    Click the "File" tab and then click "Open." Navigate to the folder that contains your ICS file and open the file in Excel. Excel will run the Office Text Import Wizard to convert your ICS data into Excel format.

  6. 6

    Check the box next to the ":" colon entry under the "Delimiters" heading.

  7. 7

    Click "OK" to save your settings and import your ICS calendar data into Excel.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.