The Scenario
You're building a route-analysis dashboard and you've inherited a Google Sheet with 40 airline names in column A — no codes, no country data, just names, some of which are abbreviated or transliterated differently depending on who added the row. The dashboard needs the IATA code, ICAO code, and country of operation in columns B, C, and D before the data model is wired up. The analyst who originally set up the sheet has moved to a different project, and the name-to-code mapping they used doesn't seem to exist anywhere in the shared drive.
The bad version:
- Google each airline name to find its official IATA code, cross-referencing IATA's own site and a few travel aggregators because the names in column A don't always match the official airline name exactly.
- Repeat for the ICAO code, which lives in a different lookup entirely.
- Do this for all 40 rows and hope you didn't accidentally assign United's codes to United Express.
Forty rows sounds manageable until row 12 turns out to be a regional carrier operating under a different trade name and nothing in the first three search results confirms which IATA code is correct.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your airline names and, through its built-in APIVerve integration, it can look up the IATA code, ICAO code, and country of operation for each one and write the results into the columns you specify.
For each airline name in column A, look up the IATA code, ICAO code, and country using APIVerve and write them into columns B, C, and D
What You Get
- Column B filled with IATA codes for all 40 airlines.
- Column C filled with ICAO codes.
- Column D filled with the country of operation for each carrier.
- Airlines that APIVerve can't confidently match noted in the relevant columns so you know exactly which ones need manual review.
What If the Data Is Not Quite Ready
Airline names are abbreviated or use alternate trade names
For each airline name in column A, attempt to resolve the full official airline name and then look up the IATA code, ICAO code, and country from APIVerve — write the resolved name to column E and the codes to columns B, C, and D
You also need the radio callsign
Fetch airline details for every name in column A and add the IATA code, ICAO code, country of operation, and radio callsign to columns B, C, D, and E respectively
Some rows already have IATA codes — only fill in the gaps
For rows in column A where column B is empty, look up the IATA code using the airline name from APIVerve and fill it in; leave rows that already have a value in column B unchanged
Full resolve-enrich-flag pipeline
Standardise airline names in column A (trim whitespace, fix obvious casing), look up IATA code, ICAO code, and country from APIVerve for each row, write to columns B, C, D, and flag any rows where the match confidence is low or the airline wasn't found in column E as "Needs Review"
One prompt handles the cleanup and the enrichment — the two steps don't need to be run separately.
Try It
Get the 7-day free trial of SheetXAI and open your airline reference sheet, then ask SheetXAI to fill in the codes and country data for every carrier. You might also want to enrich airport routes with flight distances or explore the full APIVerve integration overview.