The Scenario
You're a developer three days into building a payments dashboard for a fintech client. The dropdown that lets users select a currency needs full currency names and country labels — not just ISO codes. You have an Excel workbook with 80 ISO codes that the backend team assembled from payment logs. Someone handed it off to you this morning with a note that said "can you make this usable?" and then left for a flight.
The ISO codes are there. EUR, GBP, NGN, IDR, PKR, KES, and 74 others. What's missing is everything a human actually needs to read a dropdown: "Euro," "British Pound Sterling," "Nigerian Naira," the issuing country for each. You could look these up in a Wikipedia table. You could hard-code a lookup object in the app. You could spend two hours cross-referencing the ISO 4217 standard.
The bad version:
- Open a Wikipedia page for the ISO 4217 currency list, scan for each of your 80 codes, copy the full name, paste it into column B of the workbook, row by row.
- Realize around row 30 that you've been copying "United States of America" for USD when the client's design specs want "United States."
- Go back, fix the formatting, then notice the crypto codes you included (BTC, ETH) aren't in the ISO 4217 table at all, so you need a second lookup source for those.
The cognitive overhead of switching between three lookup sources for 80 rows is exactly the kind of thing that turns a 20-minute task into the thing you're still finishing at 7 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your ISO codes and, through its CurrencyScoop integration, can pull the full currency metadata — name, issuing country — for every code in your list and write it directly into the workbook.
For each currency code in column A, use CurrencyScoop to look up the full currency name and country and write them into columns B and C
What You Get
- Column B fills with the full currency name for each code (e.g., "Euro," "British Pound Sterling," "Nigerian Naira").
- Column C fills with the issuing country or region for each code.
- Codes that CurrencyScoop doesn't recognize (misspelled, non-standard, or unsupported) get a note in column B rather than a silent blank.
- The original codes in column A are unchanged.
What If the Data Is Not Quite Ready
The codes have inconsistent casing or whitespace
Uppercase and trim each code in column A, then use CurrencyScoop to look up the full name and country for each and write them into columns B and C
You also want a "symbol" column for display in the UI
For each currency code in column A, use CurrencyScoop to look up the full name, country, and symbol, and write them into columns B, C, and D respectively
Some codes are crypto and need to be flagged separately
For each code in column A, use CurrencyScoop to look up the full name and country — if the lookup succeeds, write name into column B and country into column C; if the code is a cryptocurrency, write the name into column B and "Crypto" into column C; if unrecognized, write "Unknown" into column B
Full reference build: pull the complete CurrencyScoop currency list rather than enriching existing codes
Pull the complete list of supported currencies from CurrencyScoop into a new worksheet called Currency Reference, with columns for code, full name, and country — sort by code alphabetically
When you're building the reference from scratch rather than enriching existing codes, ask for the full pull in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of ISO currency codes, then ask it to expand the list into a full reference table using CurrencyScoop. For live conversion use cases, see bulk convert invoice currencies. The hub overview is at How to Connect CurrencyScoop to Excel.