Google Sheets Add-on extension

The Smarty Address Verification add-on validates and returns relevant metadata for US and international addresses. 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: To use US Address Verification, you will need to have an active Smarty US Address Verification or US Rooftop Geocoding license. To use International Address Verification, you will need to have an active Smarty International Address Verification or International Geocoding license. If you do not have a license, sign up here for a 42-day free trial.

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

Google Sheets Extension Smarty Address Verification button

Go through a quick authentication process

Select the "Add Credentials" button
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.
Click submit

Address Formatting

Organize your data into columns, using one of the combinations shown below. (The more data provided, the better.) The top row MUST consist of column titles, spelled exactly as you see here.

For US Addresses:

If you have secondary information (apartment/suite/etc.) in a separate column, label that column secondary. Such a column can be added to any of the first three combinations shown above. For example:
street | secondary | city | state | zipcode

street	city	state	zipcode
11310 Old Seward Highway	Anchorage	AK	99515
3211 Edwards Lake Pkwy	Birmingham	AL
11219 N Rodney Parham Road			72212
4507 North US Highway 89	Flagstaff	AZ	86004

For International Addresses:

COUNTRY	ADDRESS1	LOCALITY	ADMINISTRATIVE_AREA
Germany	Marienplatz 1, München, Bayern, 80331	Berlin	Berlin
Russia	Krasnaya Ploshchad 1	Moscow	Moskva
Japan	1-1 Chiyoda	Chiyoda-ku	Tokyo
Germany	Römerberg 27	Frankfurt am Main	Hessen

Still not quite sure? Take a peek at this sample spreadsheet.

Using the add-on

Once you have your column names and addresses in the sheet, you are ready to go! To open and use the add-on, follow these steps:

Select “Extensions” → “Smarty Address Verification” → “Show Tools”.
Choose your Product.
If using US Address Verification, choose between an "enhanced or strict" match type.
Learn more about strict vs enhanced here.
Choose a Validation Type.
1. Validate Only
  Returns:
  – Status message ex. "Address matched"
  – Validated addresses
  – DPV footnotes
2. Validate + Geocode
  Returns the same info as ‘Validate Selected Addresses’, plus:
  – Geocodes
  – Geocode precision level
3. Validate + All Metadata
  Returns all the data available from the US Street Address API, including the validated address and metadata.
4. Extra options may pop up in "Advanced Settings" for different product and validation types, including:
  – Advanced License Input (For those with special licenses)
  – Format
  – County Source
  – Features
  – Output Language
Choose to insert the results on the same page you’re currently working in (adjacent to the highlighted cells) or to insert the results into a new sheet.
Highlight the addresses you would like to verify.
Click “Validate” and watch the magic happen!