Skip to content
Blink Brief
Language:

Guide · Office and email

How to export Google Calendar to Excel, a CSV file or Google Sheets

By Blink Brief · Updated  · How pages are made

To export Google Calendar to Excel, export the calendar as an .ics file, then turn that file into a CSV, which Excel and Google Sheets open. Google's steps, on a computer: under My calendars, point to the calendar, click More › Settings and sharing, then Export calendar. Choose the file that downloads in the converter on this page and press Download CSV, or open it in the free ICS viewer and press Download for Excel (.csv): every event becomes a row with its title, date, start and end time, time zone and place. The converter asks for no Google sign-in and no add-on: the file is converted in your browser.

Short answer

  • One calendar: My calendars › More › Settings and sharing › Export calendar. An .ics file downloads.
  • Every calendar: Settings › Import & export › Export. A .zip downloads with one .ics per calendar.
  • To Excel or Sheets: the converter below › Choose an .ics file › Download CSV.

Export the calendar from Google Calendar

Google's steps for one calendar, on a computer:

  1. Open Google Calendar.
  2. On the left, under My calendars, point to the calendar you want.
  3. Click More, then Settings and sharing.
  4. Under Calendar settings, click Export calendar.

Google: "An .ics file downloads to your computer." For every calendar at once, click Settings › Settings, then Import & export in the menu on the left, then Export: "A .zip file downloads to your computer." Unzip it and you have one .ics file per calendar. The whole route, with unzipping on Windows, a Mac and a Chromebook, is in exporting Google Calendar as an .ics file.

Turn the .ics file into a CSV

Choose the file you exported. The converter lists the events sorted by start, shows the first 20, and Download CSV saves every event as one row. Print or save as PDF prints the whole list on US Letter or A4, without the rest of this page.

Turn the Google Calendar .ics file into a CSV for Excel

The converter needs JavaScript. To make the list by hand:

  1. Open the .ics file in a text editor, such as Notepad or TextEdit.
  2. Each event runs from BEGIN:VEVENT to END:VEVENT. Copy its SUMMARY (title), DTSTART (start), DTEND (end) and LOCATION into one spreadsheet row.
  3. Read 20261116T090000 as 16 November 2026, 9:00. A Z at the end means UTC.

The file is read in this browser tab and never uploaded; close the tab and it's gone. In our test on 19 November 2026, Google's own Holidays in United States calendar, 317 events, came out as 317 rows in Chromium and in WebKit (the engines of Chrome and Safari).

The ICS viewer does the same from its own page and adds more: each event on screen in your own time zone, and Add to Google Calendar or Add to Outlook on each event. The file you open there is read in the browser tab and never uploaded. When you press Add to Google Calendar or Add to Outlook, that one event's title, times, place and notes go to Google or Microsoft in the link that opens their calendar.

What each column holds

The CSV has 13 columns, in this order:

  • Title, then Start date and Start time, End date and End time: dates as 2026-11-19, times as 09:30, in the zone the Google file gives them (a time it gives in UTC in your own time zone).
  • All day (Yes or No) and Hours: the length of each event, 1.5 for 90 minutes, ready to add up for a timesheet or a client report (a repeating event counts once).
  • Time zone: the zone the file names for that event, or your own zone for a time the file gives in UTC.
  • Location and Notes: the event's place and its description.
  • Repeats in words ("Weekly on Mon until 2026-12-14") and Repeat rule as the file writes it. A repeating event is one row, not one row per date.
  • Link: the event's web address when the file has one.

A cell that starts with =, +, - or @ gets an apostrophe in front, so a spreadsheet shows it as text and never runs it as a formula.

Open the CSV in Excel

Double-click the file. The CSV is saved as UTF-8 with a byte order mark, and Microsoft says: "You can open a CSV file encoded with UTF-8 normally if it was saved with BOM (Byte Order Mark)." Accented names and Chinese or Japanese titles keep their letters. If every value lands in one column, converting an .ics file to Excel shows how to bring it in from Excel's Data tab instead.

Open it in Google Sheets

Google's steps: open a spreadsheet in Google Sheets, click File, then Import, and choose the CSV. Pick an import option, such as Create new spreadsheet or Insert new sheets, and leave the separator on Detect automatically. .csv is on Google's list of file types Sheets imports.

Only some dates

Google's Export calendar gives the whole calendar as one .ics file, and the range is one filter away in the spreadsheet. The Start date column is written as 2026-11-19, so it sorts in date order as it stands: filter it to the month, the quarter or the year you need, and add up Hours for the rows that remain.

A shared calendar, or a work or school account

  • A calendar someone shared with you: Google says "You must have the "Make changes and manage sharing" permission for the calendar you wish to export." Ask its owner for that permission, or for the exported file.
  • Work or school: Google says "your administrator may restrict export settings." Ask your admin for it.
  • Your own calendar's link instead of a file: the calendar's iCal address downloads the same kind of .ics; getting the .ics link of a Google Calendar shows where it is and how to keep it private.

On a phone or a Mac

Google: "You can't export from the Google Calendar app." Do the export in a browser on a computer, a Mac included: Google's steps and the converter both run in Safari or Chrome. Going the other way, from a spreadsheet into the calendar, is in importing an Excel schedule into Google Calendar; the Outlook version of this page is exporting an Outlook calendar to Excel.

Questions

Can you export Google Calendar to Excel?

Yes, in two steps. Google Calendar exports an .ics file: on a computer, point to the calendar under My calendars, click More › Settings and sharing, then Export calendar. Choose that file in the converter on this page and press Download CSV, or open it in the ICS viewer and press Download for Excel (.csv). Excel opens the CSV with one row per event.

Can you export Google Calendar to Google Sheets?

Yes. Export the calendar as an .ics file, turn it into a CSV with the converter on this page, then in Google Sheets click File › Import and choose the CSV. Google's import options include Create new spreadsheet and Insert new sheets.

Can you export a date range from Google Calendar?

Google's export gives the whole calendar in one .ics file. After converting it here, the CSV has a Start date column written as 2026-11-19, so Excel or Google Sheets sorts and filters it: keep the rows of the month, quarter or year you need.

Sources