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!!!
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
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.
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.
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.
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
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?
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!
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!!!!
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 ;-)
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.)
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
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
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)?
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?
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?
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
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.
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.
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.
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?
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?
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.
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 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?
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.
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?
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?
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 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.
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...
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.
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?
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.
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.
I tried importing your .csv but to a test calendar but it just says "Oops, we couldn't import this file. Please try again in a few minutes". I tried with other .csv files with the proper headers but they still did not work.
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.
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.
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.
@@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.
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
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
@@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 (;)
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.
Hello, google calendar told me the same. I was saving the doc from excel (and not google sheets). I think the problem was that on excel the .cvs use ";" to separate the datas and google calendar only accept the ",". Which is why we need to go through google sheets which does use the "," separation. Hope this will help
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!!!
Glad to help and I'm glad the import worked.
thank you so so much. was my first time to try it and it worked
You're welcome!
This is GREAT! I can share a list of events with my students and they will automatically populate! You rock!
Good plan. Your students will appreciate it. Thank you!
Thank you for this video. I was struggling to find out how to do this. This video was very useful
You're welcome!
i appreciate you specifying the formatting - that helped so much thank you!
Thanks, Mac!
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
Thank you so much for all the future hours I´ve saved because of this video
Is there a way to add Quest to the calendar system or does that have to be manual
Very helpful, thank you Chris, makes my job easier
Glad to help. Thank you!
Well done Chris. Right on the money! Love your work.
Thank you!
Fabulous video extremely helpful ! 🔥
Thank you!
Thank you. very useful. I used these steps to import and worked.
You're welcome!
Thanks for your excellent tutorial!
You are welcome!
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?
Always knew this was possible, but couldn't for the life of me find the required format (columns/order) in the Google documentation. Thanks!
Hey Chris, just wanted to say thanks this is exactly what I was looking for, in deep details. Keep up the good work!
Thanks, will do!
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.
Already created. The video is in this blog post. chrismenardtraining.com/post/import-csv-file-with-recurring-or-repeating-events-into-google-calendar
Thanks for your helpful video.
You are welcome
Thanks for your comments
Welcome
Thanks!
Thank you for the donation! Much appreciated.
very useful video, Chris. Thanks for sharing it
Glad it was helpful! Thanks, Danilo.
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.
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.
This video was exactly what I was looking for thanks!
Glad to hear it! Thanks, Josh!
Thanks! This worked for me
You're welcome!
Genio!! Thanks!!
Thank you Chris!
You are welcome.
Thanks for the great video, Please let me know how can it be repeat every year, Like birthday and Anniversary
Thank you!
You're welcome!
When you make changes/add more rows in the spreadsheet, how do you get it to update on the calendar ?
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
The only workaround I have found is to pull them into a new calendar and make the calendar default reminder ten minutes.
Hi Super Thank you!!!
Welcome 😊
Can you set a reminder for this?? Also can you add to this where it won't duplicate dates?
Hi, Chris. This tutorial makes my job easier. Thank you
Is there a way to add a notification alarm?
Thank you. No way to add a notification on the import.
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?
It worked perfectly. But I have one question, how to add an alert before event in excel?
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.
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!
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!!!!
I wish that was possible but it isn't. I've tried.
what should be the field name in the XL to make it a yearly recurring events like a birthday ?
Hi, Chris. Thanks for the ussful video. May I ask if it would be possible to make an event repeating?
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 ;-)
Thank youuuu!
Glad to help!
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.)
This is exactly what I need, please can you show us how!
This is also what I am interested in knowing!
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
Have you ever figured out a solution? My exact situation...
@@mosheteldon3919 not possible to import recurring. sadfaceeee
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
Can you add invitees to these events that you upload? Thanks in advance!
That would be a great feature, but you have to manually do the invitees.
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
send me your csv file. Make sure there is nothing sensitive or confidential. chrisamenard@gmail.com
Dorcell, i appreciate that ! i applied it for compay PDC reminder, thanks, thanks a lot helpful for learning
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)?
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?
From my testing, it imports the same events. So you would have two events possible twice and the new events once.
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?
Send me your file please. chrisamenard@gmail.com
Same problem here, i'm in Germany using Mac
hey Chris - is there a way to add a columns for "Guests", i tried to add Guests as a column it didnt take it.
Would be a nice feature, but it can't be done.
So can you share the calendar with others to see the imported information?
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
What if you want to add an all day event but show as "free" not "busy?"
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
Send me your file please. I'll look at it. ChrisAMenard@gmail.com
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.
Can you update that spread sheet and if you do will it duplicate events??
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.
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.
Hey! Super helpful, could you add tasks instead of events?
Is there a way to repeat events over a specific amount of days?
Yes. You have to do this in the csv file. ua-cam.com/video/9HGMy11LMCY/v-deo.htmlsi=CWeMvIYzNQZ6cyX8
This works great, but is there a way for Excel not to input blanks as (No title) on Google Calendar?
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?
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?
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.
Send me a sample of your file. For multiple day events, I do know it will work.
any way to do this for google tasks?
Great video really helpful, thanks for sharing. Is there a way to make an event every Monday or every two weeks at all? Thanks
Yes! I'll make a video on how to do every Monday or whatever repeating time frame you want this weekend.
@@ChrisMenardTraining amazing! Thank you so much!
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
How to edit already imported excel in Google Calendar..Like small corrections when major part remains the same
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?
Send me your CSV file. chrisamenard@gmail.com
@@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?
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.
That can't be done. It would be a great feature.
Is there a way to differentiate time zones? We have two satellite offices that are on eastern while our main office is central.
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?
I was wondering if there is a way to add a colum to repeat the event yearly.
Yes. It is a workaround but here is my video. ua-cam.com/video/9HGMy11LMCY/v-deo.html
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?
Christopher - send me the file and I'll look at it. chrisamenard@gmail.com
@@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...
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).
Erica, there is no easy way to do that. I would make a new calendar and import the events into the new calendar.
@@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.
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...
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.
Hello Chris, is there a way to have reoccurring appointments? I am creating a family calendar for three kids with all activities they have
By default no, but I have a work around video. Old but still is how you would do this. . ua-cam.com/video/9HGMy11LMCY/v-deo.html
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.
I have the same error of 0 imports.. =/ Just sent you my csv file.. thanks!
I have tried multiple times and isn't working. Any tip?
send me your file chrisamenard@gmail.com
Hey chris! How can i add notifications to the events that im creating using google sheets
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?
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
Send me your file. ChrisAMenard@gmail.com nothing confidential please in the data.
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.
still does not work?? tried every csv format and still moves nothing across??
Hello Chris, is it possible to colour code CSV file for excel? Thank you for your video
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.
I tried importing your .csv but to a test calendar but it just says "Oops, we couldn't import this file. Please try again in a few minutes". I tried with other .csv files with the proper headers but they still did not work.
Hey Chris, may i put "event colors" in the excel file ?
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.
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.
there is a solution
Hello, It is still not working for me. I am using a mac.
send me your csv file. chrisamenard@gmail.com
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.
send me your file. Make sure there is no sensitive or confidential information in it. ChrisAMenard@gmail.com
i have the same problem
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.
@@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.
Is there a limit to the # of items?
Kelly, I looked for that and did not see an answer. Are you getting an error message by chance?
@@ChrisMenardTraining it was the number of appointments. I was trying to import about 10 years worth lol. I think max is around 60.
How to add guests in google calendar
That isn't possible with an import.
@@ChrisMenardTraining thank you so much for response your video is too much helpful for me...
HI Chris, nice techique, is the same for Outlook?
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
@@ChrisMenardTraining Thanks Chris, I will try!
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
@@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 (;)
@@ChrisMenardTraining and I work with Power Query to crean spaces, and delete symbols like ("), I tried to keep a clean text.
if i need to remove the CSV file from google calendar, how do i do that?
I'd irs repeat year how to creat
I tried it million times but won't work, could you please have a look at it?
send me your file - chrisamenard@gmail.com Put in the subject line *CSV into Google calendar*
Rather than events, how can I upload these as tasks?
Not possible without third party software.
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.
Figured it out. My number was text on the end date and end time. Had my starts right. Thank you!!
you are welcome.
HELP! How do I deleted the CSV I imported?
You have to delete the events from the calendar. There is no method to do a mass delete.
I've tried everything! and still get the error message "Imported 0 out of 0 events. Unable to process your iCal/CSV file"
Hello, google calendar told me the same. I was saving the doc from excel (and not google sheets). I think the problem was that on excel the .cvs use ";" to separate the datas and google calendar only accept the ",". Which is why we need to go through google sheets which does use the "," separation.
Hope this will help
Hello, can i get file with format .xls / .xlsx ?
Why this is not work for me?