Import an Excel schedule into Google Calendar
Google Calendar won't open an Excel file. The usual advice is to save as CSV, rename the headers to match Google's, fix the dates, and hope. Koyomi replaces all of that: drop the .xlsx or .xls, check the preview, download an .ics, import.
Take a project plan with milestones and deadlines, one per row, plus an owner column and a notes column. Koyomi reads Excel's date cells as real dates (no Excel-to-CSV mangling), and you point Milestone at the title, Deadline at the start date and Notes at the description with dropdowns. Dates without a time become all-day events, which is usually right for deadlines.
Multi-sheet workbooks show a sheet picker, so a plan with one tab per phase can be converted a tab at a time into separate calendars. The workbook never leaves your browser.
After you download the .ics
Google Calendar
- Open calendar.google.com on a computer (the mobile apps can't import files).
- Click the gear → Settings → Import & export.
- Select the .ics file, choose which calendar to add the events to, and click Import.
Frequently asked questions
- Does Google Calendar import .xlsx directly?
- No. Google Calendar imports only CSV and ICS. ICS is the more reliable of the two: it carries exact times and timezones inside the file and doesn't depend on Google's header names.
- Should I convert to CSV or ICS for Google Calendar?
- ICS. Google's CSV import expects its own headers and US-style dates; ICS has neither restriction, and you can preview exactly what will land before importing.
- My deadlines have no time. Will they show as all-day?
- Yes. A row with a date and no time becomes an all-day event. If you add a Start Time column, it's used, with a default 60-minute duration when there's no end time.
- The workbook has a tab per phase. Do I convert each one?
- Yes, one sheet per conversion — pick the tab in the sheet picker and download an .ics for it. Import each file into the same Google calendar or a different one, whichever suits.
- 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.