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: November 14, 2022
Average Rating: Not Rated
Your feedback is important to us, help us by logging in to rate this article and provide feedback.

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:  https://support.google.com/calendar/answer/37118#advanced&zippy=%2Ccreate-or-edit-a-csv-file

    • 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
      https://learn.echo360.com/hc/en-us/articles/360035036872-Adding-Uploading-Transcriptions-to-Captures-Instructors-

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


Provide Feedback


Your feedback is important to us, help us by logging in to rate this article and provide feedback.

Sign in with NetID

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 Quick Ticket

Supported By


Customer Engagement and Support