Validate and Fix Mailing Addresses in Excel
Stop wasting time on returned mail and manual lookups. This Excel tool connects to Google Maps to validate, standardize, and clean your entire address list in USPS format — right inside the spreadsheet you already use.
How it works
Paste your address list. Get clean, USPS-standard addresses back.
You paste your list of mailing addresses into Address Validator. You click the button, and the tool runs each address through Google Maps validation, correcting abbreviations, capitalization, and structure. Standardized, USPS-format addresses are filled back into your spreadsheet automatically — no separate account setup, no third-party website, no checking entries one by one. Validate and fix hundreds or thousands of addresses in one pass.
See it in action
Three steps. Under a minute. Real screen recordings from the tool.
Paste your address list into Excel
Drop your full mailing address list into a column. No formulas, no macros to configure.
Click to validate and fix
One click sends every address to Google Maps for validation. Your data stays in your file, your API key stays in your Google account.
Get clean, USPS-standard addresses back
Corrected, standardized addresses populate right inside your spreadsheet — ready to ship or mail with confidence.
Who it's for
Built for teams that ship, mail, or store addresses at scale — and need every entry deliverable before it goes out the door.
Shipping & fulfillment teams
Dealing with large customer address lists and need to cut down on failed deliveries and returned packages before they ship.
Operations & data managers
Responsible for maintaining clean CRM or ERP data and need a fast, reliable way to standardize address records across the business.
Direct mail marketers
Running postal campaigns and need every address on their list to be accurate, properly formatted, and deliverable before going to print.
What's inside
Everything you need to keep your address list clean and deliverable — nothing you'll never use.
What you get
- The Excel Address Validator workbook (.xlsm)
- Written setup guide (PDF)
- Video walkthrough of a full validation run
- Free 1-on-1 Zoom call to set up your Google API key
- Email support from the builder
- Every future update to the Address Validator
Requirements
- Microsoft Excel 365 (Windows or Mac)
- A free Google Cloud account with Maps APIs enabled
- An internet connection while calculating
Ready to stop tabbing between Google Maps and Excel?
One-time · Instant download · Free setup call included
Frequently asked questions
Real answers to the questions people ask before they buy.
What exactly does “validate and fix” mean?
The tool checks each address against Google Maps and corrects formatting issues — abbreviations, capitalization, and structure — to bring it in line with USPS mailing standards.
Will it catch addresses that don't exist?
Yes — addresses that Google Maps can't resolve are flagged so you can review them, rather than shipping to a bad address.
How many addresses can I validate at once?
There's no hard limit in the tool itself — the constraint is your Google Maps API quota. Most users clean hundreds or thousands of addresses in a single pass.
Does it work on Mac?
Yes — the tool works on Excel for Windows and Excel for Mac. You just need macros enabled.
Is this a subscription?
No. One-time purchase. You own the file — no monthly fees, no renewals, no seat charges.
Can my whole team use it?
Buy the Multi-User license ($187) — everyone on your team can install and use it. Single-User ($97) is for one workstation.
What customers say
Real customers using this tool in the field. Read more on our Google Business profile.
158+ Google reviews for ExcelDistanceCalculators.com — from customers across trucking, courier, real estate, construction, and public safety.
“Our returned-mail rate was killing our per-piece costs. This tool cleaned up 40,000 records against USPS format in a single run — bad units flagged, ZIPs corrected, apartment numbers normalized. First mailing after the cleanup, our returns dropped by more than half.”
“We inherited a customer list with addresses typed six different ways by five different reps over ten years. The Validator standardized the whole thing into consistent USPS format and flagged the ones that couldn't be verified. Saved me weeks of manual review.”
“Before every donor mailing we run the file through Vinnie's Validator. It catches the typos, standardizes the format, and confirms deliverability. Our mailing house stopped charging us for undeliverables. Money and hours saved every quarter.”
You might also like
Other Excel tools our customers reach for.
