TimelineKit › Guides › CSV or spreadsheet to timeline

Turn a CSV or spreadsheet into a timeline

Already have your dates in a spreadsheet? Export it as CSV and import it. No need to publish your sheet to the web.

Columns

The first row must name the columns. TimelineKit needs start and title; end, category, color (like #4f46e5), note and link are optional. Common alternatives such as date, event, group and description are recognized too.

start,end,title,category,note
1969-07-16,1969-07-24,Apollo 11,Missions,First Moon landing
44 BC,,Death of Caesar,Rome,

Import steps

  1. In Excel or Google Sheets choose File, then Download or Save as, CSV.
  2. In TimelineKit open a timeline and choose Import CSV.
  3. Rows with problems, such as an end date before the start, are listed by row number and skipped; the rest are added.

Privacy

The CSV is read by your browser. Nothing is uploaded unless you publish the timeline.

Open this template Start a blank timeline

FAQ

Which date formats work in CSV?

ISO dates (2024-05-01), years (1066), months (1914-07 or March 1914) and BC dates (44 BC) all work.

Can I export back to CSV?

Yes. Export CSV writes the same columns, so you can round-trip through a spreadsheet.

More guides