Menu
View Categories

Getting started

This guide takes you from installing the Address Formatter add-in to your first result. It takes about ten minutes, most of which is creating your Google Maps API key.

1. Install the add-in #

  • In Excel, go to Home > Add-ins (or Insert > Get Add-ins), search for Address Formatter, and click Add.
  • A Address Formatter button appears on the Home tab; click it to open the task pane.

2. Enter your license key #

  • Your license key is in the purchase email from pythonandvba.com. If you do not have one yet, you can get it here.
  • In the task pane, open the menu (top right) and go to Settings > Keys.
  • Paste the key and click Save and check. The badge shows Valid.

3. Create and connect your Google Maps API key #

The add-in talks to Google Maps directly with your own API key, so calculations run on your Google account and we never see your data. Google gives new accounts free monthly usage that covers typical spreadsheet workloads.

  • Sign in to the Google Cloud Console and create a project (any name).
  • Enable these two APIs for the project: Maps JavaScript API and Geocoding API.
  • Make sure billing is enabled on the project. Google requires it even inside the free usage tier.
  • Go to APIs & Services > Credentials, click Create credentials > API key, and copy the key.
  • Back in Excel, paste it under Settings > Keys and click Save and test. The badge shows Valid.

If you restrict the key to specific websites in the Google Cloud Console, allow https://addins.pythonandvba.com/*, or Excel’s requests will be rejected.

4. Run your first calculation #

Click Insert sample data, select the address column, pick the output fields you want on the Output tab, and click Format addresses. The structured columns are written to the right of your data.

Formulas #

The add-in also installs worksheet functions:

  • =GEO.FULL(A2) returns the standardized address.
  • =GEO.LAT(A2) and =GEO.LNG(A2) return coordinates.
  • =GEO.FIELD(A2, "city") returns a single component.

Results are cached locally, so recalculating a workbook does not re-query addresses it already knows.

Having trouble? #

The most common causes are a Google key without billing, a missing API on the project, or a website restriction that blocks Excel. The task pane shows a plain-language message for each of these. If you are stuck, contact support.