Validate IBANs in Excel with Power Query
Validate an IBAN list in Excel for Microsoft 365 on Windows using Power Query and the IBAN-Test API. Includes an XLSX starter workbook, query code and guidance on API tokens, quota and error handling.
Put IBAN-Test to work
Guides
Add IBAN validation to your workflow with step-by-step instructions, example code and downloadable starter templates.
Looking for reference information? Visit the API documentation, frequently asked questions or online IBAN checker.
Available guides
Validate IBANs in Google Sheets with Apps Script
Validate a selected IBAN column from a Google Sheets menu. Includes an Apps Script starter, setup steps, per-user token storage and a separate results report.
Validate IBANs in n8n: Downloadable Workflow
Download a manual n8n starter with credential setup, sequential IBAN checks, result branches and clear failure handling.
Validate IBANs in a CSV file with Python
Check an exported IBAN list with a Python script and write validation results, bank names and BICs to a new CSV. Includes sample input and offline tests.
Validate an IBAN in a PHP Form
Add IBAN validation to a PHP form while keeping your API token on the server. Includes runnable code and offline tests.
Check a bank's SEPA participation with the IBAN-Test API
Read a bank's separate SEPA Core, B2B, credit-transfer and instant-transfer participation results. Includes a response interpreter and offline examples.