How to convert ical to csv

Written by lawrence nyveen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to convert ical to csv
If you keep track of hours worked in iCal, you can easily calculate sums in a spreadsheet. (Jupiterimages/BananaStock/Getty Images)

Apple's iCal can export a calendar, but only in ICS format, which is a multi-platform calendar format used by Google Calendar and Mozilla Sunbird as well as iCal. Sometimes you need to convert iCal data to a comma-separated values file to perform time-sheet calculations or to render the data importable by a calendar program that can't handle the ICS format. To convert an ICS file into a CSV file, you need to use a third-party tool.

Skill level:
Easy

Other People Are Reading

Instructions

    ICS2CSV

  1. 1

    Download "ics2csv.dmg.zip" from the FelixChenier (felixchenier.com) website.

  2. 2

    Double-click on the downloaded "ics2csv.dmg.zip" file to expand it into "ICS2CSV.dmg."

  3. 3

    Double-click on "ICS2CSV.dmg" to mount the ICS2CSV disk image. Double-click on the disk image to open it. The only file in the disk image is "ics2csv.command."

  4. 4

    Double-click on "ics2csv.command." This file is a script that will automatically open the Terminal application, search your hard drive for iCal calendars and convert them into CSV files. You will find the CSV files in your user directory.

    Mozilla Sunbird

  1. 1

    Download Mozilla Sunbird (mozilla.org) and double-click on it to expand the disk image. You don't have to install Sunbird; you can run it right from the application found in the disk image.

  2. 2

    Open iCal. Click on the "File" menu, then on "Export..." and then on the "Export..." that appears in the sub-menu. Name your file and select where to locate it. ICal will create an ICS file.

  3. 3

    Open Sunbird. Click "Import..." in the "File" menu. Find the ICS file and click the "Open" button. Sunbird will import the ICS file.

  4. 4

    Click "Export Calendar..." in Sunbird's "File" menu. Name the file to be exported and select where you want to create it. In the "Save As" drop-down menu, click "Outlook Comma Separated Values (*.csv)" and click the "Save" button to save your calendar as a CSV file.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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