Get Started with the Excel Address Formatter

Set up the Excel Address Formatter workbook, then run a small example to check that everything works.

Video walkthrough #

The video includes Google’s pricing at the time of recording. Check Google’s current allowances and rates before running a large job; Google API usage is billed separately from your product license.

Open the workbook #

Download the ZIP from your purchase email and extract it. Open the extracted folder rather than running the workbook from inside the ZIP.
On Windows, right-click the downloaded .xlsm workbook and choose Properties. If Unblock appears, select it and click Apply.
Open the workbook in desktop Excel. If Excel displays a macro warning for this downloaded product file, click Enable Content.

Enter your keys #

On the Settings sheet, paste the license key from your purchase email into License Key.
Click Get your API KEY here to open Google Cloud. Create or select a project, link an active billing account, and enable the Geocoding API in that project.
Create or copy an API key for that project and paste it into Google Maps API Key in the workbook. The license key and Google API key are two different keys.

Run your first example #

Open the Formatter sheet and enter one address per row in the input column. Start with the supplied examples if you want to test the setup.
Click Format Addresses and wait for the progress bar to finish.
Check the returned address details before using them. If a result is unexpected, add a city or country to the input and try again.

Save the workbook to keep your settings and results.

Google Maps API not working? Follow the step-by-step API troubleshooting guide to check your key, billing and required APIs.