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

[@cf5421]

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!!!

[@ChrisMenardTraining]

Glad to help and I'm glad the import worked.

[@moniquemorgan358]

Thank you for the easy-to-follow instructions!

[@ChrisMenardTraining]

You are so welcome!

[@DrPryor-pn3tw]

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

[@ChrisMenardTraining]

Good plan. Your students will appreciate it. Thank you!

[@Sunnymcc2010]

Thanks!

[@ChrisMenardTraining]

Thank you for the donation! Much appreciated.

[@macjaffer4911]

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

[@ChrisMenardTraining]

Thanks, Mac!

[@jonathanriddell27]

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

[@jonathanriddell27]

Is there a way to add Quest to the calendar system or does that have to be manual

[@arthurkazanis4283]

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

[@ChrisMenardTraining]

Thank you!

[@Mramet31]

Very helpful, thank you Chris, makes my job easier

[@ChrisMenardTraining]

Glad to help. Thank you!

[@SabsYt]

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

[@ChrisMenardTraining]

You're welcome!

[@lewisevans6633]

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

[@herreramartinez3928]

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

[@ChrisMenardTraining]

Thanks, will do!

[@MissileGuidance]

Fabulous video extremely helpful ! 🔥

[@ChrisMenardTraining]

Thank you!

[@mikes359]

Thanks for your excellent tutorial!

[@ChrisMenardTraining]

You are welcome!

[@peasetill2]

Wonderful! Thanks for this!

[@ChrisMenardTraining]

You're very welcome!

[@deiver2492]

very useful video, Chris. Thanks for sharing it

[@ChrisMenardTraining]

Glad it was helpful! Thanks, Danilo.

[@Sylvaline-h6b]

thank you so so much. was my first time to try it and it worked

[@ChrisMenardTraining]

You're welcome!

[@jdanpey]

This video was exactly what I was looking for thanks!

[@ChrisMenardTraining]

Glad to hear it! Thanks, Josh!

[@JeremyWongChenChung]

Hi Chris. Great Video. Is there a way to events recurring weekly?

[@leorc564]

Thanks for your comments

[@ChrisMenardTraining]

Welcome

[@joshsjams1]

Can you set a reminder for this?? Also can you add to this where it won't duplicate dates?

[@KobeBukai]

thank you for the helpful tutorial

[@jithendergoud4u559]

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.

[@ChrisMenardTraining]

Already created. The video is in this blog post. chrismenardtraining.com/post/import-csv-file-with-recurring-or-repeating-events-into-google-calendar

[@srijandas2162]

Thanks! This worked for me

[@ChrisMenardTraining]

You're welcome!

[@melissadevereux2028]

Super helpful. Thanks very much. I'm pretty sure I know the answer to this question, but just want the nod from the expert... This is an import so will only import the information as it is presented. If I was to change the information in the csv file, it won't automatically update it on my google calendar, correct? I'd have to upload the csv file again, I'm assuming. If this is the case, do you know anyway that this might be able to work? Thanks for your time ;-)

[@JiWoonPark]

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

[@chetanvishnoi1679]

Thanks for the great video, Please let me know how can it be repeat every year, Like birthday and Anniversary

[@sarahhudak1750]

Helpful, but wish you'd shown an example for an All Day event. Do you just leave the end date blank?? What's the appropriate way to format?

[@Geogoslee]

Hi Chris, Thanks! just a check if I miss out in the video. Let's say I have a new updated CSV file, can I just import it to overwrite the existing one?

[@ChrisMenardTraining]

From my testing, it imports the same events. So you would have two events possible twice and the new events once.

[@yogeshtdr737]

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

[@jlkaskey]

Great video, it worked perfectly for me. Is there a way to turn notifications on automatically from the CSV? All my meetings uploaded without the standard reminder 10 minutes prior to the event

[@ChrisMenardTraining]

The only workaround I have found is to pull them into a new calendar and make the calendar default reminder ten minutes.

[@Travelspades]

Thank you Chris!

[@ChrisMenardTraining]

You are welcome.

[@megthompson752]

Chris, Is there a way for this to be a live calendar update from the excel file? We have a google excel doc for all school athletic events. Events that get changed often. So when my AD changes on google sheets, I need to it communicate live with my calendar. Hope that makes sense. Thanks.

[@ChrisMenardTraining]

That can't be done. It would be a great feature.

[@tejacavalera]

Hi, Chris. This tutorial makes my job easier. Thank you Is there a way to add a notification alarm?

