Skip to content
Blink Brief
Language:

Free tool · Office and email

CSV to ICS converter: turn Excel or Google Sheets rows into calendar events, recurring weekly events included, free

By Blink Brief · Published  · Updated  · How pages are made

To turn rows from Excel, Google Sheets or an AI chat into calendar events, paste them below, or open a CSV file. Check each event in the preview, then download one .ics file that Google Calendar, Outlook and Apple Calendar import. It’s free, and the rows never leave this browser tab.

Turn rows into one .ics calendar file

This converter needs JavaScript. To import a table into Google Calendar by hand, on a computer:

  1. Give the first row Google’s English headers: Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location, Private. Google says only the first two are required.
  2. Write the dates as Google’s example does, such as 05/30/2020, and the times such as 10:00 AM. Save the sheet as a CSV file.
  3. In Google Calendar, open Settings, choose Import & export, select the file from your computer, choose the calendar, and click Import.

How it works

  1. Paste the rows, or choose a .csv file. Try a sample fills in a weekly class, three work shifts and a two-day trip.
  2. Check the columns. The converter reads the header row and guesses what each column holds: title, date, start time, end time, end date, all day, location, description, or the date a weekly repeat ends. Each column has a list to change the guess.
  3. Check the preview. Every event is listed with its row number, day, times and place, as your calendar will read it. A row it can’t read is named above the list, with the reason, and left out.
  4. Download .ics. One file holds every event. Nothing is written until you press it. Copy as text copies the same calendar text instead.

The file follows the iCalendar standard (RFC 5545): UTF-8 text, lines of at most 75 octets, and a unique ID and a time stamp on each event, written the way the site’s ICS viewer writes them. It reads a file of up to 5 MB and lists every event it will write.

It doesn’t sync with your sheet: if the sheet changes, convert it again and import the new file. It writes no reminders, guests or colors.

Paste from Excel, Google Sheets or an AI chat

  • Excel or Google Sheets: select the cells with the header row, copy, and paste. The cells arrive separated by tabs, and the converter reads them as they are.
  • A CSV file: commas or semicolons, as Excel saves a CSV in Germany, France, Italy or Spain. The converter picks the separator itself, and a value in quotes may hold a comma. A CSV that isn’t UTF-8 is read as Excel’s Windows encoding; on the Japanese page, or in a browser set to Japanese, as Shift_JIS, the encoding of a CSV saved by Excel in Japan.
  • An AI chat’s table: copy the table the chat shows, or its Markdown text (rows like | Date | Start | Title |). The line of dashes under the header is skipped, and so are sentences before the table.

Header words are read in English, German, Spanish, French, Italian and Japanese: Subject, Title or Event; Date or Start Date; Start or Start Time; End or End Time; All Day; Location or Place; Description or Notes; Repeat weekly until. Datum, Beginn, Ende and Ort work, as do Fecha, Inicio, Fin, Lugar, or 件名, 日付, 開始, 終了, 場所. With no header row, it guesses from the cells: dates, times, then text for the title.

An AI can get a date or the year wrong when it builds a schedule. Compare the preview with what you asked for before you download.

Dates, times and time zones

  • Dates are read as numbers with the year: 2026-11-16, 2026/11/16, 11/16/2026, 16/11/2026, 16.11.2026 or 16/11/26. Date order is set from your rows when they leave no doubt (16/11/2026 can only be day first). When every date could be either, such as 03/04/2026, the converter reads them in your device’s usual order, says so above the preview, and you change Date order if it’s wrong. A date written in words (Nov 16) isn’t read: ask the AI for dates as 2026-11-16, or change the cells’ format in the sheet.
  • Times are read as 9:00, 09:00, 9:00 AM, 21:00 or 9.00. A date and a time in one cell (2026-11-16 09:00) work too, and so does a start and end in one cell (9:00–10:30).
  • No end time: the event lasts one hour, or what you pick under Events with no end time last. An end before the start, as on a night shift from 22:00 to 6:00, ends the next day, and the row says so.
  • No time at all: a row with a date and no start time is an all-day event, and an End date makes it last several days.

