Country name normalizer: USA, U.S. and United States of America to one country
In short: Rewrites every spelling of a country (USA, U.S., America, Deutschland, Holland, UK, England) as one form: the English name, the ISO 3166-1 two-letter code or the three-letter code. Reads locations like "Austin, TX, United States" or "Toronto, ON" from the last part, and flags rows it can't read. Limit: Free-text locations are read from their last part; a location like "Paris" with no country stays not recognised.
Paste your countries, or a CSV with a country or location column, pick names, ISO 2-letter or ISO 3-letter codes, and press Normalise. USA, U.S. and United States of America become one value, local names like Deutschland and Holland are read, "San Francisco, CA" gives the United States, and placeholders like Remote are left blank.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Mailchimp and most CRMs import two-letter codes (GB, not UK); a first line reads better with the name.
Sample result
8 rows read: 4 United States, 2 United Kingdom, 1 Germany and 1 placeholder left blank.
- Countries
- 7 converted
- Output
- Names + ISO 2 code
- Not recognised
- 0
What this means for you
USA, U.S. and America are one country now, so segments and imports add up.
- USA, U.S., America unified
- Names or ISO 2/3-letter codes
- City, state locations read
- Remote and n/a left blank
- Countries
- ISO codes
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Also in: Português (Brasil) · Español
How do I check the addresses before I import the list?
- Download the cleaned CSV here; every original column is kept.
- Upload it at /verify. Every address gets a live mailbox check, and valid, risky and invalid download as separate files. The first 100 email checks are free with a Google sign-in, no card.
- Import or segment the valid file by country_clean.
How do I standardise country names in a CSV?
- Export the list with its country or location column (Apollo has Country, Sales Navigator and LinkedIn have Location).
- Paste it here or upload the CSV and choose the output: names for copy, two-letter codes for Mailchimp and most CRM imports.
- Press Normalise countries and look over the rows marked not recognised.
- Download the CSV: country_clean holds the chosen form and country_code the two-letter code.
Example
- You enter
- 8 rows with a country column:
USA,U.S.,United States of America,uk,England,Deutschland,Austin, TXandRemote, output as names. - You get
- 7 converted: four rows become United States (Austin, TX read from the state), two become United Kingdom (England noted as part of it) and one Germany;
Remoteis left blank. Each row gets country_clean, country_code, country_status and country_note. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
Why does a country column need cleaning?
Because one list can spell the same country a dozen ways, and every tool downstream treats each spelling as a different country. A segment for United States misses USA, U.S. and America; a send-time rule by country skips half the rows; an import into a tool that wants codes fails or drops the field. Mailchimp's import guidelines ask for two-letter codes, GB and not UK.
Lead databases and forms mix free-text locations ("Greater London, England, United Kingdom"), local names (Deutschland, España), old names (Swaziland, Burma) and placeholders (Remote, Global). This turns each into the country, or says it couldn't.
How are locations and odd values read?
A value that is a country name, ISO code or a known spelling is converted directly. A location with commas is read from its last part: "Austin, Texas, United States" gives the United States, and a last part that is a US state, Canadian province or Australian state ("San Francisco, CA", "Toronto, ON", "Sydney NSW") gives that country. England, Scotland, Wales and Northern Ireland become the United Kingdom with a note.
Flagged for a look: Georgia (a country and a US state), shared state codes like WA (Washington or Western Australia), and a lone state name in a country column. Remote, Global, n/a and similar become blank. Anything else is kept as written and marked not recognised.
Who uses this tool, and for what?
- Cold emailers
- Clean an Apollo or Sales Navigator location column before segmenting campaigns by country or time zone.
- Email marketers
- Convert country names to the two-letter codes Mailchimp and Klaviyo imports expect.
- RevOps
- Collapse USA, U.S. and United States into one value so territory reports and routing rules add up.
- Compliance teams
- Find the UK and EU contacts in a list before a send that needs GDPR consent records.
What can’t this tool tell you?
- Free-text locations are read from their last part; a location like "Paris" with no country stays not recognised.
- It doesn't look up cities, so "Springfield" alone can't be placed.
- A country column says where a contact or company is listed, not where the person is today.
- It can't tell whether the email addresses on the list exist.
Common questions
- How do I convert country names to ISO codes in Excel?
- With a two-column lookup table of every name and code and a VLOOKUP, which breaks on each spelling the table doesn't have. Paste the column here, choose ISO 2-letter codes and download country_clean.
- Which country names does it use?
- Short English names in common use (United States, United Kingdom, South Korea, Czechia, Türkiye) for all 249 ISO 3166-1 countries and territories. The codes are the ISO 3166-1 alpha-2 and alpha-3 codes.
- Can it tell a contact's country from their email address?
- Not here. A .de or .co.uk domain hints at a country but many companies use .com; the email list by country tool sorts by domain ending if that's what you need.
- Is my list uploaded?
- No. It is read in your browser and nothing is sent anywhere.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.