How to Export Google Calendar ICS & Import to Google Sheets (Excel)

[@satviksaini2106]

You're a savior!

[@onescales]

@@satviksaini2106 happy it helped you!

[@leticiadrasler23]

Amazing explanation thanks so much

[@onescales]

@@leticiadrasler23 happy you liked it!

[@FredWalkover]

The export worked for me, but recurring events do not seem to show for each event. Ideas?

[@onescales]

Hi Fred. Code now supports recurring events up to 5 years forward - see code at github.com/onescales/google-calendar-ics-to-google-sheets/

[@b.danzurun5627]

Hi, I did it but I noticed "No HTML file named UploadForm was found.", when I tried to click on the new button "ICS import" in the menu of Google Sheets.

[@onescales]

@@b.danzurun5627 make sure that when you created the file called UploadForm and copied the code from GitHub as shown in video. Make sure to have file name exactly and make sure that the U in upload and F in form is capitalized

[@SuperFidella]

Did you accidentally name your file UploadForm.html.html ? When I first created the file I noticed that the extension was automatically added to my file name which I had included the extension already so it appeared twice. I am still waiting for my upload to process... so not sure if I will end up with the same error as you or not.

[@onescales]

@@SuperFidellawhen you add it do not add .html at end. The system will do it for you

[@SuperFidella]

@@onescales not sure why you marked me as the reply to since that’s exactly what I was pointing out to the previous poster.

[@onescales]

@@SuperFidella sorry about that. Got it. Did the upload finish ? If so can you share the size of the ics file and the time it took. This can help the community. For example I just ran a 5.5 mb ics file and it took about 5 hours