Data connectors

Google Calendar

CsvExplorer can import events from any iCalendar (ICS) feed — including both public and private Google Calendar URLs — and turn them into a structured table you can analyse and visualise. No API key needed.

What CsvExplorer imports

Each calendar event becomes one row. The columns extracted from the ICS feed include:

Summary (title)StartEndDuration (hours)DescriptionLocationStatusUID

1 — Get the ICS URL from Google Calendar

1

Open Google Calendar settings

Go to calendar.google.com. In the left sidebar, hover over the calendar you want to share, click the three-dot ⋮ menu, and choose Settings and sharing.

2

Choose which iCal URL to use

In Integrate calendar, Google provides both a Public address in iCal format and a Secret address in iCal format.

Note: The secret/private URL works with CsvExplorer and keeps the calendar unlisted. Treat it like a password — anyone with that URL can read your events.
3

Copy the public ICS address

Scroll down to the Integrate calendar section. You will find two links:

  • Public address in iCal format — use this for public calendars.
  • Secret address in iCal format — use this if you want to keep the calendar unlisted but still accessible. Anyone with the link can read the events.

The URL looks like one of these:

https://calendar.google.com/calendar/ical/CALENDAR_ID/public/basic.ics
https://calendar.google.com/calendar/ical/CALENDAR_ID/private-<TOKEN>/basic.ics
Tip: For the secret address, the URL contains a long random token. Treat it like a password — do not share it publicly if the calendar contains sensitive events.

2 — Load the calendar in CsvExplorer

4

Add a Calendar source

Open CsvExplorer and go to the Explorer.

  1. In the Source panel, click Add source.
  2. Select Calendar as the source type.
  3. Paste the ICS URL you copied in step 3 into the URL field.
5

Fetch the calendar

Click Fetch URL to load the events from the ICS feed into CsvExplorer.

3 — Visualise and save as a dashboard

6

Explore and chart your calendar data

Once loaded, the events appear as rows. You can use any chart type — for example a Bar chart to count events per week, or a Calendar chart to show event density over time.

7

Save the dashboard

Click Save dashboard to save your configuration. Enable Public dashboard in the settings dialog to share a live view with anyone — no sign-in required for viewers.

Note: The dashboard stores the ICS URL. When a viewer opens the public link, CsvExplorer re-fetches the calendar so the data is always current.

Ready to connect your Google Calendar?

Open Explorer →