Guide · Google Calendar

How to export Google Calendar to Google Sheets

Google Calendar has no Export to Sheets button, but there are two free ways. With no code: install the Sheets to Calendar add-on, pick the calendar and the dates, and your events land in a tab, one row per event. Importing is free on every plan. With code: paste a short Apps Script into your sheet and run it.

Updated 20 November 2026 · 4 min read

Without code: Sheets to Calendar

Sheets to Calendar is our Google Sheets add-on. It takes about a minute, and you can do it again for any dates you like.

  1. 1

    Install the add-on

    Install Sheets to Calendar from Google Workspace Marketplace. It is free, and importing events is free on every plan.

  2. 2

    Open it in your sheet

    In Google Sheets, choose Extensions → Sheets to Calendar and open the import.

  3. 3

    Pick the calendar and the dates

    Choose which calendar and which dates you want. The events land in a tab, one row per event, with the title, start, end and location.

The rows stay linked to their events. If you fix a time or a location in the sheet, you can send the change back to Google Calendar without making a second copy of the event. Pro, at €5 a month, keeps the sheet and the calendar in sync both ways by itself.

With a free script

If you would rather not install anything, this script copies a date range from your calendar into a tab.

  1. 1

    Open Apps Script

    In a new Google Sheet, choose Extensions → Apps Script, delete what is there and paste the script below.

  2. 2

    Set your dates

    Change the START and END dates in the first lines. To use another calendar than your main one, swap in its ID, which you find under the calendar's Settings and sharing in Google Calendar.

  3. 3

    Run it

    Click Run and allow the access Google asks for. Your events appear in a tab called Events, one row each.

function importCalendar() {
  const START = new Date('2026-01-01');
  const END = new Date('2026-12-31');
  const cal = CalendarApp.getDefaultCalendar();
  // another calendar: CalendarApp.getCalendarById('[email protected]')

  const rows = cal.getEvents(START, END).map(function (e) {
    return [e.getTitle(), e.getStartTime(), e.getEndTime(),
            e.getLocation(), e.getDescription(), e.getId()];
  });

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('Events') || ss.insertSheet('Events');
  sheet.clearContents();
  sheet.getRange(1, 1, 1, 6).setValues([['Title', 'Start', 'End', 'Location', 'Description', 'Event ID']]);
  if (rows.length) sheet.getRange(2, 1, rows.length, 6).setValues(rows);
}

The script copies one way only. If you change a row and run it again, the tab is overwritten with what is in the calendar, and edits in the sheet never reach the calendar. For that, keep the Event ID column and write a second function that calls CalendarApp.getEventById to update each event, or use the add-on above.

Export Google Calendar to Excel

Get the events into Google Sheets with one of the ways above, then choose File → Download → Microsoft Excel (.xlsx). Google Calendar's own export, under Settings → Import & export, gives an .ics file, which Excel does not open as a table.

Questions

Can you export Google Calendar to Google Sheets?

Not with a button in Google Calendar. You can do it for free with an add-on such as Sheets to Calendar, which imports the dates you choose into a tab, or with a short Apps Script that writes your events into a sheet.

Can I export Google Calendar to Excel?

Yes. Get the events into Google Sheets first with one of the ways on this page, then choose File → Download → Microsoft Excel (.xlsx). Google Calendar's own export gives an .ics file, which Excel does not open as a table.

Is there a free way to export Google Calendar to Google Sheets?

Yes, both ways on this page are free. The Sheets to Calendar add-on imports events into a sheet on every plan, including the free one, and the Apps Script costs nothing.

Can I export a shared calendar?

Yes, as long as you can see its events in your own Google Calendar. In the script, use CalendarApp.getCalendarById with the calendar's ID. In the add-on, pick the calendar from the list.

Can I edit the events in the sheet and update the calendar?

Not with the script, which only copies one way, so running it again overwrites the tab. Sheets to Calendar keeps the imported rows linked to their events, so you can edit a row and sync the change back to Google Calendar. Automatic two-way sync is on the Pro plan at €5 a month.

Can it update the sheet automatically?

With the script, add a time trigger (the clock icon in Apps Script, then Add Trigger) to run importCalendar every day. With the add-on, Pro keeps the sheet and the calendar in sync for you.

Written by AddonNordic ApS, Aalborg, Denmark (CVR 46495985), maker of Sheets to Calendar for Google Sheets. Also see how to send a Google Sheet as a PDF. Google Calendar™, Google Sheets™ and Google Apps Script™ are trademarks of Google LLC, and Excel is a trademark of Microsoft Corporation; this guide is not made or endorsed by either.