Time zone starts at the zone this device is set to. The file then names that zone on every event (a TZID, with the zone’s rules written in the file), so a 9:00 class stays at 9:00 in that city whoever imports it. Floating (each calendar’s own zone) writes the times with no zone: each calendar shows 9:00 in its own zone, which suits a file you import only into your own calendar. The line above the preview says which one the file uses. After importing, open the first event in your calendar and check its time.

Repeating events (weekly)

A weekly class or a standing shift needs one row. Add a column named Repeat weekly until and give that row the last date; leave it empty on rows that happen once. The event repeats on the same weekday each week up to that date, and the preview says “Every week until …”.

Weekly is the only repeat it writes. For a monthly meeting or a class every two weeks, give each date its own row. Google’s own CSV import has no repeat column, and Google warns that repeat events imported from a .csv file “might not show up that way”; in the .ics file the repeat is a standard rule (RRULE) that calendars read when they import it.

Import the .ics: Google Calendar, Outlook, Apple Calendar, a phone

Import into a new, empty calendar first if you can: when something looks wrong, deleting that calendar removes every imported event at once.

Google Calendar (on a computer)

  1. Open Google Calendar, then Settings from the gear at the top right.
  2. Choose Import & export, then Select file from your computer, and pick the .ics file.
  3. Choose the calendar to add the events to, and click Import.

Google’s help says you can import ICS and CSV files on a computer; its phone apps don’t import. The Excel to Google Calendar guide covers shift and class schedules step by step.

Outlook.com and Outlook on the web

  1. Open the calendar and select Add calendar, then Upload from file.
  2. Select Browse, choose the .ics file, and select Open.
  3. Select the calendar to import it to, and select Import.

New Outlook for Windows, classic Outlook and Outlook for Mac each import an .ics their own way: Import an .ics file into Outlook has each one from Microsoft’s pages, and Excel to Outlook Calendar starts from the spreadsheet.

Calendar on a Mac

Apple’s guide: in Calendar, choose File › Import, select the file, and click Import; then choose the calendar for the events and click OK. Dragging the file into Calendar works too.

Only a phone

The Google Calendar app can’t import an .ics file; Google’s help sends you to a computer. Download the .ics, press Open it in the ICS viewer, choose the file there, and add each event with Add to Google Calendar or Add to Outlook, one event per button. On an iPhone, the iPhone .ics guide has Apple’s routes.

Privacy

The file you open or the rows you paste are read in this browser tab and never uploaded: the page has no server that sees them. The .ics file is made in the tab and handed to your downloads. Close the tab and the rows are gone; nothing is saved.

Already have an .ics file? The ICS viewer opens it, lists its events, and saves them back to a spreadsheet with Download for Excel (.csv).

Questions

How do I convert Excel to ICS?

Select the cells in Excel, header row included, copy them, and paste them into the box on this page. Check the preview, then press Download .ics. Or save the sheet as CSV (File › Save As, CSV) and press Choose a .csv file. An .xlsx workbook can’t be read directly.

Can ChatGPT make an ICS file?

It can write the text of one, but an AI can get a date, a time zone or the year wrong. Ask it for a table instead (title, date, start, end, place), paste the table here and check every row in the preview before you download. To check .ics text an AI already wrote, paste it into the ICS viewer; this guide has the details.

Can Google Calendar import a CSV?

Yes, on a computer. Google’s help says the headers must be in English (Subject, Start Date, Start Time and so on) and that only Subject and Start Date are required. Its list has no repeat column, and it warns that repeat events from a .csv file “might not show up that way”. The .ics file from this page takes headers in your language and keeps weekly repeats.

Does it work on a phone?

The converter works in a phone’s browser. The Google Calendar app can’t import a file, though: Google’s help sends you to a computer. On a phone only, download the .ics, open it in the ICS viewer, and add the events one by one with Add to Google Calendar or Add to Outlook.

Sources