Mass Add Calendar Events

1. Below is Google's guide to each column of the csv.

Create a sheet with all of the events you would like to add to a calendar. I have created the following template as a google sheet for you:

Google Sheet Link:

 https://docs.google.com/spreadsheets/d/1Wnr8ppmyyS51HzYs28_JmfJ-ZghKd60ZakAFa2MLMqU/edit?usp=sharing

Advanced: Create or edit .csv or iCal files before you import

Create or edit a .csv file

You can import .csv (comma separated values) files into Google Calendar. If you get an error when you import a .csv file, you might be able to fix the formatting.

Open a .csv file or create one with a spreadsheet editor like Google Sheets.

The first row of your new spreadsheet includes headers like “Subject” and “Start Date.” To import into Google Calendar, the headers must be in English. For the correct headers you need to import into Calendar, go to the list below.

Each row below the header row represents an event. For example:

When you're done, save the file as a .csv file. Then, to import the file into Google Calendar, follow the steps in “Import events into Google Calendar.”

Format headers & events in .csv files

Only the first 2 headers in this list are required. The rest are optional.

Important: The headers must be in English as shown in this article. If any event details have commas (like the location example given), you can include them with quotation marks around the text.

• Subject
  (Required) The name of the event
  Example: Final exam
• Start Date
  (Required) The first day of the event
  Example: 05/30/2020
• Start Time
  The time the event begins
  Example: 10:00 AM
• End Date
  The last day of the event
  Example: 05/30/2020
• End Time
  The time the event ends
  Example: 1:00 PM
• All Day Event
  Whether the event is an all-day event. 
  • If it’s an all-day event, enter True. 
  • If it isn’t an all-day event, enter False.
    Example: False
• Description
  Description or notes about the event
  Example: "50 multiple choice questions and two essay questions"
• Location
  The location for the event
  Example: "Columbia, Schermerhorn 614"
• Private
  Whether the event should be marked private.
  • If it’s private, enter True.
  • If it isn’t private, enter False.
    Example: True

These examples would create the following event:

• Event: "Final exam" on May 30, 2020 10:00 AM–1:00 PM 
• Location: "Columbia, Schermerhorn 614" 
• Description: "50 multiple choice questions and two essay questions"
• Private: Private event

3. After you are done creating the google sheet, download it as a csv:

3. Go to calendar.google.com and import the csv to a calendar as shown below: