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 (www.sheets2gca...) 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 no-substitute.... 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

[@PoojaPatel-v4k9t]

This is great! Do you have the template available?

[@jaisyseetvofficial]

hi sir.. thanks for this great idea.. and i notice also that you use a cool screen recorder.. is it a free tool or app as well? im quite interested if i can download it also for free.

[@pakiki4teaching]

Free - check out Screencastify. It is a google chrome extension.

[@TatumHartvigsen]

I am struggling to get the formula right. Can you share the formula?

[@PhilippeLarcher]

Hi, unfortunately I run into an authorization error