Import a CSV into Google Calendar

Google Calendar does import CSV files — but only if the headers are its own (Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location, Private) and the dates are in US month/day/year order. Anything else fails with a vague error or lands on the wrong day. Koyomi converts your CSV to an .ics, which Google imports without argument.

A teacher with a term timetable exported from the school system usually has none of Google's headers: Class, Room, Date, Period start, Period end. Koyomi matches what it can, lets you map the rest with dropdowns, and reads dates in day-first order if that's what the file uses — no rewriting columns in a spreadsheet first.

Preview the events, download the .ics, then use Import in Google Calendar's settings (steps below). If you re-export the timetable after a change and import it again, the events are updated rather than duplicated.

After you download the .ics

Google Calendar

  1. Open calendar.google.com on a computer (the mobile apps can't import files).
  2. Click the gear → Settings → Import & export.
  3. Select the .ics file, choose which calendar to add the events to, and click Import.

Frequently asked questions

Why not just use Google Calendar's own CSV import?
You can, if your file matches Google's header names and US date format exactly. Most exports don't. Converting to .ics sidesteps both rules, and you see exactly what will import before you commit.
Which Google Calendar will the events go into?
You choose at import time. Google's import dialog has a dropdown for the destination calendar; create a new calendar first if you want the timetable kept separate from personal events.
Can I import from the Google Calendar app on my phone?
No. The mobile apps have no import feature at all. Use calendar.google.com in a browser on a computer; the imported events then sync to the phone app like everything else.
I imported the same file twice. Do I get duplicates?
Koyomi gives each event a stable ID that stays the same when you convert the same spreadsheet again, so a re-import updates events in most calendar apps rather than adding a second copy. Rows you deleted from the sheet stay until you remove them by hand.
Is my spreadsheet uploaded anywhere?
No. Parsing and the .ics file are produced entirely in your browser — the file never leaves your device. That's also why there is no size limit, no queue and no account.
Is this really free?
Yes. Every input format, every option, no sign-up, and nothing added to the calendar file.
Does it support recurring events?
Not yet. Each row becomes one single event. For a weekly class or shift, put one row per occurrence — filling a date column down in a spreadsheet takes seconds.