Free - No signup - Your mailing list stays in your browser

Validate a mailing address CSV.

Map address columns, normalize countries, postal codes, US states and Canadian provinces, flag PO boxes and duplicates, then export a clean list and a flagged list.

A CSV address validator checks that every row in a mailing list is well formed: required address parts are present, the country resolves to an ISO 3166-1 code, and postal codes, US states, and Canadian provinces follow their published formats. This private workspace never geocodes or queries a postal database, so well-formed does not mean deliverable.

01 - How it works

Turn a messy address sheet into a checked mailing list.

Every column gets an explicit address role. The complete file is checked locally before the clean list can be downloaded.

i. load

Open CSV or Excel

Drop a CSV, TSV, or one Excel sheet, paste rows, or try the imperfect and ready samples.

ii. map

Confirm address roles

Recipient, organisation, line 1, line 2, city, region, postal code, country, or Ignore, suggested from headers only.

iii. export

Download two lists

Acknowledge the deliverability boundary, then download the clean list, the flagged list, and a counts-only report.

02 - What it checks

Format evidence before postage.

The desk checks what a file can prove and leaves deliverability to the services that can verify it.

  • 01

    Countries

    Common names, alpha-3, and alpha-2 codes normalize to ISO 3166-1 alpha-2; ambiguous names are flagged.

  • 02

    Postal codes

    ZIP and ZIP+4, Canadian ANA NAN, UK postcodes, Eircode, and nine more national patterns, with canonical spacing.

  • 03

    States and provinces

    USPS two-letter state and territory codes and Canada Post province symbols, with full names converted.

  • 04

    Duplicates and boxes

    Exact duplicates are held back, near duplicates and PO Box or PMB lines are flagged for review.

"A well-formed address is not a verified deliverable address."
csvtodashboard.com
Scope and handoff

Know what a format check cannot see.

The validator never geocodes, never calls an address API, and never claims a postal database match.

  • No CASS or database match

    CASS, SERP, AMAS, and geocoding need licensed postal data. Use a certified service when your mail class requires it.

  • No cross-field match

    A valid ZIP Code and a valid state code are checked separately; whether they belong together is not checked.

  • Source-order outputs

    The clean list keeps every original column and row order and appends normalized address columns.

03 - FAQ

Address CSV questions.

Does this CSV address validator check that an address is deliverable?
No. It checks that each row is well formed: required parts are present, the country resolves to an ISO 3166-1 code, and the postal code matches the country's published pattern. It does not run CASS, SERP, AMAS, geocoding, or any postal database lookup, so a well-formed address can still be undeliverable.
No. Parsing, mapping, checks, masked findings, and downloads all run in the current browser tab. No name, street, postal code, or finding is sent to a postal service, geocoder, or csvtodashboard.
United States ZIP and ZIP+4, Canada, United Kingdom, Australia, Germany, France, Netherlands, India, Japan, Ireland (Eircode), New Zealand, Spain, and Italy. Other countries keep their postal code unchanged and unchecked.
No. Matching a state, city, or province to a postal code needs a postal database. The tool only checks the format of each part separately.
Common English names, ISO 3166-1 alpha-3 codes, and alpha-2 codes become the alpha-2 code, such as United States, USA, and US becoming US. Names that can mean more than one country, such as Korea or Georgia, are flagged for review instead of guessed.
Rows that are identical after normalization are held out of the clean list and listed in the flagged list. Rows that share address line 1 and postal code but differ elsewhere are flagged for review and kept.