Validate and Fix Mailing Addresses in Excel
Validate and Fix Mailing Addresses in Excel
The Excel Address Validator is an Excel-based tool that allows YOU as the user to Validate and Standardize a list of Addresses directly in an Excel spreadsheet.
Couldn't load pickup availability
Our Software is Used by:
Validate and Fix Mailing Addresses in Excel
A quick Demo Video of how the Excel Address Validator works!
The Excel Address Validator integrates the power of Google Maps directly into your Excel spreadsheet. This tool enables users to validate and standardize mailing addresses, ensuring accuracy. It corrects and completes partial or incomplete addresses, converting them to standard USPS mailing formats.
Why the "Excel Address Validator" is the tool you need to validate and standardize addresses at once?
My goal here at ExcelDistanceCalculators.com is to provide the easiest-to-use and most affordable tool of its kinds.
Nothing to Install
As the tool is built in Excel, there is nothing to install. Just open the file, paste your data.
One Click Gets you Results
Once you paste the data, you click "Run" and the Standardized Addresses will show on your page. It's that easy.
No Ongoing Charges
Once you purchase my Excel Mailing Address Validator...you own it for life. No monthly or annual charges. Consider the Multi-User license for Unlimited Users.
World Class Support
If you have any questions...just Call me @ 801-243-8350 or Chat with me via the Chat Window. If needed, I will Zoom with you to make sure the product is setup correctly and you get all the help you need...in real time.
100% Money Back Guarantee
If for any reason....you feel the product will not meet your needs....Just send me a note, and I will refund your purchase...NO QUESTIONS ASKED!
Oh just So Easy to Use!!
It will be the easiest to use tool of its kind. Just "Paste" the "Addresses" into the spreadsheet...click "Run" and the Standardized Mailing Addresses will appear as if Magic. No Coding Necessary!!!!!
How Does It Work?
Step 1: Enter your current incomplete address list in the first column. Click "Generate"
Step 2: Click RUN
Step 3: Watch the tool generate the standard USPS address in 2 formats.
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 is necessary. All you need is Microsoft Excel installed on your computer.
- 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!
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 do our Customers Say about us!
Steve Whenman - Software Worked Perfectly
The Software installed perfectly, really pleased with the results.
Matthew Smith - It's amazing, love it!
It's amazing, love it!!! Saved me weeks of analysis!
Hanna Ferguson - Software Works Perfectly
This excel sheet is going to make a massive difference to how much time we spend on mileage calculations!
Thank you so much for creating this.
Milan Stamenkovic - It's a Great Program
Everything is working great so far. It's a great program.
Travis Robey - This product is amazing
The Product is Amazing!
Robert Phillips - From Ohio
No Issues with the software.
Vinnie, thanks for making such a great product.
Bob
Mandy Miller - I absolutely love the tool!
This tool was so helpful and worked like a charm.
Steve Whenman - Software Worked Perfectly
Matthew Smith - It's amazing, love it!
Hanna Ferguson - Software Works Perfectly
Milan Stamenkovic - It's a Great Program
Travis Robey - This product is amazing
Robert Phillips - From Ohio
Mandy Miller - I absolutely love the tool!
Frequently Asked Questions (FAQs)
-
Does this software work on Mac, or just PC?
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.
-
Is this a one time fee, or ongoing?
You will only pay once for this software. This will provide upgrades and live support via zoom if needed for one year. However the software should serve your needs for years to come.
-
Do I need a Google Maps API Key? What is a Google Maps API key?
The Excel Address Validator uses the Google Maps Platform to give you extremely accurate (to the 1/100th of a mile). As such you will need to setup a google maps account. It takes 5 minutes to setup and it is free of charge. You can view the instructions on how to setup the google maps api key in this page. I have also created a video where it shows step by step how to setup the api key by clicking in this youtube video.
-
Is the Google Maps API key free? Do I have to pay for my calculations?
The Excel Address Validator uses the Google Maps Platform to give you extremely accurate (to the 1/100th of a mile). As such you will need to setup a google maps account. It takes 5 minutes to setup and it is free of charge. You can view the instructions on how to setup the google maps api key in this page. I have also created a video where it shows step by step how to setup the api key by clicking in this youtube video.
-
Is the Google Maps API key free? Do I have to pay for my calculations?
The Google Maps API key is free to get. However, keep in mind Google does require you to setup an account. You can run up to 40,000 calculations every calendar month free of charge. If you go over the 40,000 calculations Google charges an a-la-carte fee of 5 USD/1000 queries/calculations. More information on Google Maps API Pricing can be fond in this link.
-
Can the Excel Address Validator be used for non-US addresses? Can I enter, say Canadian or British Zip Codes?
Absolutely. The Excel Address Validator works with addresses from all over the world.
-
What is the maximum number of addresses I can run at any one single run?
The Excel Address Validator is meant to help you cleanse sizeable address lists. However keep in mind that the calculation is at the rate of about 3-5 calculations per second. So a 200,000 calculations data set would not be practical as it would take quite a long time. In addition, be aware of the costs associated with running such a large number of address sets. Refer to the API Setup Page for more information, but as to current time google allows for 40,000 addresses monthly free of charge. (the first 200 dollars worth of charges are free every month)
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 on this video 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.
