How to Upload Event in Google Caladner

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

Posted on:  05/nineteen/2021

If adding events to your Google Agenda is tedious or you have many events you demand to add quickly, you tin can utilize a CSV file you lot can generate in Microsoft Excel, to populate your agenda quickly and hands. Read below to find out how to do it, what fields are supported and the procedure to import your calendar 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 it on my YouTube channel, where I got many questions then I thought a refresh is in order. I'll try to answer as many as I tin in this article.

How to prepare the Google Agenda events CSV file

Open Excel and create a header row. The fields you lot can include are shown in the screenshot below and they are supported and documented by Google. You lot don't have to include all the fields, just the first two: Subject and Start Date. The rest are optional:

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

I've got a start appointment, an cease date, a time to start, a time to end.

One potential problem I get many questions almost, if the import doesn't work, information technology's possible that the fields are formatted wrong. What I mean is, sometimes, for the start time or stop time, instead of showing the actual time, these fields get formatted and exported as TEXT. So brand sure you format them equally dates, and non as text fields. As an example, I've added 'ix, space, AM', 'x, space, AM', to permit Excel know that what I desire to input is TIME.

Save the CSV file

If you actually are in Excel and have it as an Excel format, become to File > Save Equally, and then in the file type drib-down right hither, make it CSV. So you tin't pull Excel directly into a Google Calendar, it must be a CSV file:

Make sure you lot save your file equally a CSV, not XLS or XLSX format, or it won't import into Google Agenda

Importing the CSV file into Google Calendar

I take a big tip for y'all that might save you a lot of caput aches: before you import the CSV file into your principal calendar, I recommend yous exam it by creating a test calendar and importing it there. This way, y'all don't populate your principal calendar with a lot of events that may end up being wrong, imported incompletely or something like that, only in case Google doesn't make sense of the file you're uploading.

To create a new calendar for testing:

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

1. Go to Settings and Sharing to add together a new calendar

ii. Go to Add Calendar and Create New agenda

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

Now, to import your data in this test calendar:

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

Import the CSV file into your examination calendar to make sure it works

In my example, I should get 5 events, which I exercise, so the file was imported successfully into my exam calendar:

I get my events successfully imported into Google Calendar test

What are the supported fields for Google Agenda import?

The headers must exist in English equally shown below. If whatever event details have commas (similar the location example below), you tin can include them by using quotation marks around the text.

Field proper name	Explanation	Examples
Subject	The proper name of the issue, required.	Instance: Final exam
Commencement Date	The beginning twenty-four hours of the event, required.	Example: 05/xxx/2020
Start Time	The time the event begins.	Example: x:00 AM
End Date	The last solar day of the event.	Example: 05/xxx/2020
Terminate Time	The time the outcome ends.	Example: 1:00 PM
All Twenty-four hour period Event	Whether the upshot is an all-24-hour interval result. Enter Truthful if it is an all-24-hour interval event, and Faux if it isn't.	Instance: False
Description	Description or notes about the event.	Example: fifty multiple choice questions and two essay questions
Location	The location for the event.	Example: "Columbia, Schermerhorn 614"
Individual	Whether the effect should be marked individual. Enter True if the event is private, and False if it isn't.	Example: Truthful

Can you add guests in imports?

No. Information technology would be overnice if information technology were possible to add guests or invite people in your spreadsheet and take Google Calendar add them equally invitees or send them invitations. I estimate that's maybe a spam protection, but the answer is, you lot can't. So y'all have to add those manually after you've imported your events.

Import still non working?

I sometimes accept this question from people, even though the file seems ok and they are using the immune fields, it won't piece of work. Make sure when you wait at your file in Excel, that not everything is in column A of your spreadsheet. Sometimes, there's no delimiter and if the column is narrow, you tin't run across that in fact, all your data is inside a unmarried cell. You must have the data sitting in dissever columns, nether the appropriate headings in Excel, before you consign it to CSV, otherwise information technology won't piece of work.

Related articles

Chris Menard

Chris Menard is a Microsoft Certified Trainer and is employed full-fourth dimension as a Trainer for a big national law business firm with offices in 17 cities. Menard has a YouTube channel with other 750 engineering science videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 1000000 viewers accept appreciated.

Categories

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

lilienthallogetch39.blogspot.com

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

Share this post