YoteiCSV to ICS: turn a spreadsheet into a calendar file
Short answer: choose a CSV file with one event per row, check the preview, and download one .ics file. It reads the columns Google Calendar uses (Subject, Start Date, Start Time and so on) and common variations. The file is read in your browser and is not uploaded.
No account. Nothing uploaded. Free.
2. Check the events
More options
3. Download the calendar file
Which columns it reads
| Column name | Meaning |
|---|---|
| Subject, Title, Summary, Name | The event title (required) |
| Start Date, Date | The day of the event (required) |
| Start Time, Time | The start time. Leave it empty for an all-day event. |
| End Date | The last day, for events that run over several days |
| End Time | The end time |
| All Day Event | True or False |
| Location, Place | The place |
| Description, Notes | The notes |
Dutch and German headers such as Titel, Datum, Starttijd and Beschreibung work too. The separator can be a comma, a semicolon or a tab, and the page detects which one you used. Press "Download a template" for a file you can fill in.
Dates and times it accepts
- 2026-11-17, the safest format.
- 11/17/2026 or 17/11/2026 and 17-11-2026. Choose the date order above the preview.
- Times as 14:30, 14.30 or 2:30 PM.
- A date and a time together in one cell, such as 2026-11-17 14:30.
From Excel or Google Sheets to a calendar
- Put one event in each row and name the columns as in the table above.
- Excel: choose File, Save As, CSV (Comma delimited). Google Sheets: File, Download, Comma-separated values.
- Choose the file here and check the preview. Rows that cannot be read are listed with their row number.
- Press "Download .ics file" and import it into your calendar.
How to use the file
- Google Calendar: open the downloaded file, or use Settings, Import and export, Import.
- Outlook: double-click the file, or use File, Open and export, Import/Export.
- Apple Calendar: double-click the file and choose the calendar to add it to.
- iPhone and Android: open the file from your email or your Files app and choose your calendar app.
More detail in our guides to importing an .ics file into Google Calendar, Outlook and Apple Calendar and to opening an .ics file on Windows, Mac, iPhone and Android.
Good to know
- Thousands of rows are fine. The preview shows the first 200, the file contains all of them.
- The options under "More options" (time zone, reminder, repeat, guests) apply to every event.
- Importing the same file twice adds the events twice, because each download gets new ids.
- A time zone is a setting for the whole file. For rows in different zones, make one file per zone.
For events that live in a screenshot
Plans often arrive as a screenshot, a chat or a PDF you cannot copy from. Yotei is a Windows and Mac app that reads the event from your screen: press a shortcut, drag a box around it, check the details and confirm. It adds the event to Google Calendar, Outlook or iCloud directly. See how Yotei works, or test it yourself in your browser.
FAQ
How do I convert a CSV file to ICS?
Choose the CSV file or paste its text, check the preview and press "Download .ics file". The file works in Google Calendar, Outlook and Apple Calendar.
Can I convert an Excel file to ICS?
Save the sheet as CSV first (File, Save As, CSV), then use this page. Keep one event per row and name the columns Subject, Start Date and Start Time.
Is my file uploaded?
No. It is read in your browser with the file reader of the browser. Nothing is sent to a server.
What if some rows are wrong?
Rows with no title or no readable date are skipped, and the page lists each one with its row number so you can fix the sheet.
Does it work with a Google Calendar CSV export?
Yes. It reads the columns Google Calendar uses, including All Day Event, Location and Description.
Which date format should I use?
Use 2026-11-17 when you can. For 11/17/2026 or 17/11/2026 pick the date order next to the buttons.