Convert ICS to XLSX
Turn ICS files into XLSX. One sheet named after the file with a row per event under a header of every property in first-seen order.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop ICS files on the dialor turn it to pick what to do
Calendar events as rows in a sheet.One row per event, with every property in its own column.
What you get
An Excel workbook with one sheet, named after the file. Each event in the ICS file becomes a row.
The header row lists every property found in the file, in the order each one is first seen. The header row stays text.
How times and people are written
Times become ISO 8601 text. The time zone of the start is written under TZID.
Attendees and the organizer are written as Name <address>, so each cell shows who and where to reach them.
What it leaves behind
Parameters other than those are dropped. Alarms are dropped too, and so are time zone definitions. The sheet holds the event properties, not the reminders or the zone rules behind them.
To go the other way, use XLSX to ICS. To combine several calendars first, try merge ICS.
ICS and XLSX.What each format is.
The formats
iCalendar
iCalendar events and calendars.
- Extensions
- .ics .ical
- MIME type
- text
/calendar - Kind
- Text and data
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
In your code.The same ICS to XLSX conversion through the API, for your app or your agent.
$ cv convert report.ics report.xlsx$ cv convert report.ics report.xlsxQuestions.What people ask about ICS to XLSX.
Yes. Every event becomes one row under the header, and the sheet is named after the file.
As ISO 8601 text. The time zone of the start is in the TZID column.
Attendees and the organizer are written as Name <address>.
No. Alarms are dropped, along with other parameters and time zone definitions.