Create Google Calendar events from Google Sheets

Google Calendar can import a CSV file. Each row becomes an event. It is a one-way, one-time import.

Free way: CSV import

1. Make columns named Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location.
2. File > Download > CSV.
3. In Google Calendar: Settings > Import & export > Import, pick the file and the calendar.
4. Check a few events; the times use your calendar's time zone.

Importing the same file twice makes duplicates, and later edits in the sheet do not reach the calendar.

Bulk add events to Google Calendar

Typing events one by one is slow. A spreadsheet lets you fill many rows at once, then send them to the calendar together.

Steps

1. Put one event per row: title, date, start time, end time.
2. Use the CSV import in Google Calendar for a one-time load (see this guide).
3. For big lists, split into smaller files; a bad row can stop the import.

Sync Google Sheets and Google Calendar

A sync means a change in the sheet updates the event that already exists, instead of making a new one. That needs the event ID stored next to each row.

Doing it with a script

1. Add a hidden column for the event ID.
2. On each run: rows with no ID get a new event and the ID is written back; rows with an ID update that event.
3. Decide how a delete works, for example a Status column.
4. Add a time-driven trigger.

The tool I made for this

I make and sell Sheets to Calendar. Turn spreadsheet rows into Google Calendar events and keep both in sync. Preview first, no account needed.