IBAN Checker for Google Sheets: Install It and Check a Column of IBANs
The IBAN Checker add-on is on the Google Workspace Marketplace. How to install it, add a key, check a column and use the five IBAN formulas.
Founder, ibanchecker.cash
I'm Koray, the founder of ibanchecker.cash. Our add-on for Google Sheets™ is now listed on the Google Workspace Marketplace, after Google verified how it uses your account and reviewed the listing. It checks a column of IBANs where finance teams already keep them: whether each one is valid, why it failed, its country, its bank and the bank's BIC. This post shows how to install it and use it, step by step, and what it does with the data in your sheet.
What Does the IBAN Checker Add-on Do in Google Sheets?
It sends each IBAN in a cell or range to the same validation engine as this website, national check digits included, and writes the answer back into the sheet. A spreadsheet and the IBAN checker on this site therefore never disagree about an IBAN, across all 92 countries we support. You can use it two ways: as formulas that stay live, or as a menu command that checks a selected column once and writes plain values next to it. The whole flow takes under a minute; here it is in 44 seconds.
How Do I Install IBAN Checker in Google Sheets?
- Open the IBAN Checker listing on the Google Workspace Marketplace and click Install.
- Choose the Google account you use for Sheets and review the permissions.
- Click Continue. Google confirms the add-on is installed.
The add-on asks for three permissions, each for a specific reason:
- View and manage spreadsheets that this application has been installed in: to read the cells you pass to a formula or select, and to write the results next to them. It cannot open your other files.
- Connect to an external service: to send those values to the ibanchecker.cash API.
- Display and run third-party web content in prompts and sidebars: for the settings sidebar where you paste your API key.
How Do I Add My API Key?
The add-on needs an ibanchecker.cash API key. A free key is available on the API page and includes 100 checks a month; paid plans raise the limit. In any spreadsheet open Extensions > IBAN Checker by ibanchecker.cash > Settings and API key, paste the key and click Save key. The key is stored in your own Google account, not in the spreadsheet, so people you share a sheet with never see it. The field masks the key as you paste it.
How Do I Check a Whole Column of IBANs at Once?
Select the IBANs, then choose Extensions > IBAN Checker by ibanchecker.cash > Check selected IBANs. The add-on writes five columns next to the selection: Valid, Error, Country, Bank and BIC. These are plain values, so they are not recalculated when the sheet changes, which suits a supplier list you check once before a payment run. Nothing is overwritten: if the columns next to your selection already hold data, the add-on asks first and inserts new columns instead.
For one-off lists without a spreadsheet, the bulk IBAN checker on this site does the same in the browser.
Which IBAN Formulas Can I Use in Google Sheets?
Each formula takes a single cell or a range and returns a result of the same shape, so one formula at the top of a column covers the whole list:
=IBAN_VALID(A2:A100)gives TRUE or FALSE.=IBAN_ERROR(A2:A100)gives the reason an IBAN failed, and stays empty for a valid one.=IBAN_BANK(A2:A100)gives the bank's name.=IBAN_BIC(A2:A100)gives the bank's BIC.=IBAN_CHECK(A2:A100)gives all five columns at once: valid, error, country, bank, BIC.
How Many API Requests Does the Add-on Use?
Each IBAN counts as one request on your key, the same as a call to the API. Results are kept for six hours in the add-on's own storage in your Google account, so a recalculation or the same IBAN checked again within six hours is not counted twice. The message after Check selected IBANs tells you how many were checked, how many came from that six-hour store and how many requests are left on your key this month.
What Happens to the IBANs in My Spreadsheet?
The add-on reads only the cells you pass to a formula or select, and sends those values to the ibanchecker.cash API, which validates them in memory and stores none of them. We receive nothing else from your account. The details are in the Google Sheets section of our privacy policy, and the source code is public under the MIT license on GitHub. A valid result tells you an IBAN is correctly formed and which bank it belongs to; it does not confirm that the account exists or who holds it.
Why Does a Formula Show #NAME? or the Sidebar Ask for Authorization?
- #NAME?in a spreadsheet where you have not used the add-on yet: open its menu once (Extensions > IBAN Checker by ibanchecker.cash) and the formulas load.
- “Authorization is required” in the sidebar: the browser is signed in to several Google accounts and the spreadsheet is open in one that is not the first. Open it in a window signed in only to the account that installed the add-on.
Every message the add-on writes into a cell is explained on the Google Sheets help page.
Sources & References
- Google Docs Editors Help: Use add-ons, Apps Script, AppSheet and Data Studio
- Google for Developers: Google Workspace add-on types
- Google for Developers: Custom functions in Google Sheets
- Google for Developers: Apps Script Properties Service, where the key is stored
- ISO 13616-1:2020: IBAN structure
- SWIFT IBAN Registry: official country formats
Google Sheets is a trademark of Google LLC.
Last updated: November 2026
Integrate IBAN validation via API
REST API with 100 free validations a month. JSON response with bank name, SEPA status, and BBAN breakdown.
Introducing Northern Cyprus UBAN Support: Validator and Bank Directory
A validator for the 28-character Northern Cyprus UBAN, plus a directory of all 23 registered banks. What UBAN is, and wh...
One Client, Four Registries: PyPI, npm, Packagist and MCP All Disagree
Why OIDC cannot do npm's first publish, why Packagist needs no workflow, and the PyPI name check that returns 200 for na...
npm trust github Fails with 400 Bad Request: The Missing Permission Flag
A bare 400 with no error body, caused by a 20 May 2026 registry rule. The exact npm version boundary, the one flag that ...
How to Validate IBANs in JavaScript (API & Manual)
Two approaches: call the ibanchecker.cash API for full bank data, or implement MOD-97 validation yourself. Includes work...