Country normalization
How Operelio turns inconsistent country values (UK, GB, Great Britain, england) into canonical CRM-ready names.
By Operelio team
On this page4
What country normalization does
Country fields in CRM imports are notoriously inconsistent. One row says "UK", another says "GB", a third says "Great Britain", a fourth says "england" in lowercase. CRMs often reject all but one canonical form. Operelio's country standardization turns all of those into "United Kingdom" so every row imports without errors.
What it covers
Covers 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.
Frequently asked questions
Which countries are covered?
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.