How to Upload Calendar to Google Calendar

How to Import Excel Events CSV into Google Calendar: Tips, Supported Fields, How-to

Posted on:  05/19/2021

If adding events to your Google Agenda is tiresome or yous accept many events you lot demand to add chop-chop, yous can use a CSV file you can generate in Microsoft Excel, to populate your calendar speedily and easily. Read beneath to find out how to do it, what fields are supported and the procedure to import your agenda events into Google Calendar in a few clicks, using a CSV file.

I've covered this topic in the by and even made several videos about information technology on my YouTube aqueduct, where I got many questions so I thought a refresh is in guild. I'll endeavour to answer as many as I tin can in this article.

How to prepare the Google Calendar events CSV file

Open Excel and create a header row. The fields yous can include are shown in the screenshot below and they are supported and documented by Google. You don't take to include all the fields, just the start two: Discipline and Commencement Date. The rest are optional:

Example of Excel file with required fields for import into Google Calendar

I've got a outset date, an end date, a time to showtime, a time to end.

One potential problem I become many questions about, if the import doesn't piece of work, it'southward possible that the fields are formatted incorrect. What I hateful is, sometimes, for the start fourth dimension or end time, instead of showing the actual time, these fields become formatted and exported every bit TEXT. Then make sure you format them every bit dates, and not as text fields. As an example, I've added '9, space, AM', 'x, space, AM', to let Excel know that what I want to input is Time.

Salve the CSV file

If you really are in Excel and have it every bit an Excel format, get to File > Salve As, and then in the file blazon drop-down right here, make it CSV. Then you can't pull Excel directly into a Google Agenda, it must be a CSV file:

Make sure you salvage your file as a CSV, not XLS or XLSX format, or it won't import into Google Calendar

Importing the CSV file into Google Agenda

I have a large tip for you that might salve you a lot of head aches: before you import the CSV file into your main calendar, I recommend you examination it by creating a test agenda and importing it there. This mode, yous don't populate your master calendar with a lot of events that may cease upwards being wrong, imported incompletely or something like that, just in example Google doesn't make sense of the file yous're uploading.

To create a new calendar for testing:

1. Open Google Calendar
2. Go to 'Settings and Sharing > Add calendar'
3. Create a new calendar, requite it a name. Mine is 'Grooming dates'
4. Click Create

i. Go to Settings and Sharing to add a new calendar

ii. Get to Add Agenda and Create New agenda

Now I've got a new calendar called Preparation dates.

At present, to import your data in this exam agenda:

1. Become to 'Settings and Sharing' again
2. Click 'Import'
3. Locate the CSV file you exported on your local computer
4. Select the correct calendar y'all desire to import into (by default it volition select your main agenda)
5. Click Import

Import the CSV file into your test agenda to brand certain it works

In my example, I should get five events, which I exercise, and so the file was imported successfully into my examination calendar:

I go my events successfully imported into Google Agenda examination

What are the supported fields for Google Agenda import?

The headers must be in English as shown below. If whatsoever event details take commas (like the location example below), you can include them past using quotation marks around the text.

Field name	Explanation	Examples
Subject	The name of the event, required.	Instance: Final exam
Outset Appointment	The beginning solar day of the outcome, required.	Example: 05/30/2020
Beginning Time	The time the event begins.	Example: x:00 AM
Cease Engagement	The final solar day of the effect.	Case: 05/30/2020
End Fourth dimension	The time the event ends.	Example: ane:00 PM
All Day Effect	Whether the event is an all-day event. Enter True if information technology is an all-day event, and False if information technology isn't.	Example: False
Description	Clarification or notes about the event.	Example: 50 multiple selection questions and 2 essay questions
Location	The location for the upshot.	Example: "Columbia, Schermerhorn 614"
Private	Whether the outcome should be marked private. Enter True if the event is private, and False if it isn't.	Example: True

Can you add guests in imports?

No. It would be dainty if it were possible to add guests or invite people in your spreadsheet and have Google Calendar add them as invitees or send them invitations. I estimate that's perhaps a spam protection, but the respond is, yous tin't. So you have to add together those manually after you've imported your events.

Import all the same not working?

I sometimes accept this question from people, even though the file seems ok and they are using the allowed fields, it won't piece of work. Brand sure when yous look at your file in Excel, that non everything is in column A of your spreadsheet. Sometimes, there's no delimiter and if the cavalcade is narrow, you can't see that in fact, all your data is within a single jail cell. You must have the information sitting in separate columns, under the appropriate headings in Excel, before yous export it to CSV, otherwise information technology won't work.

Related articles

Chris Menard

Chris Menard is a Microsoft Certified Trainer and is employed full-time as a Trainer for a large national law firm with offices in 17 cities. Menard has a YouTube aqueduct with other 750 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resource that over 10 million viewers have appreciated.

Categories

• Web log » Microsoft » Microsoft Excel » Intermediate
• Blog » Google » Google Calendar

peachdaught.blogspot.com

Source: https://chrismenardtraining.com/post/how-to-import-excel-events-csv-into-google-calendar-tips-supported-fields-how-to

Share this post