Simple steps to export Google Calendar, get a .ics file and import it to Google sheets.
These steps allow you to DIY instead of using 3rd party apps that cost money or may read your data. It is private to you only and easy to setup.
For a visual overview tutorial on ics to csv conversion and full details, see our article at https://onescales.com/blogs/main/export-google-calendar-ics-to-google-sheets-excel and our youtube video at https://www.youtube.com/watch?v=BRGHDS_-rDI
- now supports recurring events up to 5 years forward.
- Create Google Sheet
- Open a google sheet
- Create Apps Script
- In Google Sheet Top Menu, Click on Extensions -> App Script
- Edit the Code.gs file and copy paste this repository Code.gs (https://github.com/onescales/google-calendar-ics-to-google-sheets/blob/main/Code.gs)
- Create new file via + icon called "UploadForm.html" and copy paste this repository UploadForm.html (https://github.com/onescales/google-calendar-ics-to-google-sheets/blob/main/UploadForm.html)
- Click on Deploy on top right hand side. Set a "project title" (for example - ICS Import) and click on "Deploy" -> "New Deployment"
- Set Permissions of Apps Script and Publish Make sure to deploy as "Web app" and autorize permissions.
- Go Back to Sheet
- Click on top menu "ICS Import" -> "Upload and Import ICS"
- Select .ICS file from your computer and click on "Upload ICS"
- Enjoy The Sheet!
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.
If this helped you in any way, please consider supporting us at https://buymeacoffee.com/onescales
If you have any suggestions, comments, insight or just want to say hi, thanks or share your experience, you can contact us at:
- Our WebSite: https://onescales.com/
- Contact Us: https://onescales.com/pages/contact
- Youtube Channel: https://www.youtube.com/@onescales
- Twitter/X: https://twitter.com/one_scales
- LinkedIn: https://www.linkedin.com/company/one-scales/