Calendar:Import Export
Calendar can import data in iCalendar (iCal) and Comma Separated Value (CSV) formats. Export is possible in these formats and is additionally in Hypertext Markup Language (HTML).
iCalendar
Recommended for data exchange. The format is standardized in RFC 2445 and widely used.
Comma Separated Value
CSV import and export is optimized for collaborating with Outlook which can't handle the iCal format in the necessary extent. CSV offers an easy way to exchange data with spreadsheets or word processors.
Currently Calendar needs "well formed" CSV files. The first line should contain the header names. Each header name and each data field has to be enclosed in double quotes. Data fields need to be separated with commas.
Effective as of version 0.8: Mandatory are the two fields "Subject" and "Start Date" in their localized naming only. Recommended date format is YYYY-MM-DD with a four digit year at the beginning. Time format should be HH:MM:SS with 24-hour values. Calendar will also understand dates and times in the locale scheme of the operating system but data format must not change within a file. The universal indicators AM, a.m., PM and p.m. are always recognized.
The header names are localized and follow Outlook. Column order is not important. If the two mandatory headers could not be recognized all files with 22 headers are assumed to have the column order of an English CSV file from Outlook .
Sample CSV file
"Subject","Start Date" "Berlin Wall came down","1989-11-09"
Hypertext Markup Language
HTML export gives an event list with the todo items on top of that list.