Turn messy spreadsheets into clean, validated address data.
Upload a CSV or Excel file. Addrex standardizes each address, validates against our national reference dataset, adds coordinates, and returns a downloadable file with match codes and reason codes.
No setup required. Upload and run immediately.
Same engine as our real-time API. No special batch rules.
No DPV claims. Reference-validated against our national dataset.
How it works
Three steps from messy spreadsheet to clean, geocoded data.
What you get
Every processed file includes these columns appended to your original data.
standardized_line1Standardized street address line 1standardized_line2Standardized street address line 2 (if applicable)standardized_cityStandardized city namestandardized_stateTwo-letter state codezip55-digit ZIP codezip4ZIP+4 extension (if available)validation_statusVERIFIED, VERIFIED_WITH_CORRECTIONS, NOT_IN_REFERENCE, INVALID_INPUTmatch_codeEXACT, STANDARDIZED, CORRECTED_MINOR, CORRECTED_MAJOR, PARTIAL_MATCH, AMBIGUOUS, NO_MATCH, UNPARSEABLEconfidenceMatch confidence score (0.00–1.00)reason_codesSemicolon-separated list of reason codeschangesWhat was modified from the original inputlatLatitude coordinatelonLongitude coordinategeocode_qualityROOFTOP, INTERPOLATED, ZIP5_CENTROID, CITY_CENTROIDcandidate_countNumber of candidate matches considered (optional)Before & after
See how messy input becomes clean, validated, geocoded output.
| Input Address | Status | Match | Confidence | Lat | Lon |
|---|---|---|---|---|---|
| 1600 penn ave, washinton dc | VERIFIED | CORRECTED_MINOR | 0.94 | 38.8977 | -77.0365 |
| 350 5th Ave, New York, NY 10118 | VERIFIED | EXACT | 0.99 | 40.7484 | -73.9857 |
| 123 fake street nowhere xx | NOT_IN_REFERENCE | NO_MATCH | 0.00 | — | — |
Extract addresses from messy text
NewPaste free-form text (emails, notes, claims narratives). Addrex detects one or more addresses, normalizes and validates each, and returns standardized results with match + reason codes.
Example Input
"Send docs to 123 N Main St, Austin TX or warehouse at 456 Elm Rd, Round Rock."
Result
2 addresses found
1. 123 N Main St, Austin, TX 78701 — VERIFIED
2. 456 Elm Rd, Round Rock, TX 78664 — VERIFIED
Built for data teams
Common use cases for bulk address processing.
CRM cleanup
Standardize addresses before a migration or integration.
Marketing lists
Validate mailing lists to reduce bounce rates and waste.
Underwriting & claims
Normalize address data for insurance and risk workflows.
Vendor master data
Clean supplier and partner records for matching.
Shipping & delivery
Ensure accurate addresses before fulfillment.
Territory mapping
Add coordinates for routing, analysis, and visualization.
Security & data retention
TLS in transit
All data encrypted during transfer.
Redacted logging
PII is excluded from logs by default.
Configurable retention
Short retention or immediate deletion available.
Reference validation
No DPV/CASS claims—validated against our dataset.