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
IBAN validation integration guides
Validate customer input, check an exported list or connect an automation. Choose a downloadable starter for your workflow and follow it through to your first API check.
Choose your integration
- PHP form — Validate customer input on your server.
- CSV with Python — Check exported IBAN lists and write a result CSV.
- Google Sheets — Check selected spreadsheet rows without changing the input.
- n8n workflow — Route validation results into your automation.
New to the API? See what IBAN validation returns, then create a free API account. Start with 10 free requests every 24 hours.
All 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.