Manas Tungare

Blog • Résumé • Software

CSV to iCal Calendar Convertor

Use this tool to convert a calendar from the CSV format (commonly used by Yahoo Calendar and Microsoft Outlook) to the iCalendar format (used by Google Calendar, iPhone, and iCal).

  1. Upload a CSV file: (Need help obtaining this file?)

  2. Typically, this is the timezone of the place you are at. If your events show up at the wrong time (e.g. every event is 4 hours late) then you probably need to pick a different time zone.

  3. (E.g. birthdays and anniversaries.) Due to the limited information in a CSV file, it is not possible to include accurate data about repeated events (e.g. weekly, monthly, or yearly events.) This option is a heuristic workaround that lets you select what to do with such events.

  4. and look in your Downloads folder!

How to obtain CSV file from Yahoo Calendar:

  1. Login to Yahoo! Calendar
  2. Go to Options (there's a link on the right side of the page).
  3. Select Import/Export.
  4. Choose Export to Outlook (.csv).
  5. Save the file somewhere on your disk.

How to make your own CSV file

If you have existing data that you’d like to use with this tool, you can create a CSV file using any spreadsheet editor. CSV stands for comma-separated value, so a CSV file only means that whatever data it contains is separated by commas. In order for this conversion to succeed, the file must contain certain specific data fields, in a certain order, with data in a certain format. Not all CSVs are created equal: to be compatible, the CSV must have the following fields, in order.

Subject Start Date Start Time End Date End Time All Day Description
My important event 04/19/2012 6:00pm 04/19/2012 9:00pm false Longer Description
An all-day event 04/19/2012 04/19/2012 true Missing dates are OK
A multi-day event 04/19/2012 6:00pm 04/20/2012 6:00pm false Start date and end date are different

Disclaimer and Known Issues

This service is provided as-is and with no warranties, and this conversion may not work for all calendars.

Because of the limited information that is available in the exported file, conversions will not be perfect. For example, repeated events are not correctly included in Yahoo's CSV file. Hence, for an event that repeats, say every year, you will see one entry for each such year, up to the year 2038. The convertor does not automatically detect such erroneous duplicates at this point, though this may change in the future.