Country normalization
How Operelio turns inconsistent country values like UK, GB, Great Britain and england into one canonical CRM-ready name, across more than 80 countries.
By Operelio team · Updated October 13, 2026
On this page4
What country normalization does
To standardize country names before a CRM import, turn on Standardize country in the CRM Formatter's Review step, if it isn't already on: it maps abbreviations, ISO codes, local-language names and common misspellings to one name for more than 80 countries, so UK, GB, Great Britain and england all become United Kingdom. Values already in that form, like Japan or Canada, pass through unchanged.
CRMs often reject all but one form of a country name, so a column that mixes them fails rows on import.
What it covers
Covers more than 80 countries with their abbreviations, ISO codes, and common misspellings. ISO 2-letter codes (GB, US, DE), ISO 3-letter codes (GBR), country sub-names treated as the country (England, Scotland, Wales, Northern Ireland all resolve to United Kingdom), local-language names (Deutschland, España, Brasil, Italia), and common misspellings (Phillipines, Bangledesh, Sweeden).
Matching is case-insensitive. "usa", "USA", "Usa", and "United States of America" all resolve to "United States". Canonical names that are already correct (like "Japan" or "Canada") pass through unchanged.
When to enable it
The Standardize country toggle is off by default to avoid surprising you with unexpected changes. Turn it on when your source data has a country column with inconsistent values. The live preview on the Review step shows exactly what each row will become before you export.
Country normalization runs only on columns whose name contains "country" (case-insensitive). If you map a Region column to the Country field, normalization is skipped.
If a value is not recognized (a typo Operelio has not seen, a region that is not a country, or a multi-country entry like "UK & Ireland"), it is returned as-is, trimmed. No guesswork; unrecognized values stay visible so you can spot and fix them.
Country normalization is on every plan.
Turn inconsistent country values into the canonical names your CRM expects.
Frequently asked questions
Which countries are covered?
More than 80 countries spanning Europe, North America, South America, Asia-Pacific, Middle East, and Africa. The emphasis is on countries that appear most often in B2B CRM data; country list grows based on customer requests.
Can I add my own country mappings?
Not from the UI yet. If a specific abbreviation or misspelling is missing for your data, let us know and we will add it to the built-in map.
Does it touch rows where the country is already canonical?
No. If a value already matches a canonical country name (case-insensitive), it passes through with its canonical casing applied. "united states" becomes "United States" but is otherwise unchanged.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.