Standardise Country Codes in a CSV

How to standardise country codes in a csv

Step 1
Export the CSV with the country column — Download from your CRM, store, or order management system.
Step 2
Drop into CSV Find & Replace — Select the country column.
Step 3
Enter each variant and its replacement — Find 'United Kingdom', replace with 'GB'; find 'UK', replace with 'GB'; repeat for each variant.
Step 4
Download and use the standardised CSV — Import into your logistics API, geo-report, or database.

Can I run multiple find-and-replace pairs in one pass?+

Yes. Add as many find-and-replace pairs as you need before running the operation.

Is the match case-sensitive?+

You can choose case-sensitive or case-insensitive matching in the options.

Will this affect country codes that are already correct?+

Only cells that match the find pattern are changed. Cells that already contain 'GB' are left as-is.

Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.

Step 1
Export the CSV with the country column — Download from your CRM, store, or order management system.
Step 2
Drop into CSV Find & Replace — Select the country column.
Step 3
Enter each variant and its replacement — Find 'United Kingdom', replace with 'GB'; find 'UK', replace with 'GB'; repeat for each variant.
Step 4
Download and use the standardised CSV — Import into your logistics API, geo-report, or database.

Can I run multiple find-and-replace pairs in one pass?+

Yes. Add as many find-and-replace pairs as you need before running the operation.

Is the match case-sensitive?+

You can choose case-sensitive or case-insensitive matching in the options.

Will this affect country codes that are already correct?+

Only cells that match the find pattern are changed. Cells that already contain 'GB' are left as-is.

Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.