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
Birthday Party,2024-11-15,14:00,2024-11-15,17:00,False,Don't forget presents!,123 Main St
-
First, export your Google Sheet File > Download > CSV
-
Now, Go to Google Calendar settings
-
Find “Import & Export” on the left
-
Click “Select file from your computer” and choose your CSV
-
Pick which calendar to import into
-
Hit Import