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 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 | Location | UID |
|---|---|---|---|---|---|---|---|---|
| My important event | 04/19/2012 | 6:00pm | 04/19/2012 | 9:00pm | false | Longer Description | San Francisco CA | abcdefghij@google.com |
| An all-day event | 04/19/2012 | 04/19/2012 | true | Missing times are OK | New York NY | klmnopqrst@yahoo.com | ||
| A multi-day event | 04/19/2012 | 6:00pm | 04/20/2012 | 6:00pm | false | Start date and end date are different | Las Vegas NV | uvwxyz@outlook.com |
Use at your own premises
This time-tested CSV to iCal Convertor is now available for use at your own premises. You can purchase a license to install it on multiple servers for multiple users, as long as they are all affiliated with your organization.
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.
If it fails to convert your calendar, please feel free to reach out to me. My contact information is available in the sidebar.
Privacy Policy
Files that you submit for conversion via this tool may be retained and analyzed to improve the tool.