Converting Country Abbreviations to Full Names Efficiently

·Jun 03, 2025 02:51 PM·

Ocean.io company list output provides the company COUNTRY as a 2 letter abbreviation, any ideas how to change the output to full company name or the quickest/cheapest way to convert this to the full country name?

5 comments

· Sorted by Oldest

kushagra t.
·
·
1.
add a formula column to match and output based on this list - https://www.iban.com/country-codes
2.
or run an column with 4o/4.1 mini
kushagra t.
·
·
Loading attachments
kushagra t.
·
·
here you go, you can use that formula in a new column
1.
make sure your original column is called country
2.
paste the formula in a new formula column, wait for a few seconds and save
should work.
Andy W.
·
·
ah nice thank you - was trying to avoid AI because it's wasted credits for a simple task.
Andy W.
·
·
boom worked a treat, thanks kushagra t.
🫡1

kushagra t.
·
·
1.
add a formula column to match and output based on this list - https://www.iban.com/country-codes
2.
or run an column with 4o/4.1 mini
kushagra t.
·
·
Loading attachments
kushagra t.
·
·
here you go, you can use that formula in a new column
1.
make sure your original column is called country
2.
paste the formula in a new formula column, wait for a few seconds and save
should work.
Andy W.
·
·
ah nice thank you - was trying to avoid AI because it's wasted credits for a simple task.
Andy W.
·
·
boom worked a treat, thanks kushagra t.
🫡1