How to Import Your Google Calendar into Google Sheets: Step-by-Step Guide

Step 1 – Install and Open Calendar to Sheets

• Install from the Google Workspace Marketplace if you haven't already.
• Open your spreadsheet.
• Go to Extensions → Calendar to Sheets → Import calendar.

Step 2 – Select Your Calendar

• In the sidebar, choose which Google Calendar you want to import.
• If you manage multiple calendars, name them clearly to avoid mix-ups later.

Step 3 – Choose a Date Range

You have three options:

• Everything – All events in your calendar, past and future.
• Last 30 Days – Useful for rolling operational views.
• Custom Range – Set start date, end date, or both.

Step 4 – Pick the Import Mode

• Clear sheet and import – Wipes the active sheet and imports everything fresh.
• Incremental import – Only imports new or updated events, keeping your formulas safe.

Step 5 – Review Your Imported Data

• Once imported, your events will appear as rows, with each detail in its own column.
• You can now filter, sort, or use formulas just like with any spreadsheet data.

Troubleshooting Tips

• No events? Check you've selected the right calendar and date range.
• Wrong time zone? Adjust in the Time Zone column or update your Google Calendar settings.

Conclusion

You've now successfully imported your Google Calendar into Google Sheets. Next, learn how to export your edited events back to Google Calendar for a true two-way sync.