Validate and Fix Mailing Addresses in Excel

The Excel Address Validator brings the Google Maps power and results directly into your Excel Spreadsheet. It allows users to validate and standardize a list of mailing addresses to ensure you have the correct addresses. It will fix and standardize partial or incomplete addresses to the standard USPS mailing addresses. 

Check out the video on how the Excel Matrix Driving Distance Calculator  works:

Who is the Excel Address Validator and Fixer for?

The Excel Address Validator and Standardizer allows users to update and fix a list of customer or other recipient addresses. It completes incomplete addresses (as long as there is enough information to identify the address) it formats it to the most up to date USPS standard and splits it, separating address, city, zip and state in multiple columns. It makes fixing your list of addresses a breeze. 

What is the Purpose of the Excel Address Validator and Fixer?

It allows the user to generate a clean list from your current addresses that you can use in mailing your customers. And it does it all in excel, without fancy and costly software. 

  • NO installation necessary. All you need is Excel in your desktop. 
  • NO programming know-how required. A spreadsheet with a "Generate" button in it and you are on your way to fixing your list of customer mailing addresses. 
  • NO monthly charges. Just a one time fee!
  • REAL help if you need it. If you have any questions, email, call or just talk to me on the chat on this site!

Get all your addresses cleansed all with the click of a button! 

How Does It Work?

Anybody can use the "Excel Mailing Address Validator" with three easy steps. 

Enter your current incomplete address list in the first column. Click "Generate"

The Excel Mailing Address validator will search and generate the standard USPS address in 2 formats

Validate and Fix Mailing Addresses in Excel

Frequently Asked Questions (FAQs)

While the Excel Address Validator works on some version of Mac Computers, I currently do not offer support for MACs. As Macs use different VBA libraries, that can cause some conflicts with some of the functions in this tool.

You will need a Google Maps API to use this tool!

All of our tools use the Google Maps API to generate results. This allows for accurate driving distance and time results and fast data. I have included some instructions on how to get a google maps API and what services to enable. Click here for more information on how to setup the Google Maps API Key.  

A few more things regarding the Google Maps API Key. 

You don't need to be a developer to setup a google maps api key. It takes about 5 minutes, and it is a simple as setting up an account with Google. 

  • The Google Maps API Key is free to setup. It doesn't cost anything. 
  • You will get up to 40,000 calculations free of charge. (Google allows for a 200 dollar credit for every calendar month). 
  • If you need more than 40,000 calculations in a calendar month, google charges an a-la-carte fee of 5 USD/1000 calculations. 
  • For most of my clients that use this tool, 40,000 calculations are more than enough. 
  • You will need to setup a billing account with Google, although you will not be charged unless you go over the 40,000 calculations per month. 
  • If you have a large number of calculations, (more than 40,000) contact me.  I might be able to help. 

Validate and Fix Mailing Addresses in Excel