[@ChrisMenardTraining]

Thank you. No way to add a notification on the import.

[@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!

[@alvc22]

Can you set up different colors for the different events?

[@AdaraB]

It's helpful but how can I create the calendar you have here using as a sample

[@traceykeilty2330]

Hi Chris - can you take information from google calendar into an excel spreadsheet - I need to put all my bookings of dog parks in the calendar into a spreadsheet for the taxman I wondered if I can do it the other way around - thank you

[@ruben-uzan-trade-show-expert]

Hi Chris, thanks so much for the video. I don't know why I can't export mine, seems there are other columns Google Calendar didn't like so much. I tried to copy paste them in another sheet and it works (so why doesn't it work in the first place?). Since it's not convenient cause I'm trying to create an event based calendar and I need to change the dates as events change dates, I tried to import the data into another sheet and export it in .csv, but this time it doesn't work either. Do you now what could cause the issue?

[@conserogroup5070]

Can you add invitees to these events that you upload? Thanks in advance!

[@ChrisMenardTraining]

That would be a great feature, but you have to manually do the invitees.

[@TheSportyExplorer]

what should be the field name in the XL to make it a yearly recurring events like a birthday ?

[@bonnierietz5982]

When you make changes/add more rows in the spreadsheet, how do you get it to update on the calendar ?

[@SALTyouthminister]

How would you add a Room/Resource to the Sheet for importation? We use calendar at my work place and reserve spaces for different meetings etc. This step would be integral for me to use. i can't find the info anywhere. Thanks!

[@ThePonytube]

hey Chris - is there a way to add a columns for "Guests", i tried to add Guests as a column it didnt take it.

[@ChrisMenardTraining]

Would be a nice feature, but it can't be done.

[@komalkhiriya3858]

Thank you sooooo much Chris!!! This is super helpful..... Can you please also suggest if there is a way we can add attendees too & can use desired Google meet link ( same link for all meetings).. Thanks very much again!!!!

[@ChrisMenardTraining]

I wish that was possible but it isn't. I've tried.

[@MarttiSuomivuori]

I have been doing this for years. Every year there is a new problem. Either Apple or Microsoft has changed something. This time the .csv -file refused to go through. I had to close Excel, tell my Mac we are in the US (I am in France), restart Excel, import the .xls file again set with correct delimiters, and save it as American style.csv. Took me an hour to figure it out, but it's done. Date formats and decimals give me gray hair. My highest kudos to the way you help us with your knowledge.

[@eng.abdullahalfuraiji4321]

It worked perfectly. But I have one question, how to add an alert before event in excel?

[@ChrisMenardTraining]

you can't do it with the import. That has to be done in Google calendar. You can make a default alert for the Google calendar.

[@stvmia4544]

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)?

[@yasmimcp94]

Hey Chris, may i put "event colors" in the excel file ?

[@ChrisMenardTraining]

You can put colors in the excel file but they will not show up in Google calendar. I think that is what you want to do. That would be a great feature.

[@Francooo.molina]

Hi Chris, in my work I have to schedule a list of birthdays for many people, is it possible to schedule the calendar so that the event is repeated every year? Greetings and good video

[@mosheteldon3919]

Have you ever figured out a solution? My exact situation...

[@kazazzz]

@@mosheteldon3919 not possible to import recurring. sadfaceeee

[@nordeastnester]

Hello Chris, is there a way to have reoccurring appointments? I am creating a family calendar for three kids with all activities they have

[@ChrisMenardTraining]

By default no, but I have a work around video. Old but still is how you would do this. . kzbin.info/www/bejne/b3mqfqxnZrGAebs

[@crisbautista5492]

Hi Super Thank you!!!

[@ChrisMenardTraining]

Welcome 😊

[@kocariku]

Hello Chris, is it possible to colour code CSV file for excel? Thank you for your video

[@ChrisMenardTraining]

That would be nice, but it can't be done. You could pull them into a google calendar and color code that calendar, but you can't have certain events certain colors.

[@chelseaboiful]

Hi I am looking to create a calender but its not importing, i am using the same headings as you in the video, any idea of where i could be going wrong

[@ChrisMenardTraining]

Send me your file please. I'll look at it. [e-mail]

[@Yo2022]

After trying a couple hours. I opened my own csv file made in Excel with Notepad. I replaced all semicolons Excel inserted in the file as column separator for commas, and finally it worked.

