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

Integrations

IBAN Checker for Excel

Check a column of IBANs without leaving the workbook: whether each one is valid, why it failed, and the bank and BIC behind it. The add-in sends each IBAN to the same validation engine as this site, national check digits included, so a workbook and the IBAN checker never disagree about an IBAN.

It works in Excel for Microsoft 365 on Windows and Mac, Excel 2021 and 2024, and Excel on the web. Excel on iPad does not run add-in formulas, so the add-in is not offered there. The same add-in exists for Google Sheets.

How do I add it to Excel?

Until the add-in is listed in Microsoft Marketplace, it is added from its manifest file: download manifest.xml.

  • Excel on the web: open a workbook, choose Home > Add-ins > More Settings, then Upload My Add-in and select the file. Excel keeps it in that browser.
  • Excel for Mac: copy the file to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef (create the wef folder if it is missing) and restart Excel.
  • A whole team on Microsoft 365: an administrator uploads the same file in the Microsoft 365 admin center under Settings > Integrated apps > Add-ins > Deploy Add-in and assigns it to the people who need it. Microsoft says the button can take up to three days to appear on their ribbon.

How do I set it up?

  1. Get an API key on the API page. The free key includes 100 checks a month.
  2. In Excel open Home > IBAN Checker > Settings, paste the key and save it. It is kept in Office's storage on your device, not in the workbook.
  3. Type a formula, or select a column of IBANs and choose Home > IBAN Checker> Check selected IBANs.

Which formulas does it add?

Each formula takes a single cell or a range and returns a result of the same shape; over a range the results spill into the cells below.

FormulaReturnsExample
=IBAN.VALID(A2:A100)TRUE or FALSETRUE
=IBAN.ERROR(A2:A100)Why the IBAN failed; empty when it is validCheck digit verification failed. The IBAN contains a transcription error.
=IBAN.BANK(A2:A100)The bank's nameCommerzbank
=IBAN.BIC(A2:A100)The bank's BICCOBADEFFXXX
=IBAN.CHECK(A2:A100)Five columns: valid, error, country, bank, BICTRUE, empty, Germany, Commerzbank, COBADEFFXXX

Spaces and lower case are accepted. A cell without any digit, such as a header that reads IBAN, is skipped and not counted. One formula checks at most 300 IBANs that were not checked in the last six hours; for a longer list use Check selected IBANs.

How do I check a long list at once?

Select the IBANs and choose Home > IBAN Checker > Check selected IBANs. The results are written as plain values in the five columns to the right of the selection, with a header row when the selection sits under one, and they are not recalculated when the workbook opens again. Nothing is overwritten: if those columns already hold data, the add-in asks first and inserts five new columns instead. One run takes up to 5,000 rows.

How many requests does it use?

Each IBAN checked counts as one request on your API key, the same as a call to POST /api/v1/validate. An IBAN that appears several times in one formula or run is sent once. Results are kept for six hours on your device, so the same IBAN checked again within six hours, by another formula or a recalculation, is not counted. The free key covers 100 checks a month and the Basic plan 10,000; the other plans are on the pricing page.

Does sharing a workbook share my key?

No. The key stays in Office's storage on your device and is never written into the workbook. A colleague who recalculates the formulas needs the add-in and a key of their own.

What does the add-in have access to?

  • the workbook it is open in, to read the IBANs and write the results (Excel asks every add-in with formulas for this);
  • one address on the internet: it sends the IBANs you check to https://ibanchecker.cash/api/v1/validate.

The API validates each IBAN in memory and stores none of them. The cache on your device is keyed by a SHA-256 hash of the IBAN and holds only the result. We receive nothing from your Microsoft account: not your name, your email address, other cells or other files. The details are in the privacy policy.

What do the messages in a cell mean?

MessageWhat it means
Invalid IBANThe IBAN failed validation, so it has no bank. IBAN.ERROR says why.
Not in our bank directoryThe IBAN is valid, but the bank its code points to is not in our directory yet. The gap is ours, not an error in your data.
Monthly limit of your API key reachedYour key has used this month's requests. IBANs answered before the limit keep their results.
ibanchecker.cash could not be reachedThe request did not get an answer from the API. Results are not cached until it does; recalculate later.
#N/AThe formula could not run; select the cell and point at the error sign to read why. Most often no key is saved yet: open Home > IBAN Checker > Settings.
#SPILL!A formula over a range writes one result per row (five columns for IBAN.CHECK), and a cell in that area already holds something. Clear the area.
#BUSY!Excel is still waiting for the answer. It changes by itself.
#NAME?The add-in is not loaded in this Excel. Open the IBAN Checker group on the Home tab once, or add the add-in again.

Where is the source code, and who do I ask for help?

The add-in is open source under the MIT license: github.com/koraykoylu/ibanchecker-excel. Questions and problems go to [email protected] or through the contact page. Using it is covered by our terms of service.

Version 0.1.0. Microsoft and Excel are trademarks of the Microsoft group of companies.