• Hive Five
  • Posts
  • TIL you can Import CSV files into Google Calendar

TIL you can Import CSV files into Google Calendar

This is particularly handy if you mapped out an event or trip in Google Sheets but want it in Google Calendar as well.

Author

Bee Gagliardi
November 02, 2024

Today I learned that Google Calendar has a really useful CSV import feature that lets you bulk-import events. This is particularly handy if you mapped out an event or trip in Google Sheets but want it in Google Calendar as well.

For this to work, the CSV format needs to have these columns: 

Subject,Start Date,Start Time,End Date,End Time,All Day Event,Description,Location

Here's a sample row: 

Birthday Party,2024-11-15,14:00,2024-11-15,17:00,False,Don't forget presents!,123 Main St

To import:

  1. First, export your Google Sheet File > Download > CSV

  2. Now, Go to Google Calendar settings

  3. Find "Import & Export" on the left

  4. Click "Select file from your computer" and choose your CSV

  5. Pick which calendar to import into

  6. Hit Import