[@ngocanhle7566]

really helpful

[@marcsander5353]

before you try to import you should check the .csv-file by an text editor if there is no semicolon and exchange it with commas and save it again

[@FannyMartinez]

So can you share the calendar with others to see the imported information?

[@ChrisMenardTraining]

You can share a Google calendar. After importing, share the calendar. Google's support article on sharing support.google.com/calendar/answer/37082?hl=en

[@cathleenhock2392]

I love your videos. I'm having one problem. Every thing imports except for the times. I'm unable to get that part to import. I'm not sure what I'm doing?

[@ChrisMenardTraining]

Send me your CSV file. [e-mail]

[@poelsemix]

@@ChrisMenardTraining Hi Chris. Thanks for the video. I am not able to import as well. Dont know what is wrong. Have tried the others csv-formats as well. Could it be because of the 24-hour format?

[@girlfanAvrill]

I was wondering if there is a way to add a colum to repeat the event yearly.

[@ChrisMenardTraining]

Yes. It is a workaround but here is my video. kzbin.info/www/bejne/b3mqfqxnZrGAebs

[@kathrynreneer7366]

Is there a way to differentiate time zones? We have two satellite offices that are on eastern while our main office is central.

[@ChrisMenardTraining]

Shouldn't matter. Each person has a primary time zone. Here is a screen shot of my time zone. drive.google.com/file/d/1u45FKq6jEaJI-PIzmuJL15fxQGZ8AjFM/view?usp=drivesdk So, if you are in the main office - Central - and you upload events, and I'm in Atlanta - Eastern - I'll see them at 2 pm ET and you will have the event at 1 pm CT. Does that help?

[@agul7299]

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

[@cabservice914]

I want to sync my excel sheet with google calendar, it's for the reminder of the document expiration. Can you help me with that? Thanks in advance

[@JosephStanzione]

Is there a way to repeat events over a specific amount of days?

[@ChrisMenardTraining]

Yes. You have to do this in the csv file. kzbin.info/www/bejne/b3mqfqxnZrGAebssi=CWeMvIYzNQZ6cyX8

[@ColoradoDuo]

Chris, I'm following your instructions to a T. It shows 36 of 36 event imported (staring in Feb) but I only see events from June on. Nothing is different in my columns.

[@WilliamCondon-ih7fe]

can you bulk add guests?

[@theresaholcomb3642]

Have my excel file in the exact order you’ve shown in both of your videos. Have been attempting this several times now but it won’t import into my Google Calendar. My laptop has several CSV options: CSV comma delimited, CSV MS-DOS, CSV Macintosh. I’ve saved with all three and “0 out of 0 events imported. Unable to process iCal/CSV file. Help?

[@ChrisMenardTraining]

Send me your file please. [e-mail]

[@Draco.Sapiens]

Same problem here, i'm in Germany using Mac

[@christopheralbino5343]

Nice video. I have the import working but the Description field does not make it into the event once imported. 5 out of 5 events imported and Title, dates, times are correct. But nothing shows up in description field. I am not suing any special chars...just straight text (ie: Private party - 125 guests). Any ideas?

[@ChrisMenardTraining]

Christopher - send me the file and I'll look at it. [e-mail]

[@christopheralbino5343]

@@ChrisMenardTraining I tried it by enclosing the text in quotes and it worked. When no quotes, it did not. Odd...but it is what it is...

[@ericamarx6120]

Very helpful, thank you! Is there an easy way to clear all events from the previous import? I'm making a conference schedule and I'd like to make updates in the spreadsheet and then reimport the updated spreadsheet (without creating duplicate events and without manually deleting them from the calendar).

[@ChrisMenardTraining]

Erica, there is no easy way to do that. I would make a new calendar and import the events into the new calendar.

[@ericamarx6120]

​@@ChrisMenardTraining thanks for your response! It really is too bad there is not an easy way to do that. The issue for us with creating a new calendar each time is that there will be multiple versions of calendars floating around. And duplication of events as people copy events from the calendar to their personal calendars.

[@victore7707]

Can the csv file include a field to set the reminder (i.e. 2 hours before start time). If so, where should the field be located and how should the entry be displayed for a reminder 2 hours before?

[@gpoabissal]

Thank you!

[@ChrisMenardTraining]

You're welcome!

[@Luis-MFG]

Hey chris! How can i add notifications to the events that im creating using google sheets

[@soumyatjoy7920]

How to edit already imported excel in Google Calendar..Like small corrections when major part remains the same

