IBAN Checker for Google Sheets™ is now on the Google Workspace Marketplace. How to use itGoogle Sheets™ add-on is live →

Developer ResourcesNovember 17, 2026 · 6 min read

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.

Koray Köylü
Koray Köylü

Founder, ibanchecker.cash

google-sheetsadd-onbulk-validationaccounts-payableintegrations
Share

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.

Install from the Marketplace, save a key, run Check selected IBANs, then the IBAN_VALID formula. The recording has no sound.

How Do I Install IBAN Checker in Google Sheets?

  1. Open the IBAN Checker listing on the Google Workspace Marketplace and click Install.
  2. Choose the Google account you use for Sheets and review the permissions.
  3. Click Continue. Google confirms the add-on is installed.
The listing on the Google Workspace Marketplace.

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.
The three permissions, as Google shows them.
After installing, the add-on lives under Extensions in every spreadsheet.

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.

The settings sidebar. The key is masked and saved to your Google account.

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.

Seven supplier IBANs selected, and the menu command.
The results. The last IBAN has one wrong digit, so it fails the check digit test and gets no bank.

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.
One formula in H2 fills the whole column.

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 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.