How To Upload A Word Schedule To Google Calendar

Importing Calendar Events from CSV to Google Calendar

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

This KB Article References: Google Calendar
This Information is Intended for: Clubs, Faculty, Staff, Students, Teaching Assistants
Last Updated: August 11, 2020
Average Rating: Not Rated

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

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

I. Create CSV File

Create a .csv file with the following columns: Subject, First Engagement, All Solar day Consequence, Start Time, End Time, Location, Clarification (if you prefer, download thecsv file located nether Related Files and supervene upon the information with your own)
Important Guidelines:
- Each event must be on a split line of the spreadsheet
- All-day events must be assigned the value "TRUE" in the "All 24-hour interval Consequence" column
- Non-All day events must be assigned the value "Fake" in the "All Twenty-four hours Event" column and must have valid Start and Terminate Time values (in 12-hr format, not armed forces time)
- Dates must be in the format MM/DD/YYYY
- Exist sure to relieve the file every bit a .csv file (not .xls)

II. Import to Google Agenda

To import the events to a new calendar, create a new Calendar (optional)
Click the gear icon in the elevation correct and chooseSettings
On the left side, clickImport & export
Click Select file from your computer, and then search your computer for and select the .csv file created to a higher place
Click the Add together to Calendar drop-downandselect the calendar yous'd like to import the events to
ClickIMPORT
A message will display indicating how many events were successfully imported

Additional Information

Files & Links

Provide Feedback

Getting Help

The Partition of Data Engineering provides back up on all of our services. If you lot crave aid please submit a back up ticket through the Information technology Service Management system.

Submit A Quick Ticket