Google Sheets Add-on Extension

The Smarty Address Verification add-on validates US addresses and returns relevant metadata. With a rooftop geocoding subscription, users have the option to return rooftop precision geocodes.

Quick-start video

Getting started

Install the add-on here

Note: You must have an existing Smarty US Address Verification or US Rooftop Geocoding license. If you do not have a license, sign up here for a free trial.

After installation from the store, go to "Extensions" on the top ribbon and down to "Smarty Address Verification"

Go through a quick authentication process

1. Select the "Add Credentials" button

   

2. Enter your auth ID and auth token

   These values are found within your Smarty account under the "API Keys" tab
   
   Auth ID and auth token are stored securely within the sheet’s memory. This allows the sheet to be worked on and shared collaboratively.

3. Click submit

Using the Add-on

1. To open and use the add-on, select "Extensions", then select "Smarty Address Verification", and lastly "Show Tools".

   Smarty tool sidebar

2. Choose between an "enhanced or strict" match type

3. Fill in the text box indicating what license you want to use

   This is not required, but is recommended if you have subscriptions to multiple licenses

4. Choose to keep the results on the same page you’re currently working in, adjacent to the highlighted cells, or place the results formatted in a new sheet

5. Highlight the addresses you would like to verify

   • A single cell should only contain a single address
   • Validation only works on addresses within a single cell so addresses should not be parsed or broken up across adjacent cells

6. Select the result you would like to receive:

   Validate selected addresses

   Returns:

   • Status message ex. "Address successfully verified"

   • Validated addresses

   • DPV footnotes

   Validate and retrieve geocodes

   Returns the same info as ‘Validate Selected Addresses’, plus:

   • Geocodes

   • Geocode precision level

   Validate and retrieve all data

   Returns all the data available from the US Street Address API, including the validated address and metadata.

Important notes

• Any existing data in cells where the new address data is placed will be overwritten

• When a user runs one of the Smarty tools, the header data will be populated automatically

  *Leave the top row of cells empty so the headers can populate correctly

4 more ways to validate in bulk

1. Web Interface Tool

2. Microsoft Excel Add-In

3. QGIS mapping software

4. Command Line Interface (CLI)