Convert TSV to ICS

Turn TSV files into iCalendar. One event per record: fields named title, summary or subject become 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 fields stay as their own properties.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop TSV files on the dialor turn it to pick what to do

A calendar file from rows of a table.Each row of the TSV becomes one event in a single ICS file.

  1. What you get

    One ICS file with one event per record. Columns are matched by their names, so the header row decides what each value becomes.

    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. A column named location, place or where becomes the location. A column named notes or description becomes the description. A column named timezone sets the time zone.

  2. Other columns

    Columns with other names are not dropped. Each stays in the event as its own property, under its own name.

  3. When it stops

    Every record needs a start. A record without one makes the conversion stop with unsupported_elements. Check that each row has a value in its start, date or dtstart column before you convert.

    To go the other way, use ICS to TSV.

TSV and ICS.What each format is.

The formats

From · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data
To · ICS

iCalendar

iCalendar events and calendars.

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

In your code.The same TSV to ICS conversion through the API, for your app or your agent.

terminal
$ cv convert sheet.tsv sheet.ics
$ cv convert sheet.tsv sheet.ics

Questions.What people ask about TSV 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. Timezone sets the time zone.

They stay in the event as their own properties, named after the column.

At least one record has no start. Add a value under start, date or dtstart for every row.

Many. Each record becomes its own event, and all of them go into one ICS file.

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