- 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.
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:
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