Turn IATA into ICAO by the row. =VERVE("airportcodeconverter", A2) returns the matching code plus airport name and city — Sheets or Excel.
It's one of 300+ live sources you reach with a single =VERVE()function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — these inputs, and the values they land in your sheet.
Fill =VERVE("airportcodeconverter", A2) down a column and Convert Airport Codes returns a result for every row — a batch of live values in a single drag, no code.
Add Convert Airport Codes beside a table you already have to append its output right where your data lives, then sort, filter, or chart on it.
Set the sheet to refresh on a schedule and the convert airport codes values keep themselves current without anyone re-typing.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("airportcodeconverter", A2)Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("airportcodeconverter", A2)Add a field name as the last argument to land just that value in the cell.
=VERVE("airportcodeconverter", A2, "input")=VERVE("airportcodeconverter", A2, "inputType")=VERVE("airportcodeconverter", A2, "iata")=VERVE("airportcodeconverter", A2, "icao")=VERVE("airportcodeconverter", A2, "name")=VERVE("airportcodeconverter", A2, "city")=VERVE("airportcodeconverter", A2, "state")=VERVE("airportcodeconverter", A2, "country")Everything you need to wire it into a sheet.
