Smarty's Excel & Google Sheets Plugins for Geocoding & Address Validation

Landon Fackrell
Landon Fackrell
 • 
September 26, 2023
Smarty's Excel & Google Sheets plugins for geocoding & address validation
Tags

Did you miss our recent webinar on how to use our new Google Sheets and Excel plugins for address validation? Don't worry; we've got you covered. This blog post provides an in-depth summary, highlighting essential functionalities, setup processes, and answers to some pertinent questions raised during the webinar. 

The Basics

We want to make it easier for businesses to validate addresses and retrieve necessary data efficiently. While we do have a bulk validation tool that can be accessed as a demo or a full tool, we find that most people are already working with address data in a spreadsheet form, usually in Excel. So instead of making you copy and paste your data into a validation tool, you can now use a plugin to access Smarty's address validation directly inside Google Sheets or Excel.

In this webinar we demonstrated on Google Sheets; however, an Excel version is also going to be available. The Google Sheets plugin we showcased is not yet available as of the date of publication, but should be available any day now, with the Excel version coming shortly after.

The plugin is designed to be as user-friendly as possible. The operation boils down to highlighting the addresses in your sheet and clicking a "Validate" button.

7y8LjFz5BBaddE1Mj8J1We7feFZ5DyFd8wt50-tS5WBDG0L2mRoxCNP7mhPdNcmaI4MJ0YFcMnYsF4eU7HXSNirOX_Reun5MIPF6bYAVITdm80xYWjwsGgnSq4A4HmcgDZE39WQ7Rt8D4PzO1nBNOTc

Functionality

While you can use the plugin to check just one address, doing bulk validation is really where the power of Smarty can be seen. Simply highlight a list of addresses, click validate, and retrieve all the validated data.

If you're used to using the bluk validation tool you'll be surprised to know that you do not need to have column headers, nor break your data out into separate components. The plugin currently supports freeform input, where the entire address is in a single cell. Split-cell functionality is still under development. So if you have your address data by components you'll need to join the cells before you process them.

Once you've processed your records, which happens with classic Smarty speed, you'll be able to view all of address data for each address validated. You'll see status messages, postal matches, and additional meta-data straight into your spreadsheet.

Getting Started

For Google Sheets, go to Extensions -> Add-ons -> Get Add-ons. You'll find the Smarty plugin listed in the Google Workspace Marketplace for free. For Excel, it'll be via the Excel store.

Once you've installed the plugin into either Google Sheets or Excel, simply insert your Auth ID and Auth Token, which you can retrieve from your Smarty API keys page.

Secret key interface from Smarty

Q&A

Q: How does it handle multiple candidate addresses?

A: Picks the first, best candidate, similar to our other bulk validation tools.

Q: Can it validate suite numbers?

A: Yes, suite numbers are validated, maintaining API functionalities.

Q: Do I still get deliverability and other data?

A: The plugin provides a status message for each address, and additional deliverability data is also available.

Q: When will the plugins be publicly available?

A: Google Sheets plugin is awaiting Google's review. The Excel version will be released subsequently.

Smarty's Google Sheets and Excel plugins promise to be powerful tools for professionals dealing with address data regularly. They offer a streamlined, efficient way to manage large datasets and validate addresses without the need to code.

If you're a CIO, data analyst, operations manager, or anyone who could benefit from these functionalities, keep an eye out for these plugins' release announcements.

Stay tuned for more updates from Smarty, and don't forget to check out our suite of address APIs for more robust solutions.

Eager to streamline your address validation process? Register to our newsletter to get notified when these plugins become publicly available.

You can view the entire webinar recording here:

Subscribe to our blog!
Learn more about RSS feeds here.
rss feed iconSubscribe Now
Read our recent posts
Spider-Man: Where is My Home?
Arrow Icon
At Avengers headquarters, Tony Stark is busily creating gadgets for Spider-Man as a thank-you for his dedication to superheroism. Stark places the final touches and debates how to deliver the package. He could suit up and deliver it himself, convince Doctor Strange to teleport it, or use the boring, everyday mail system.  Stark runs all these scenarios through his head— Doctor Strange's focus has been a little divided lately, so he'll probably mess up the location and drop it on some poor lady’s head.
Webinar Recap - Ensuring You Have Project US@ Data
Arrow Icon
Smarty recently hosted an enlightening webinar on Project US@, a vital initiative in health information technology. The webinar, led by Wes Arnold, Team Lead of Product Marketing, provided insights into Project US@ and its significant role in patient data management. What is Project US@?Project US@ is led by the Office of the National Coordinator for Health Information Technology in collaboration with HSC and AHIMA. The final version 1. 0 was released on January 7, 2022. The goal? The initiative's main objective is to establish a standard approach for representing patient addresses across all health IT systems.
The Importance of Fun: How Smarty Cultivates a Thriving Workplace Culture
Arrow Icon
We believe wholeheartedly that all work and no play is a dull way to spend our days. While many companies laser focus on productivity and output, we recognize that regularly infusing enjoyment and community into the workplace is essential for an engaged, thriving team.  Smarty's culture strikes a balance between innovation and fun, demonstrating that being serious about work doesn’t preclude being serious about play. This blog provides an insider's perspective into how our organization cultivates an energizing, recreational spirit across the company and why fun is a vital ingredient in our secret recipe for success.

The leader in location data intelligence

Ready to get started?