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.

  1. 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.

  2. 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.

  3. 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

From · ICS

iCalendar

iCalendar events and calendars.

Extensions
.ics .ical
MIME type
text/calendar
Kind
Text and data
To · XLSX

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.

terminal
$ cv convert report.ics report.xlsx
$ cv convert report.ics report.xlsx

Questions.What people ask about ICS to XLSX.

01OF 04

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.

More conversions.Other ways in and out of ICS and XLSX.