Importing Calendar Events from CSV to Google Calendar

This KB Article References: Google Calendar
This Information is Intended for: Instructors, Staff, Students
Created: 01/29/2013 Last Updated: 05/07/2024

If you would like to enter multiple Google Calendar events without creating each one individually, create a CSV file of all your events, and then import that file into Google Calendar

Video Demonstration


I. Create CSV File

  1. Create a .csv file with the following columns: Subject, Start Date, All Day Event, Start Time, End Time, Location, Description (if you prefer, download the csv file template and enter your own event details there)
    Important Guidelines:
    • Each event must be on a separate line of the spreadsheet
    • All-day events must be assigned the value "TRUE" in the "All Day Event" column
    • Non-All day events must be assigned the value "FALSE" in the "All Day Event" column and must have valid Start and End Time values (in 12-hour format, not military time)
    • Dates must be in the format MM/DD/YYYY
    • Be sure to save the file as a .csv file (not .xls)
      Sample .csv file filled out for 2 events to upload to Google Calendar

II. Import to Google Calendar

  1. To import the events to a new calendar, create a new Calendar (optional)
  2. Click the gear icon in the top right and choose Settings
  3. On the left side, click Import & export
  4. Click Select file from your computer, and then search your computer for and select the .csv file created above
  5. Click the Add to Calendar drop-down and select the calendar you'd like to import the events to
  6. Click IMPORT
  7. A message will display indicating how many events were successfully imported

Supported By

Customer Engagement and Support

Related Information