Spreadsheet-first address validation

Fix the addresses your current tool fails on.

Abbreviations. Grid coordinates. Broken spreadsheets. Upload and preview results first, then create an account only when you want to export.

Upload a Spreadsheet - Try it now Start Free Beta

Upload CSV or Excel with no column prep

Preview corrections before account creation

Export clean rows with confidence and coordinates

INLINE ADDRESS VALIDATOR

Validate any US address instantly and see exactly what changed.

No signup required

Before - After

Example transformation (when resolvable)

Input

447 FRENCH HOLW RD, HARDIN IL

Corrected output

447 FRENCH HOLLOW RD, HARDIN, IL 62047-4302

Status: CORRECTED - Confidence: 0.95

Addrex standardizes and validates messy address data, resolving to deliverable locations when sufficient data exists.

Live cleanup preview

Messy input to validated output

No signup

Live Preview

Input stays messy. Output shows final validated form.

// Input

447 FRENCH HOLW RD

HARDIN IL

Response

Match quality:Corrected (Minor)

Confidence: 95%

{
  "status": "CORRECTED",
  "standardized_address": "447 FRENCH HOLLOW RD",
  "city": "HARDIN",
  "state": "IL",
  "zip": "62047-4302",
  "lat": 39.1578,
  "lon": -90.6234,
  "confidence": 0.95
}

Representative response format from the validation pipeline.

10K+/sec

batch throughput

ZIP+4

enrichment

<50ms

API average

Proof from a real batch run

259M+ addresses checked

national reference coverage

10K+ addresses/sec batch

throughput for bulk files

3-step spreadsheet workflow

upload → review → download

No credit card to start

free account offer

123,305 addresses processed in 14s49,809 corrected automatically21,522 flagged for reviewNo column mapping required

Why teams switch from Smarty & Melissa

Built for hard address cleanup in spreadsheets first, API second.

Expands abbreviations and corrects typos

Normalizes short forms (HOLW, ST, AVE) into full USPS canonical names with ZIP+4.

Parses grid-style address inputs

Normalizes malformed directional/grid inputs into standardized, usable address output.

Auto-detects spreadsheet columns

Upload CSV or Excel and let Addrex detect your address fields automatically.

Returns what changed and why

Rows include status and confidence so teams can triage exceptions quickly.

Spreadsheet-first workflow

Upload first, clean in bulk, and download a production-ready output file.

API ready when you need it

Use the same validation engine through API for automation after spreadsheet wins.

See the difference

Hard inputs in, validated and standardized output out.

Before

447 FRENCH HOLW RD, HARDIN IL

normalized

After

447 FRENCH HOLLOW RD, HARDIN, IL 62047-4302

CORRECTED

Confidence: 0.95

Abbreviation expanded and ZIP+4 appended

Before

1473E 800 N, OWANECO IL

normalized

After

1473 E 800 N RD, OWANECO, IL 62555-2001

CORRECTED

Confidence: 0.95

Grid-style format parsed into canonical street + ZIP+4

Before

PO BOX 247, XENIA IL

normalized

After

PO BOX 247, XENIA, IL 62899-0247

PO BOX

Confidence: 0.96

PO Box preserved with validated locality and ZIP+4

Before

10945 10943

normalized

After

No deliverable address match

NOT FOUND

Confidence: 0.00

Insufficient street/city/state context

Spreadsheet workflow

Upload CSV or Excel. Addrex auto-detects columns and appends clean output fields without changing your source layout.

Step 1

Upload CSV / Excel

Drag in your source file with no schema prep.

Step 2

Addrex auto-detects columns

Street, city, state, and ZIP are detected by default.

Step 3

Preview detected mapping

Confirm mappings quickly and edit only if needed.

Step 4

Process file

Validation, standardization, correction, and confidence scoring in one pass.

Step 5

Download cleaned dataset

Original structure stays intact with clean columns appended.

Detected columns

Typical automatic mapping for uploaded files.

Street Addresscolumn C

Citycolumn D

Statecolumn E

ZIPcolumn F

Original file stays intact

Addrex appends output columns to your current spreadsheet structure.

standardized_addresslatitudelongitudeconfidencestatus

Keep your original file structure. Addrex appends standardized_address, latitude, longitude, confidence, and status to your existing spreadsheet.

Batch processing demo

Clear row-level outcomes for large files with deterministic status and confidence fields.

Batch run snapshot

Uploaded rows: 100,000

Processing customer_data.xlsx

Uploaded rows: 100,000

Processing...

Verified98,321

Corrected1,202

ZIP filled305

Not found172

98.3% complete

Throughput profile

Designed for sustained bulk cleansing.

Processes 10,000+ addresses per second.

Output includes validated, corrected, ZIP-filled, and not-found statuses so teams can resolve exceptions fast.

Batch output example

Row-level output for verified, corrected, PO box, and not-found records.

Input	Status	Corrected	Confidence	Lat	Lon
447 FRENCH HOLLOW RD HARDIN IL 62047-2402	VERIFIED	—	0.99	39.1578	-90.6234
447 FRENCH HOLW RD HARDIN IL	CORRECTED	447 FRENCH HOLLOW RD HARDIN IL 62047-4302	0.95	39.1578	-90.6234
10945 10943	NOT FOUND	—	0.00	—	—

Developer API

Predictable JSON and stable responses for production integrations.

curl / python / node

Request with RR-style input, receive normalized output.

curl -X POST https://api.addrex.io/v1/validate \
  -H "Authorization: Bearer ADDREX_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "address": "447 French Holw Rd",
    "city": "Hardin",
    "state": "IL"
  }'

API behavior

Spreadsheet-first funnel, API-ready execution.

<50ms average response time
JSON responses
consistent field names
Bearer token authentication

View API docs

Sample response

{
  "status": "CORRECTED",
  "standardized_address": "447 FRENCH HOLLOW RD",
  "city": "HARDIN",
  "state": "IL",
  "zip": "62047-4302",
  "lat": 39.1578,
  "lon": -90.6234,
  "confidence": 0.95
}

Handles messy address patterns

Examples from real upload and API payload patterns.

RR 2 BOX 305

821 KELLER RD, PERRYVILLE, AR 72126-8804

CORRECTED

1473E 800 N

1473 E 800 N RD, OWANECO, IL 62555-2001

CORRECTED

HC 61 BOX 27A

4115 COUNTY ROAD 112, CARTHAGE, TX 75633-7435

CORRECTED

PO BOX 247 XENIA IL

PO BOX 247, XENIA, IL 62899-0247

PO BOX

10945 10943

No deliverable street match

NOT FOUND

Performance metrics

Address validation and normalization metrics.

Address records

259M+

API latency

<50ms average

Batch throughput

10,000+ / sec

Service uptime

99.9%

Pricing

Plans for spreadsheet cleanup and API automation from first upload to production workflows.

Free

100 address lookups each month for first tests and small cleanup jobs.

Free