How to Import iCal Into iWork Numbers

by Jefe Nubarron

It is possible to import iCal calendars into Apple's iWork spreadsheet "Numbers." In order accomplish this, you must convert your data into an intermediary format. The comma separated value (CSV) format is an intermediary format that is accessible both from iCal and Numbers. Unfortunately, iCal does not save a calendar file in CSV. You will require a utility application to convert from iCal standard (ICS) to CSV. Once your calendar is in the CSV format, Numbers is equipped to import it.

Export your iCal calendar. iCal backs up calendars to ICS files. From the "File" menu in iCal, choose "Export."

Convert your ICS file to a CSV file. It is a simple text conversion, but it requires a utility. A freeware application is available for download from Félix Chénier. Look for "ics2csv.dmg.zip." Other applications can also handle the task, such as Mozilla SunBird or iCalMaker. (Find links to all in Resources.)

Import the CSV file into Numbers. You can either drag the CSV file into Numbers, or you can choose "File" then "Open" from the menubar.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

About the Author

Jefe Nubarron has been writing technical articles since 1995. He has been published in technical magazines and on popular websites. He has a Bachelor of Arts in anthropology and is working on additional coursework towards a master's degree.

More Articles

Photo Credits