Validate, standardize, and geocode U.S. addresses directly inside Google Sheets™ — no formulas required. Instantly correct address errors, format entries to USPS standards, and retrieve latitude/longitude coordinates for mapping, routing, or analytics.
Works with single cells or entire selected ranges for quick batch processing — perfect for mailing lists, deliveries, real estate mapping, and location analysis.

Key Benefits
Accurate Address Validation
Automatically detect and fix address errors so every record has the correct city, state, and ZIP code. Ideal for ensuring clean data before shipping, billing, or reporting.
Standardized USPS Formatting
Convert inconsistent or messy address entries into professional, USPS-compliant formats recognized nationwide.
Latitude & Longitude from Address
Instantly convert any U.S. address into precise geographic coordinates, ready for Google Maps, GIS tools, delivery routing, or business analytics.
Flexible Field Selection
Choose exactly which fields to output — from standardized addresses to detailed components (street name, city, ZIP, latitude, longitude) — and control their order in your sheet.
Batch Processing Made Simple
Validate, standardize, and geocode one address or an entire range at once. The add-on automatically writes results into new columns with clear headers.
Smart Feedback & Error Handling
See when an address is missing, invalid, or unmatched — with helpful error messages that make it easy to fix.

Example Use Cases
Convert addresses to GPS coordinates for mapping or geospatial analysis
Clean and prepare mailing lists for marketing or shipping
Optimize delivery routes by exporting coordinates to routing software
Real estate mapping — plot listings or analyze neighborhoods
Business territory planning using verified location data
Customer analytics — feed standardized address data into BI dashboards
CRM or database cleanup — normalize and filter by city, state, or ZIP
Event planning — map attendees to choose the ideal venue
E-commerce shipping — validate customer addresses to reduce returns

How It Works
Paste your U.S. addresses in Column A.
Open the “Address Validator” sidebar.
Select which output fields you want (e.g. matchedAddress, city, state, zip, latitude, longitude).
Click Process Addresses — results will appear automatically in new columns with headers.

Free Version Limitations:
50 validations per month