USA Address Validator + Geocoder

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

1. Paste your U.S. addresses in Column A.

2. Open the “Address Validator” sidebar.

3. Select which output fields you want (e.g. matchedAddress, city, state, zip, latitude, longitude).

4. Click Process Addresses — results will appear automatically in new columns with headers.

Free Version Limitations:

• 50 validations per month

* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas

USA Address Validator + Geocoder use and transfer of information received from Google APIs to any other app will adhere to Workspace API User Data and Developer Policy, including the Limited use of user data.