Export Google Calendar ICS to Google Sheets (excel)

Simple steps to export Google Calendar, get a .ics file and import it to Google sheets.

 

These steps allow you to DIY ics to csv conversion instead of using 3rd party apps that cost money or may read your data. It is private to you only and easy to setup.


Don't Feel Like Reading? We Made a Video Explaining the Full Details of the Topic. Click Here to Scroll Down to The Video

Steps

1. Open New Google Sheet

2. Create Apps Script

 

  1. Access Apps Script: In your Google Sheet, go to the top menu and click on "Extensions" -> "Apps Script."
  2. Edit Code.gs: In the script editor, replace the existing code with the content from this repository's Code.gs
  3. Add New UploadForm.html file: In the script editor, create new file and replace the existing code with the content from this repository's UploadForm.html
  4. Deploy: After editing, set a project title and click on "Deploy" -> "New Deployment."

3. Set Permissions and Publish

  1. Deployment Type: Make sure to deploy as a "Web app."
  2. Go back to apps script and click on run.

4. Go Back To Sheet

  1. Click on top menu "ICS Import" -> "Upload and Import ICS"
  2. Select .ICS file from your computer and click on "Upload ICS"

5. Enjoy!

Additional Notes

  • If you would like to open .ics in Excel, then follow all steps above and in Google Sheets, click on "File" -> "Download" - "csv" and open in Excel the csv file.

GitHub URL

For the full code and updates, visit our GitHub repository.

View Entire Topic Via Our Youtube Walkthrough:

Leave a comment

Please note, comments need to be approved before they are published.

Tags

Thank You For Reading Our Articles!

We're committed to delivering real answers, valuable insights, and efficient knowledge online. Join us by subscribing, sharing, and engaging with our community to make a difference!