How to export Google Calendar to Google Sheets

By Jake Marsh · Updated

To export Google Calendar to Google Sheets, open a spreadsheet, choose Extensions > Cellendar > Import from Calendar, pick the calendar and a date range (or This month, Next 90 days or This year), then click Import to a new tab. Every event in that range becomes a row with its title, start, end, all-day flag, location, description, guests, color, reminders and Google Meet link. Google Calendar's own export only downloads an .ics file of a whole calendar, which Sheets can't open as rows.

Steps

  1. Open any Google Sheet (a new one is fine) and choose Extensions > Cellendar > Import from Calendar. The sidebar opens on the Import tab.
  2. Set the Calendar to export from. Leave it as "primary" for your main calendar, or paste another calendar's ID, found in Google Calendar under the calendar's settings > Integrate calendar.
  3. Set From and To, or click a preset: This month, Next 90 days or This year.
  4. Decide how repeating events appear. Tick One row per occurrence of repeating events to get every meeting of a weekly series as its own row. Leave it unticked for one row per series, with the rule in a Repeat column.
  5. Click Import to a new tab. Cellendar writes the events to a new tab and tells you how many it imported.

What the new tab contains

ColumnWhat you get
TitleThe event name
Start, EndDate and time as real Sheets dates, in the sheet's time zone
All dayChecked for all-day events
Location, DescriptionAs written in the event
GuestsGuest email addresses
ColorThe event's color
RemindersSuch as 10m or email 1d
Google MeetThe meeting link, if there is one
Sync, Cellendar statusUsed if you sync the tab back to Calendar

Uses for the export

  • Hours and billing. Add a column with =(C2-B2)*24 for each event's length in hours, then a pivot table by title or by week.
  • A meeting log for a client or project, filtered by title or guest.
  • Planning changes in bulk. The tab is already set up for two-way sync: edit titles, times or locations in the sheet and click Sync now to push the changes to the events, as described on the Cellendar page.

How much it uses of the trial

An import uses one trial change per 25 events, so exporting 500 events uses 20 of the trial's 100 changes. Paid plans ($7.99 a month or $59 a year) have no limits.

What it costs

Cellendar is $7.99 a month or $59 a year per Google account. Free trial: 100 event changes or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Cellendar page.

Cellendar

Two-way sync between Google Sheets rows and Google Calendar events $7.99 a month or $59 a year per Google account.


Questions

Can I export Google Calendar to Excel?

Yes. Import into Google Sheets with Cellendar, then use File > Download > Microsoft Excel in Sheets.

Can I export only some of my events?

You choose the calendar and the date range. To keep only some events, filter the tab after importing and delete the rows you don't need; that doesn't touch the events in Calendar.

Does the export update by itself?

The imported rows stay linked to their events, so with two-way sync on, edits to those events in Calendar come back on the next sync. Events added to Calendar after the import aren't picked up; import that range again to get them.

Does exporting change anything in my calendar?

No. Importing only reads events.


More Cellendar guides


More Google guides