View Your Google Calendar in a New Way with Google Sheets

This video shows you how to import a Google Calendar into a Google Sheet. Once it is in Google Sheet you can easily customise the way you view your calendar looks with formatting changes.

This solution makes use of the Sheets2GCal (https://www.sheets2gcal.com/) extension to import a Google Calendar into a Google Sheet. Then with some clever formating of the date , and a custom formula, you can easily display multiple events in the same cell.

Massive thanks to Kim from https://no-substitute.com/ for his awesome Sheet function skills. This collaboration came about through the amazing Google Innovator community.

#googlecalendar #googlesheet #importcalendar #teachers #guide #tips #timesaving #spreadsheethelp #spreadsheet #google