Spreadsheet-first address validation

Fix the addresses your current tool fails on.

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

Preview is open without signup. Account creation is only required at download/export. No credit card required.

Inline validator

No signup required

Before → After

Example transformation (when resolvable)

Input

RR 2 BOX 65, HARDIN IL

Resolved output

447 FRENCH HOLLOW RD, HARDIN, IL 62047-2402

Status: VERIFIED · Confidence: 0.98

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

Live Preview

Input stays messy. Output shows final validated form.

// Input

RR 2 BOX 65

HARDIN IL

Response

Match quality:Corrected (Major)
Confidence: 98%
{
  "status": "VERIFIED",
  "standardized_address": "447 FRENCH HOLLOW RD",
  "city": "HARDIN",
  "state": "IL",
  "zip": "62047-2402",
  "lat": 39.1578,
  "lon": -90.6234,
  "confidence": 0.98
}

Representative response format from the validation pipeline.

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.

Handles rural routes (RR, HC, HCR)

Cleans and validates complex route-style inputs, resolving them when sufficient data exists.

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

RR 2 BOX 65, HARDIN IL

normalized

After

447 FRENCH HOLLOW RD, HARDIN, IL 62047-2402

VERIFIED

Confidence: 0.98

Resolved to a deliverable location where sufficient reference data exists

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.

InputStatusCorrectedConfidenceLatLon
447 FRENCH HOLLOW RD HARDIN IL 62047-2402VERIFIED0.9939.1578-90.6234
RR 2 BOX 65 HARDIN ILCORRECTED447 FRENCH HOLLOW RD HARDIN IL 62047-24020.9839.1578-90.6234
10945 10943NOT FOUND0.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 YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "address": "RR 2 BOX 65",
    "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": "VALIDATED",
  "standardized_address": "447 FRENCH HOLLOW RD",
  "city": "HARDIN",
  "state": "IL",
  "zip": "62047-2402",
  "lat": 39.1578,
  "lon": -90.6234,
  "confidence": 0.98
}

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.

Starter
Best for first spreadsheet cleanup with plan-based included usage.

Free

Upload Spreadsheet + Batch + API

Auto column detection + cleaned output columns

Growth
For recurring batch jobs and API automation in production workflows.

$49/mo

Upload Spreadsheet + Batch + API

Auto column detection + cleaned output columns

Enterprise
For high-volume pipelines, SLAs, and dedicated support.

Custom

Upload Spreadsheet + Batch + API

Auto column detection + cleaned output columns

Clean your address data in minutes, not days.

Use one workflow for spreadsheets and one API for production systems.

Included usage depends on your plan. Additional records can be processed pay-as-you-go, and we'll ask before charging overages.