Guide · Office and email
How to import an Excel or Google Sheets schedule into Google Calendar (shifts, classes, events)
By Blink Brief · Updated · How pages are made
To import an Excel or Google Sheets schedule into Google Calendar, copy the rows (header row included) and paste them into the free CSV to ICS converter. Check the events in its preview, press Download .ics, then on a computer open Google Calendar › Settings › Import & Export and import the file into the calendar you choose. That route writes weekly repeats (a Repeat weekly until column), reads headers in English, German, Spanish, French, Italian or Japanese, and your date order. Google's own CSV import works too, if the first row uses Google's English headers; it has no column for a repeat. On a phone only, open the .ics in the ICS viewer and add the events one by one.
Short answer
- Any sheet, repeats included: CSV to ICS › paste › check the preview › Download .ics › Google Calendar on a computer › Settings › Import & Export.
- A CSV already in Google's format: English headers Subject and Start Date at least, commas between fields, then Import & Export.
- Only a phone: the Google Calendar app doesn't import. Make the .ics, open it in the ICS viewer, Add to Google Calendar on each event.
The quickest way: CSV to ICS, then Import & export
- In Excel or Google Sheets, select the schedule with its header row and copy it. Or keep it as a .csv file and use Choose a .csv file. A table from ChatGPT, Claude or Gemini can be pasted as it is.
- Paste it into the box on CSV to ICS. The converter reads the header row and guesses what each column holds; What each column holds has a list per column to change a guess.
- Check Date order (it asks when a date like 03/04/2026 could be read both ways), Time zone, and how long Events with no end time last. Read the preview: each event with its row number, day, times and place. A row it can't read is named above the list, with the reason.
- Press Download .ics. One file holds every event.
- On a computer, open Google Calendar. At the top right, click Settings, then Import & Export on the left.
- Click Select file from your computer, choose the .ics file, choose the calendar to add the events to, and click Import.
The converter doesn't read an Excel workbook (.xlsx): copy the cells, or save the sheet as CSV. It writes no reminders, guests or colors, and it doesn't sync: when the sheet changes, convert it again and import the new file. The rows you paste are read in this browser tab and never uploaded; close the tab and they're gone.
After the import, open the first event in Google Calendar and check its day and time. If the schedule came from an AI chat, check the dates and the year against what you asked for: an AI can get a date or a time zone wrong.
Google's own CSV import: the headers it needs
Google Calendar imports a CSV directly, on a computer, through the same Import & Export. Its rules, from Google's import page:
- English headers. "To import into Google Calendar, the headers must be in English." The list: Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location, Private.
- Two required. "Only the first 2 headers in this list are required": Subject and Start Date.
- Google's examples write dates as 05/30/2020 and times as 10:00 AM; All Day Event and Private take True or False.
- Commas. Google's troubleshooting page: "Google Calendar doesn't work with files that use a semicolon ( ; ) or colon ( : ) to separate fields." Excel saves a CSV with semicolons where the comma is the decimal mark, as in Germany, France, Italy or Spain. A value with a comma in it goes in quotation marks.
- Size. Files up to 1 MB.
Fix your CSV's headers for Google Calendar
It renames headers it recognises, in English, German, Spanish, French, Italian or Japanese, and changes nothing else: not your dates, times or separators. What you paste stays in this tab.
To do it by hand:
- Rename the column with the event names
Subjectand the column with the datesStart Date. - Rename the others, if you have them:
Start Time,End Date,End Time,All Day Event,Description,Location,Private. Delete any other column. - Save as CSV with commas, then import it in Google Calendar › Settings › Import & Export.
With the headers fixed, the CSV route still leaves the dates as you wrote them; check that Google reads them as you meant (Google's examples are month first). If your sheet has semicolons, dates in another order, or repeats, CSV to ICS is less work.
Work shifts and class schedules (repeats)
Google's CSV list has no repeat column, and Google warns: "If you import repeat events from a .csv file, they might not show up that way. They'll be on your calendar as a series of one-time events." For a rota or a timetable, that means one row per date.
An .ics file can carry the repeat as a rule (RRULE, in the iCalendar standard, RFC 5545). In CSV to ICS, add a column named Repeat weekly until and give a row the last date: the event repeats on the same weekday each week up to that date, and the preview says "Every week until …". Leave it empty on rows that happen once.
- A weekly class (Tuesday 18:00–19:30 until the end of term): one row with Repeat weekly until.
- Shifts that change every week: one row per shift. A night shift from 22:00 to 6:00 ends the next day, and the preview row says so.
- Every two weeks or monthly: weekly is the only repeat the converter writes, so give each date its own row.
Only a phone: add events one by one
The Google Calendar app can't import a file. Google's import page for Android, iPhone and iPad says only: "To import events, open Google Calendar on your computer." Without a computer:
- In the phone's browser, paste the rows into CSV to ICS and press Download .ics.
- Press Open it in the ICS viewer and choose the downloaded file there.
- Tap Add to Google Calendar on each event. Sign in to Google in the phone's browser first: signed out, Google opens its home page instead of the event.
Each button adds one event, and a weekly repeat stays a repeat in Google. When you press it, that one event's title, times, place and notes go to Google in the link that opens your calendar. For twenty shifts, a computer is quicker. More in importing an .ics file to Google Calendar on Android or iPhone.
Import into a new calendar first (and how to undo)
An import adds every row at once, and Google has no undo for it. A calendar of its own makes a bad import easy to remove:
- In Google Calendar on a computer, next to Other calendars, click Add other calendars › Create new calendar, name it (for example "Shifts, November") and click Create calendar. Google says new calendars can only be created in a browser.
- Import the file into that calendar in the Import & Export step.
- If the events are wrong, open Settings, select that calendar, and click Remove calendar › Delete › Delete permanently. Its events go with it. Fix the sheet and import again.
Google's primary calendar can't be deleted, only emptied of all its events, which is why the import shouldn't go there first. If Import shows "Processed zero events" after a second click, Google says the first click worked: check the calendar before importing again.
Google Sheets: Apps Script, if you need it to update
A file import is a copy: when the sheet changes, the calendar doesn't. Google's own answer for a sheet that should feed a calendar is code. Its Google Workspace blog tip "How to automatically add a schedule from Google Sheets into Calendar" (December 19, 2018) walks through an Apps Script that reads a range of the sheet and creates events in a calendar you name by its ID. It is a script you write and run in the sheet, not a setting.
For a schedule that changes once a term or once a month, converting again is simpler: delete the old calendar, make a new one, import the new file. To put the same schedule into Outlook as well, see importing an Excel schedule into Outlook Calendar.
What we tested: the header fixer on this page, and CSV to ICS with our own sample rows (comma, semicolon and tab separators; English, German and Spanish headers), with the .ics it wrote opened in the ICS viewer, in Chromium and WebKit. We didn't import into a Google account: the Google steps are Google's own.
Questions
Can you import an Excel calendar into Google Calendar?
Yes, on a computer. Either save the sheet as a CSV with Google's English headers (Subject and Start Date are required) and import it in Google Calendar › Settings › Import & Export, or paste the rows into the free CSV to ICS converter and import the .ics file it makes, which keeps weekly repeats. Google doesn't read .xlsx files: save as CSV or copy the cells.
Can I import a CSV to Google Calendar on my phone?
No. Google's help for the Android app says only: "To import events, open Google Calendar on your computer." On a phone, turn the rows into an .ics file with CSV to ICS, open that file in the free ICS viewer, and add each event with Add to Google Calendar.
Why does Google Calendar say my CSV has an error?
The usual causes on Google's own pages: headers that aren't Google's English ones, a file that uses semicolons instead of commas (as Excel saves a CSV in much of Europe), or a file over 1 MB. The header fixer on this page gives you Google's header row; CSV to ICS reads semicolons and headers in six languages.
Sources
- Google Calendar Help: Import events to Google Calendar: CSV headers in English; only Subject and Start Date required; repeats from a CSV become one-time events. Read on 9 November 2026.
- Google Calendar Help: Import events (Android): "To import events, open Google Calendar on your computer.". Read on 9 November 2026.
- Google Calendar Help: Fix problems importing: commas only, not semicolons; 1 MB. Read on 9 November 2026.
- Google Calendar Help: Create a new calendar: Add other calendars › Create new calendar, in a browser. Read on 9 November 2026.
- Google Calendar Help: Delete or unsubscribe from a calendar: Remove calendar › Delete › Delete permanently. Read on 9 November 2026.
- Google Workspace Blog: How to automatically add a schedule from Google Sheets into Calendar: December 19, 2018; Apps Script. Read on 9 November 2026.
- RFC 5545 (iCalendar): RRULE, the repeat rule. Read on 9 November 2026.