Nanoscope Tools
Files processed in your session onlyNo account requiredOne-time purchasePrivacy & security →
Addresses & Locationwebapp

US Address List Cleaner

Standardize a CSV of US addresses to consistent formatting — capitalize correctly, expand abbreviations, and split into clean address components.

Use this tool — $5 per use$5 per use
Input
.csv.xlsx.tsv
Output
.csv
#address#usps#normalization#csv#mailing list#data cleaning

What it does

Upload a CSV of US addresses. Get back a normalized file with consistent capitalization, expanded abbreviations (St → Street, Apt → Apartment), and addresses split into separate fields: Street1, Street2, City, State, ZIP.

The problem it solves

Address lists collected from web forms, CRMs, or third-party data sources are inconsistent. ALL CAPS street names, lowercase cities, "Ave" mixed with "Avenue", two-letter vs full state names — all in the same file. This tool brings them to a consistent standard without an API call or manual review.

What it handles automatically

  • Capitalization — Proper case for street names, cities, and proper nouns (McArthur, O'Brien)
  • Abbreviation expansion — Standardizes St/Ave/Blvd/Dr to full or abbreviated form (your choice)
  • State normalization — Converts full state names to 2-letter USPS codes (or vice versa)
  • ZIP code formatting — Pads 4-digit ZIPs, normalises ZIP+4 format
  • Address splitting — Separates combined "123 Main St, Springfield, IL 62701" into components

FAQ

Does this validate addresses against USPS? No — this tool normalises formatting only. It does not make an API call to verify that the address exists. Use a USPS validation service for deliverability verification.

Does it handle PO Boxes? Yes. PO Box, P.O. Box, and similar variants are normalised to a consistent format.

Does it store my data? No. All processing happens in your browser.

Related tools