[@leorc564]

HI Chris, nice techique, is the same for Outlook?

[@ChrisMenardTraining]

Similar. In Outlook desktop you go to Calendar, then File - Open and Export - Import/Export and go from there. drive.google.com/file/d/1zMPFzOdxDZannKo8gaiDKwOvH2SqLW8J/view?usp=drivesdk Here is Microsoft support page for importing CSV. support.microsoft.com/en-us/office/create-or-edit-csv-files-to-import-into-outlook-4518d70d-8fe9-46ad-94fa-1494247193c7

[@leorc564]

@@ChrisMenardTraining Thanks Chris, I will try!

[@leorc564]

Chris, i tried but it did not work. Google Calendar can not import my file, show this message: It can't be proceso the file iCal/CSV ,and I save as a CSV

[@leorc564]

@@ChrisMenardTraining I tried checking CSV format, only 2 columns, Subject and Date (with Date format) but it does not work. I opened on Notepad and I saw Subject ; Date and is this the problem (;)

[@leorc564]

@@ChrisMenardTraining and I work with Power Query to crean spaces, and delete symbols like ("), I tried to keep a clean text.

[@antoinetteforbes751]

Great video really helpful, thanks for sharing. Is there a way to make an event every Monday or every two weeks at all? Thanks

[@ChrisMenardTraining]

Yes! I'll make a video on how to do every Monday or whatever repeating time frame you want this weekend.

[@antoinetteforbes751]

@@ChrisMenardTraining amazing! Thank you so much!

[@debangshubanerjee1311]

any way to do this for google tasks?

[@MohammadAliEkram]

How should I remove the same added reminders?

[@joshsjams1]

Can you update that spread sheet and if you do will it duplicate events??

[@ChrisMenardTraining]

No that will not work. If you update the spreadsheet you would have to do the import again. I'll have to test to see what happens with the duplicates. I have a feeling it will import them again.

[@luphan4644]

This works great, but is there a way for Excel not to input blanks as (No title) on Google Calendar?

[@janicelaker3000]

Thankyou for this! One question. I want a 25 hour event to show start and end times on the calendar, so that I can print them from the calendar. Is there a way to do this please? Google shows 'all day' for anything over 24 hours when I try to print it.

[@dailylifehack4030]

there is a solution

[@nicb199]

Loved your video on events import into G- Calendar.I followed your video & it worked a dream when I did a test into my live calendar with one event using a CSV delimited file I then tried to upload a 2nd time but the Microsoft text wizard keeps opening and goes through the process to get the columns correctly formed by the wizard but every time I upload I get a message saying 0 of 0 uploaded. I have tried multiple things to get it to work but I have failed so any help would be appreciated.

[@ChrisMenardTraining]

send me your file. Make sure there is no sensitive or confidential information in it. [e-mail]

[@michelamutri3046]

i have the same problem

[@larsfunder]

It is because excel often use semi colon as seperator in CSV, however google calender only accepts comma seperated, open the file with Notepad ad replace semicolons with comma, worked for me.

[@larsfunder]

@@michelamutri3046 It is because excel often use semi colon ; as seperator in CSV, however google calender only accepts comma , seperated, open the file with Notepad ad replace semicolons with comma, worked for me. Quote from google Formatting errors Imports might have errors because the formatting is wrong in the file. Choose your filetype below for tips for checking your file's formatting: CSV file (file ends with "csv") Check that your file uses a comma as the delimiter Google Calendar doesn’t work with files that use a semicolon ( ; ) or colon ( : ) to separate fields. Make sure all fields are separated by commas.

[@brittneybash5272]

Awesome video! Is there anyway that you can make events different colors? Is there a way to assign events a color in the excel doc or would you have to change the colors for each event manually in the google calendar (i.e., appointments = blue, meetings = red, etc.)

[@Matt_4444]

This is exactly what I need, please can you show us how!

[@liamcobbe6403]

This is also what I am interested in knowing!

[@naveensiddha]

Hello Mr.Chris Where i can input the remainder duration, please let me know, I don't want that default of 10 mins I want to keep 2 days.

[@JuanRomeroFUGA]

I made an update to my Test Google Sheet and re imported it to Google Calendar. Now there are duplicates showing in my calendar. How can I remove the imported sheet from my calendar so they are removed from my calendar?

[@bellasalazar2231]

Okay. I’ve watched this video 1000 times, and I’ve done at least 30 test runs. But it is just not working for me. I changed all the times like you said, I formatted the dates the same way you did, all my headers and stuff are exactly correct, saved as a CSV, but every time I hit import into google docs it says it cannot process my file. What am I doing wrong? I know it’s something so obvious but I feel like I’ve tried everything. I have given up for tonight

[@ChrisMenardTraining]

send me your csv file. Make sure there is nothing sensitive or confidential. [e-mail]

[@LamaNorbou]

Hei Chris, thanks for the missing manual. In Europe, nobody would think of writing the date and time like that, but maybe it would work with other formats. I've been importing mainly all-day and multi-day events, and I really have a problem with the multi-day ones, even though some of them end incorrectly a day earlier. I can't figure out why that is. You didn't deal with multi-day events in the video.

[@ChrisMenardTraining]

Send me a sample of your file. For multiple day events, I do know it will work.

[@datmeme8967]

If you really want to do repeating events correctly, import the single event to your Google calendar then export the .ics and open it in a text editor. Then you just "find and replace all" for: END:VEVENT with RRULE:FREQ=YEARLY END:VEVENT That will make all the events repeating yearly. There's also "DAILY" "WEEKLY" etc. If you want to see what the proper fields are for different event settings, make an event with those options, export it and then open the .ics to see the format.

[@shellymcleanbent6085]

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

[@barlowcr]

I want to import Location as Latitude Longitude. Some sites said to put an @ sign in front. Others said something like Map@26.09163, -80.1118. But Google Calendar on Android doesn't seem to like this and sometimes thinks it is a phone number...

[@ChrisMenardTraining]

This test file worked for me. See the location I used drive.google.com/file/d/1OvEd-Scmp4Eg2YW_6-4Iptjs-Ml0oF5W/view?usp=drivesdk My Pixel 6 Pro opened it correctly.

[@lisawandrei9491]

What if you want to add an all day event but show as "free" not "busy?"

[@camsicle5806]

Thank youuuu!

[@ChrisMenardTraining]

Glad to help!

[@SilpaElizabeth]

Mine was imported successfully, but nothing is showing up on the calendar

[@petrogoosen6055]

Hi Chris. I have tried this many times, but there is an error I just can't seem to fix. When I download your CSV file and import it (as is) into my test calendar, it works. The moment I take your CSV file, do Text to Columns, then save again as CSV file, it does not work. I have made sure that the date columns are formatted as dates and that the time columns are formatted as time. I have also changed the date columns to display as our format (we don't show the month first, usually it is dd mm yyyy or less common yyyy mm dd). I have not altered your CSV template in other ways. I have been sitting at this for hours trying to find that one small thing that is in my way. Any advice?

