Importing Calendar Events from CSV to Google Calendar

Audience: Clubs, Faculty, Staff, Students and Teaching Assistants

This KB Article References: Google Calendar
This Information is Intended for: Clubs, Faculty, Staff, Students, Teaching Assistants
Last Updated: June 13, 2018

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:

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 located under Related Files and replace the data with your own)
    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)

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

Additional Information

Getting Help

The Division of Information Technology provides support on all of our services. If you require assistance please submit a support ticket through the IT Service Management system.

Submit A Ticket

Supported By

Customer Engagement and Support