USA Address Validator & Geocoder

Validate US addresses in bulk & add lat/long — free, keyless Census geocoder

Validate and standardize a whole column of US addresses in bulk — and get
latitude, longitude, and a TRUE/FALSE valid flag for each. One click instead of
pasting addresses into a website one at a time.

WHAT IT DOES
• Point it at an address column and four output columns — every non-empty
  address gets a standardized address, latitude, longitude, and a TRUE/FALSE
  valid flag in its matching row.
• Free, keyless geocoding powered by the U.S. Census Geocoder — no API key, no
  signup, no billing account.
• Returns both the cleaned/matched address AND coordinates, not just one.
• Graceful per-row errors: an address that can't be matched is flagged FALSE and
  the batch keeps running — one bad row never aborts the job.

GREAT FOR
• Cleaning CRM, shipping, and mailing lists.
• Adding map coordinates for routing or analysis.
• Deduping and standardising address data at scale.

FREE & PRO
• Free: 50 validations/month, no card required.
• Pro: unlimited validation. 14-day full trial.

Coverage note: the U.S. Census Geocoder covers United States addresses only;
non-US or unrecognised addresses are simply flagged FALSE — the trade-off for a
completely free, keyless geocoder.

Privacy-first: the add-on only touches your active spreadsheet — nothing else in
your Drive. Minimal scopes, fast support.