[@kellykconsult]

Is there a limit to the # of items?

[@ChrisMenardTraining]

Kelly, I looked for that and did not see an answer. Are you getting an error message by chance?

[@kellykconsult]

@@ChrisMenardTraining it was the number of appointments. I was trying to import about 10 years worth lol. I think max is around 60.

[@tomnicolle195]

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.

[@dethknell-ghst10]

ok, so this really helped for most of it, but I cant for the life of it get the "All Day Event" to work, like I type in "FALSE" and it still comes in as an All Day Event, when I want it to only be an hour long event. I have typed all the Start and End date + times but it just isn't working

[@rossmcmurry3456]

I've followed this video the best I can but still hitting a wall. I saved as a csv from Google sheets. Will that effect it? I also home some text in my start time on some cells. I'm aware that won't go in but it shouldn't effect the rest of the times etc correct? Basically trying to import my baseball schedule into the calendar. Just keeps coming back as 0 of 0.

[@rossmcmurry3456]

Figured it out. My number was text on the end date and end time. Had my starts right. Thank you!!

[@ChrisMenardTraining]

you are welcome.

[@queenluvonda]

Hello, It is still not working for me. I am using a mac.

[@ChrisMenardTraining]

send me your csv file. [e-mail]

[@xion9119]

Genio!! Thanks!!

[@agungyogapratama3114]

Hello, can i get file with format .xls / .xlsx ?

[@natalieromero9498]

Every time I try this it just save 0 of 0 events imported. :/ Please help I really dont wanna have to input all these manually

[@ChrisMenardTraining]

Send me your file. [e-mail] nothing confidential please in the data.

[@issacalvarez9842]

Rather than events, how can I upload these as tasks?

[@ChrisMenardTraining]

Not possible without third party software.