Convert XLSX to ICS
Turn XLSX workbooks into iCalendar. Each row of the first worksheet, or of the one sheet names, becomes an event keyed by the header row: title, summary or subject becomes the title, start, date or dtstart the start, end the end, location, place or where the location and notes or description the description, and timezone sets the time zone; other columns stay as their own properties.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLSX files on the dialor turn it to pick what to do
A calendar built from spreadsheet rows.Each row of your workbook becomes one event in a single ICS file.
What you get
One ICS file with an event for every row. The header row says what each column means, so the file is built from the column names, not from their position.
A column named title, summary or subject becomes the event title. A column named start, date or dtstart becomes the start, and end becomes the end. Location, place or where becomes the location, and notes or description becomes the description. A timezone column sets the time zone.
Columns with other names are not dropped. They stay in the event as their own properties.
Which sheet is read
Every worksheet is converted when you leave Sheet out. Set Sheet to a worksheet name, or to its number counting from 1, to convert only that one.
When a row fails
Each event needs a start. A row without one stops the conversion with
unsupported_elements. Add a start, date or dtstart value to that row, or take the row out, before you convert again.To go the other way, use ICS to XLSX.
XLSX and ICS.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
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
iCalendar
iCalendar events and calendars.
- Extensions
- .ics .ical
- MIME type
- text
/calendar - Kind
- Text and data
In your code.The same XLSX to ICS conversion through the API, for your app or your agent.
$ cv convert sheet.xlsx sheet.ics$ cv convert sheet.xlsx sheet.icsQuestions.What people ask about XLSX to ICS.
Title, summary and subject give the title. Start, date and dtstart give the start. End gives the end. Location, place and where give the location, notes and description give the description, and timezone sets the time zone.
They stay as their own properties on the event. They are not thrown away.
Yes. Set Sheet to the worksheet's name or its number counting from 1. Without it, every worksheet is converted.
A row has no start. Give every row a start, date or dtstart value and convert it again.