Export Google Calendar events to Google Sheets

Google Calendar has no “Export to Sheets” button. Here are three ways to get your events into a spreadsheet, from the most basic to the most complete.

1. Google Calendar’s own export: an .ics file, not a table

In Google Calendar, Settings › Import & export › Export downloads a .zip file with one .ics file per calendar. This format is made for other calendar apps: Google Sheets does not open it as a table.

2. A short script: free, one calendar, the basics

In a Google Sheets file, open Extensions › Apps Script, replace the code with this one, save, then click Run. The first time, Google asks you to allow the script to read your calendar.

function exportCalendarToSheet() {
  var cal = CalendarApp.getDefaultCalendar();
  var start = new Date(); start.setMonth(start.getMonth() - 1);
  var end = new Date(); end.setMonth(end.getMonth() + 3);
  var rows = [['Title', 'Start', 'End', 'All day', 'Location']];
  cal.getEvents(start, end).forEach(function (e) {
    rows.push([e.getTitle(), e.getStartTime(), e.getEndTime(), e.isAllDayEvent(), e.getLocation()]);
  });
  var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}

It copies the events of your main calendar, from one month ago to three months ahead, into a new tab: title, start, end, all day and location. For an all-day event, Google gives the end as midnight of the next day. To use another calendar, replace CalendarApp.getDefaultCalendar() with CalendarApp.getCalendarById('…'), using the calendar ID shown in its settings under Integrate calendar.

3. With CalGantt: events and tasks, with dates, status and a timeline

CalGantt reads the calendars and task lists you choose. Its Export to a sheet tab (a Pro feature, free for everyone until 31 December 2026) writes them in a tab called Gantt export:

  • one row per event or task, grouped by calendar and category, with the columns Calendar, Task, Start, End, Days, Status, %, Due and Depends on;
  • next to them, a colored timeline by day (by week for a period longer than about four months), with today marked.
  1. In Google Sheets, open Extensions › CalGantt › Open Gantt chart, then choose your calendars and task lists.
  2. Show the period you want to export (week, month, quarter or everything).
  3. Click More (⋯) › Export to a sheet tab. From the menu, Extensions › CalGantt › Export Gantt to a sheet tab takes two weeks back to three months ahead.

Good to know: repeating events and tasks without a date are not exported. Each export replaces the previous Gantt export tab, and it is a snapshot: it does not update by itself. The export is in the Google Sheets add-on, not in the web app.

Install CalGantt for Google Sheets Or a free Gantt template