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.

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

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

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

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

From · 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
To · ICS

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.

terminal
$ cv convert sheet.xlsx sheet.ics
$ cv convert sheet.xlsx sheet.ics

Questions.What people ask about XLSX to ICS.

01OF 04

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.

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