Set up all four Geo Suite add-ins in one go
Install the four add-ins, create one Google Maps API key that works in all of them, and enter your license keys.
What you need
- Your purchase email from pythonandvba.com with your license keys
- Excel on Windows, Mac or the web, with Microsoft 365 or Office 2021 and later
- A Google account where you can turn on billing (Google requires it, even inside its free monthly usage)
Install the four add-ins
Each add-in installs on its own from Microsoft Marketplace. Repeat these steps four times, once per add-in:
- In Excel, go to Home > Add-ins (or Insert > Get Add-ins).
- Search for the add-in by name and click Add.
- Its button appears on the Home tab. Click it to open the task pane.
Create one Google Maps API key
The add-ins talk to Google Maps directly with your own key, so the lookups run on your Google account and we never see your data. You do not need four keys: one key on one Google Cloud project runs all four add-ins, as long as that project has every API the four of them use.
| Add-in | Maps JavaScript API | Routes API | Geocoding API |
|---|---|---|---|
| Distance Calculator | Needed | Needed | No |
| Distance Matrix Calculator | Needed | Needed | No |
| Route Planner | Needed | Needed | No |
| Address Formatter | Needed | No | Needed |
| Geo Suite key | Enable | Enable | Enable |
- Sign in to the Google Cloud Console and create a project (any name).
- Enable all three APIs on that project: Maps JavaScript API, Routes API and Geocoding API.
- Make sure billing is enabled on the project. Google requires it even inside the free monthly usage, which covers typical spreadsheet workloads.
- Go to APIs & Services > Credentials, click Create credentials > API key, and copy the key.
The video sets up a key for one add-in and enables two APIs. For the Geo Suite, enable all three from the list above on the same project, so the one key works everywhere.
Optional: restrict your key. If you limit the key to specific websites in the Google Cloud Console, add both of these as separate entries under Website restrictions, then click Save. The same two entries cover all four add-ins:
https://addins.pythonandvba.comhttps://addins.pythonandvba.com/*
Paste the same key into each add-in
Do this once in each of the four add-ins, with the same Google key every time:
- Open the add-in from the Home tab.
- In the task pane, open the menu (top right) and go to Settings > Keys.
- Paste the key into the Google Maps API key field and click Save and test. The badge shows Valid.
Enter your license keys
The license key field is on the same Settings > Keys tab, above the Google key. In each add-in:
- Take the license key for that add-in from your Geo Suite purchase email.
- Paste it into the license key field and click Save and check. The badge shows Valid.
On a Team license, everyone on your team uses the same license keys, up to 15 devices per add-in. On a Single license the keys are for one person on up to 3 devices.
To try it out, click Insert sample data in any of the add-ins and run it. The results are written next to your data.
If something does not work
The usual causes are a Google project without billing, an API missing on the project (Address Formatter needs the Geocoding API, the other three the Routes API), or a website restriction that blocks Excel. The task pane names the problem in plain language. Each add-in also has a step-by-step check of the key, billing and APIs:
- Distance Calculator: Google key check
- Distance Matrix Calculator: Google key check
- Route Planner: Google key check
- Address Formatter: Google key check
Still stuck? Contact support and mention that you have the Geo Suite.
