Import Excel Events CSV into Google Calendar | Excel to Google Calendar Transfer

How to import Excel events into Google Calendar? In this Excel tutorial, I'm going to take a Microsoft Excel file, save it as a CSV file and then go put it into my Google Calendar with an import. I also answer as many questions as I possibly can that have been left on my YouTube channel comments section about this Excel to Google Calendar process.

To prepare the Excel file, you must have a header row, and the fields must be included there. Although there are more fields supported in the Google Calendar specification, only the first two fields are required: Subject and Start Date. In my file, I've included start date, an end date, a time to start, a time to end.

Chapters:
0:00 Intro
0:31 Google calendar fields
1:25 Save as CSV
2:20 Create a new Google Calendar
3:35 Delete a Google Calendar

Sometimes, if the data for the time column doesn't import correctly, it may be because the Excel column is not formatted as actual time but as text. So make sure that the time column has your time, and then AM or PM, so that Excel formats it correctly before you export to CSV.

Another problem you might encounter if the CSV import to Google Calendar doesn't work is: make sure when you look at your file that not everything is sitting in column A. I've seen that many times, so the data must be in separate columns in your Excel file, not all stuck into a single column because Google Calendar cannot interpret it. There has to be a delimiter. You can fix that using the Data tab in Excel, Text to columns if by chance everything is sitting in column A.

When you save the file, make sure it's saved as a CSV file, not as an Excel file, as that is not supported. You can't pull Excel directly into a Google calendar, it's got to be a CSV (comma-separated) file.

Before you import the file into your Google Calendar, I recommend you create a test calendar by going to Settings and Sharing, add a calendar, create a test one and import the file in that one. If all is working well, you can delete this calendar and import the file again into your main calendar. This is so you don't mess up your calendar or fill it up with bad events.

A downside of this import process from Excel to Google Calendar is that you cannot add a column with invites, in Excel. So you cannot add invited guests to this import, you have to add them manually after.

More Excel Video Tutorials:

If you have any other comments, questions, please let me know.

#exceltogooglecalendar #excelcsv #googlecalendar

Possible Google Calendar Fields:
************
Download the CSV file I used in the video from here:
************
important: The headers must be in English as shown below. If any event details have commas (like the location example below), you can include them by using quotation marks around the text.

Subject
The name of the event, required.
Example: Final exam

Start Date
The first day of the event, required.
Example: 05/30/2020

Start Time
The time the event begins.

End Date
The last day of the event.
Example: 05/30/2020

End Time
The time the event ends.

All Day Event
Whether the event is an all-day event. Enter True if it is an all-day event, and False if it isn't.
Example: False

Description
Description or notes about the event.
Example: 50 multiple choice questions and two essay questions

Location
The location for the event.
Example: "Columbia, Schermerhorn 614"

Private
Whether the event should be marked private. Enter True if the event is private, and False if it isn't.
Example: True

Chris Menard's Training Website and Blog

Excel - Free class on Excel Tables by Chris Menard

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[SabsYt]

Thank you for this video. I was struggling to find out how to do this. This video was very useful

[herreramartinez]

Hey Chris, just wanted to say thanks this is exactly what I was looking for, in deep details. Keep up the good work!

[cf]

I had already spent like 2 hours writing all my school work due dates into excel but I could not uploaded into google calendar, thanks to you, I finally did it. THANK YOU!!!

[macjaffer]

i appreciate you specifying the formatting - that helped so much thank you!

[DrPryor-pntw]

This is GREAT! I can share a list of events with my students and they will automatically populate! You rock!

[arthurkazanis]

Well done Chris. Right on the money! Love your work.

[jdanpey]

This video was exactly what I was looking for thanks!

[deiver]

very useful video, Chris. Thanks for sharing it

[lewisevans]

Great tutorial, thanks so much! - Managed to create a calendar for the recycling bins lol

Had a little trouble using the online version because of its limited functions (i.e. converting to CSV) but got round this by using a Google Sheets version instead :) Happy days

[Mramet]

Very helpful, thank you Chris, makes my job easier

[jonathanriddell]

Thank you so much for all the future hours I´ve saved because of this video

[bondbabe]

Thank you. very useful. I used these steps to import and worked.

[JiWoonPark]

Hi, Chris. Thanks for the ussful video. May I ask if it would be possible to make an event repeating?

[agul]

Dorcell, i appreciate that ! i applied it for compay PDC reminder, thanks, thanks a lot helpful for learning

[stvmia]

Thank you for yr nice video. Do you have a video showing how to Export google calendar fields (Ex. Start date, Title, Event Color (since I only need to work with certain colors)?

[tomnicolle]

Hi Chris, great video and helpful. Can you tell me how to delete events from a calendar that were added in error please? I mistakenly imported an ics file from a third party calendar to my main calendar and got overwhelmed with all their events. I was trying to figure out how to delete those events but could not determine how. The only thing I came across was something that said to replace File:Confirmed with File:Cancelled in the ics file itself. It said open the ics file in a text editor and make the change then save it and upload the ics file from the third party calendar to the calendar you wanted to delete the entries and that is what it was supposed to do. I couldn’t get it to work so I wonder if you might know what to do. Would appreciate any thoughts you might have and thanks so much for your help.

[Waltrow]

Always knew this was possible, but couldn't for the life of me find the required format (columns/order) in the Google documentation. Thanks!

[shellymcleanbent]

Hey! Super helpful, could you add tasks instead of events?

[jithendergoudu]

Hello, Chris! you have done great videos.... Can you make a video showing how to use an Excel spreadsheet to set birthday reminders in Google Calendar.

[yogeshtdr]

Hey it worked thanks a lot and one question how to add location in the excel file before importing it to google calender can you please tell me