IBANforge

Review IBAN format and available bank references. Save your IBANforge key below; its usage report shows the effective allowance.

API key

Checking the saved key…

No key yet? Get a free one (see access options and limits).

Then, in any cell

=IBAN_VALID(A2:A200) TRUE / FALSE
=IBAN_BANK(A2:A200) resolved bank name, if available
=IBAN_BIC(A2:A200) BIC
=IBAN_CHECK(A2:A200) valid, bank, BIC, verdict, SEPA

Each IBAN sent consumes one unit, in batches of at most 100. Repeated values share a lookup within one execution. The requested six-hour cache may be evicted earlier; recalculation can consume again. French: IBAN_VALIDE, IBAN_BANQUE, IBAN_CONTROLE. German: IBAN_GUELTIG, IBAN_BANKNAME, IBAN_PRUEFUNG.

The input strings and API key are sent through Google Apps Script to api.ibanforge.com with source=sheets. Key usage is also requested. The key is stored in user properties, not in a cell.

Use a test spreadsheet you own first. Custom functions read the owner's user properties, and spreadsheet editors can edit the bound script. This is not a separate key or quota for each collaborator.

The five columns omit source dates and detailed provenance. A result is not proof of account existence, ownership or payment success.

Installation and result guide · Pricing