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: February 09, 2017

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

Import Events to a Google Calendar

  1. To import the events to a new calendar, create a new Calendar (optional)
  2. Create a .csv file with the following columns: Subject, Start Date, All Day Event, Start Time, End Time, Location, Description (if you prefer, feel free to 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/YY
    • Be sure to save the file as a .csv file (not .xls)
  3. Click the drop-down menu next to My calendars and choose Settings
    This is an image of Google's drop-down menu for calendars with "Settings" circled in red.
  4. Under My Calendars, click Import calendar
    This is an image of an "Import calendar" link circled in red.
  5. Search for the .csv file created in step 2 on your computer by clicking Choose File
    This is an image of Google's "Import calendar" menu.
  6. For Calendar, select the calendar you'd like to import the events to
  7. Click Import
  8. Your events will now be in the selected Google Calendar

Additional Information

Files & Links

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