How to Export iCal to Excel

Written by dan howard | 13/05/2017
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.

Run the iCal application.

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

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.

Run the Microsoft Excel application.

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.

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

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

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