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!!!
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
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.
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.
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
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
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!
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?
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.
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.
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?
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.)
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?
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.
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?
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
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.
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!!!!
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?
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.
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 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?
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.
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 ;-)
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
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.
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.
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?
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 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.
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)?
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
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.
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.
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.
I tested and my CSV file does work,. I got 13 of 13 events. drive.google.com/file/d/1sKc9vqJUfmZlvf0zaY8LL6PTbzOg20kE/view?usp=drivesdk Send me your file and I'll look at it this evening. chrisamenard@gmail.com
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.
Can you set a reminder for this?? Also can you add to this where it won't duplicate dates?
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.
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
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.
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.
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.
I have tried multiple times and isn't working. Any tip?
send me your file chrisamenard@gmail.com
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.
Is there a way to repeat events over a specific amount of days?
Yes. You have to do this in the csv file. th-cam.com/video/9HGMy11LMCY/w-d-xo.htmlsi=CWeMvIYzNQZ6cyX8
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
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?
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
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!
Hi, Chris. Thanks for the ussful video. May I ask if it would be possible to make an event repeating?
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
what should be the field name in the XL to make it a yearly recurring events like a birthday ?
It's helpful but how can I create the calendar you have here using as a sample
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
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.
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?
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!
Fabulous video extremely helpful ! 🔥
Thank you!
When you make changes/add more rows in the spreadsheet, how do you get it to update on the calendar ?
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?
still does not work?? tried every csv format and still moves nothing across??
What if you want to add an all day event but show as "free" not "busy?"
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.
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.
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*
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.
any way to do this for google tasks?
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.
Thank you for this video. I was struggling to find out how to do this. This video was very useful
You're welcome!
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. . th-cam.com/video/9HGMy11LMCY/w-d-xo.html
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.
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.
Very helpful, thank you Chris, makes my job easier
Glad to help. Thank you!
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...
thank you so so much. was my first time to try it and it worked
You're welcome!
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.
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?
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.
I'd irs repeat year how to creat
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.
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 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...
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?
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.
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 ;-)
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!
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. th-cam.com/video/9HGMy11LMCY/w-d-xo.html
Hello, It is still not working for me. I am using a mac.
send me your csv file. chrisamenard@gmail.com
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
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
Well done Chris. Right on the money! Love your work.
Thank you!
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.
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 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.
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?
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 edit already imported excel in Google Calendar..Like small corrections when major part remains the same
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
i appreciate you specifying the formatting - that helped so much thank you!
Thanks, Mac!
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?
Thanks for the great video, Please let me know how can it be repeat every year, Like birthday and Anniversary
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.
very useful video, Chris. Thanks for sharing it
Glad it was helpful! Thanks, Danilo.
Thanks!
Thank you for the donation! Much appreciated.
Thanks for your helpful video.
You are welcome
This works great, but is there a way for Excel not to input blanks as (No title) on Google Calendar?
Genio!! Thanks!!
Thanks for your excellent tutorial!
You are welcome!
Rather than events, how can I upload these as tasks?
Not possible without third party software.
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!
I tried so many times and it doesnt work :(
send me your file chrisamenard@gmail.com
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
Hey chris! How can i add notifications to the events that im creating using google sheets
I have the same error of 0 imports.. =/ Just sent you my csv file.. thanks!
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.
Mine keeps making every event all day even though I have it set as FALSE
Always knew this was possible, but couldn't for the life of me find the required format (columns/order) in the Google documentation. Thanks!
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)?
This video was exactly what I was looking for thanks!
Glad to hear it! Thanks, Josh!
Thanks! This worked for me
You're welcome!
if i need to remove the CSV file from google calendar, how do i do that?
Hello, can i get file with format .xls / .xlsx ?
Thanks for your comments
Welcome
Hi Super Thank you!!!
Welcome 😊
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
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!
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.
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
thank you for the helpful tutorial
Thank you Chris!
You are welcome.
Why this is not work for me?
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.
super tutorial but it's not working for me
even your calendar not working
I tested and my CSV file does work,. I got 13 of 13 events. drive.google.com/file/d/1sKc9vqJUfmZlvf0zaY8LL6PTbzOg20kE/view?usp=drivesdk Send me your file and I'll look at it this evening. chrisamenard@gmail.com
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.
Hey! Super helpful, could you add tasks instead of events?
Thank you!
You're welcome!