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).
How to obtain CSV file from Yahoo Calendar:
- Login to Yahoo! Calendar
- Go to Options (there's a link on the right side of the page).
- Select Import/Export.
- Choose Export to Outlook (.csv).
- 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.