How do I export Google Calendar to Excel?

Export the events to Google Sheets first, then use File > Download > Microsoft Excel (.xlsx) in Google Sheets. The rows and columns carry over to Excel.

Calrows

How to export Google Calendar™ to Google Sheets™ (any date range)

Q: How do I export only one month or a specific date range?

Calendar's own export has no date range. With the Calrows add-on, open Extensions > Calrows > Open sidebar, choose the calendar, set From and To dates under Import from Calendar, and click Import events into a new sheet.

Q: Does the export include recurring events?

Yes. Each occurrence of a recurring event inside the date range becomes its own row. Calrows marks those rows read-only so it never edits the whole series by accident.

Q: Can I export a shared or team calendar?

Yes, if the calendar is shared with your Google account. Shared calendars appear in the Calrows calendar list next to your own.

Updated 1 October 2026

For billing, payroll, reporting or just seeing where the month went, you want calendar events as rows in a spreadsheet. Google Calendar has no "export to Sheets" button, so here are the four ways that work, which one to pick, and the mistakes to avoid.

Quick answer

Install the free Calrows add-on, open your sheet, go to Extensions › Calrows › Open sidebar › Import from Calendar, pick the calendar and a date range, and click Import events into a new sheet. You get one row per event with title, start, end, all-day, description, location, guests and colour.

The 4 ways to export Google Calendar data to a spreadsheet, compared

Method	Pick a date range	Clean columns	Past events	Effort	Cost
Calendar's own Export (.ics file)	No, whole history	No, needs converting	Yes	High	Free
Apps Script (code below)	Yes	Yes	Yes	Medium, some coding	Free
Automation tools (IFTTT, Zapier)	No	Yes	No, only new events from now on	Low	Free tiers, then paid
A Sheets add-on such as Calrows	Yes	Yes	Yes	Two clicks	Free up to 50 events per export

Method 1: Export Google Calendar to Google Sheets with an add-on (easiest)

Install Calrows from the Google Workspace Marketplace (free).
Open any Google Sheet and go to Extensions › Calrows › Open sidebar.
Choose the calendar at the top. Your own calendars and any calendars shared with you are listed.
Under Import from Calendar, set the From and To dates, for example the first and last day of last month.
Optionally type a name for the new tab, then click Import events into a new sheet.

The new tab has these columns: Title, Start, End, All day, Description, Location, Guests and Color. All-day events show the right dates (Google stores their end date as the following day; Calrows corrects that). Each occurrence of a recurring event becomes its own row.

Two things the other methods can't do:

The export stays connected. Edit a row and click Send rows to Calendar, and the event changes in Google Calendar. Move an event in Calendar and Pull Calendar changes writes it back into the row.
Timesheets. If you're exporting to bill hours, the Timesheet panel adds hours, an hourly rate, amounts and totals per client. See how to make a timesheet from Google Calendar.

Method 2: Export Google Calendar data to Sheets with Apps Script (free, some coding)

In your sheet, open Extensions › Apps Script, paste this, change the dates, and click Run. It writes one month of your main calendar into a new tab.

function exportCalendarToSheet() {
  var cal = CalendarApp.getDefaultCalendar();   // or CalendarApp.getCalendarById('[email protected]')
  var start = new Date('2026-09-01T00:00:00');  // first day to include
  var end   = new Date('2026-10-01T00:00:00');  // the day AFTER the last day
  var rows = [['Title', 'Start', 'End', 'All day', 'Location', 'Guests', 'Description']];
  cal.getEvents(start, end).forEach(function (e) {
    var allDay = e.isAllDayEvent();
    var s  = allDay ? e.getAllDayStartDate() : e.getStartTime();
    var en = allDay ? new Date(e.getAllDayEndDate().getTime() - 86400000) : e.getEndTime(); // all-day end is the next day
    var guests = e.getGuestList().map(function (g) { return g.getEmail(); }).join(', ');
    rows.push([e.getTitle(), s, en, allDay, e.getLocation(), guests, e.getDescription()]);
  });
  var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet('Calendar export ' + new Date().getTime());
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}

Three things to watch:

All-day events end a day late. Google stores the end of an all-day event as the next day; the script above corrects for it.
Large ranges time out. Apps Script stops after six minutes. A busy calendar over a whole year can hit that limit; export month by month.
It's a one-off copy. Change an event in Calendar and the sheet won't know. Run it again to refresh.

Method 3: Calendar's own Export (.ics file)

In Google Calendar, go to Settings › Import & export › Export. You get a ZIP containing one .ics file per calendar.

It contains the entire history of the calendar, every event since it was created. There is no date range.
Google Sheets can't open .ics files as rows. You need a converter to turn it into CSV first, and the result usually needs cleaning: time zones, repeating-event rules and line breaks come out messy.

It's the right tool for a backup or moving to another calendar app, not for getting last month's events into a spreadsheet.

Method 4: Automation tools (IFTTT, Zapier)

Automation services can add a row to a sheet each time a new event is created. That's useful for a running log, but they don't export events that already exist, and they don't update rows when an event is moved or deleted.

Google Calendar export to Excel

Use any method above to get the events into Google Sheets, then choose File › Download › Microsoft Excel (.xlsx). The rows, columns and dates carry over to Excel. To keep the dates as real dates (not text), leave the Start and End columns formatted as date-time before you download.

Frequently asked questions

Can you export Google Calendar to Google Sheets?

Not directly. Google Calendar only exports a whole calendar as an .ics file, which Sheets can't open as rows. Use an add-on such as Calrows, an Apps Script, or an automation tool.

How do I export only one month or a specific date range?

Calendar's own export has no date range. In Calrows: Extensions › Calrows › Open sidebar › Import from Calendar, set From and To, then click Import events into a new sheet.

Does the export include recurring events?

Yes. Each occurrence inside the date range becomes its own row. Calrows marks those rows read-only so it never edits the whole series by accident.

Can I export a shared or team calendar?

Yes, if it's shared with your Google account. Shared calendars appear in the calendar list next to your own.

Will the sheet update when the calendar changes?

With Calrows, yes: click Pull Calendar changes, or on Pro turn on automatic sync with "also pull calendar changes" to refresh it every hour. Apps Script and .ics exports are one-off copies.

Is it free?

Calrows is free for exports of up to 50 events at a time. Pro removes the limit and is a one-time payment with no auto-renewal. Apps Script is free but needs some coding.

Install Calrows, free