Is it possible to link an Excel planner to a Google calendar?

Answer 1

You can link an event in your Excel based calendar to your Google Calendar by inserting a hyperlink in Excel to the unique URL for the corresponding event in your in your Google Calendar. However it is not possible to dynamically "link" an entire Excel based calendar to Google Calendar so that event updates in Excel will automatically be reflected in your Google Calendar.

You can however create a simple Excel based process to export new calendar events to a CSV file which you can then manually upload to Google Calendar:

1) Insert a worksheet into your Excel planner with row headers which exactly match the Google Calendar fields listed here: https://support.google.com/calendar/answer/37118?hl=en. 

2) Have the fields in the worksheet reference the relevant event fields from elsewhere in your Excel planner. For example if the new worksheet is ‘Sheet 2’ and the event data source is on ‘Sheet 1’ then map the cells in ‘Sheet 2’ to the corresponding cells in ‘Sheet 1’

3) Insert an ‘Active X’ button on the new worksheet which links to a macro which first saves this worksheet as a separate CSV file to your desktop and then opens the following hyperlink: https://calendar.google.com/calendar/r/settings/export

4) Execute the macro by clicking the ‘Active X’ button. Once the Google Calendar import dialog opens, select the new CSV file on your desktop and import that file to your Google Calendar.