Validate IBANs in Excel
Power Query starter workbook · no VBA macros
https://www.iban-test.eu/guides/iban-validation-excel

1. Enter your API token
On the Settings sheet, replace YOUR_API_TOKEN with your own IBAN-Test API token. The token is saved in this file.

2. Prepare your list
On the Input sheet, replace the sample rows. Keep Reference, IBAN and both table names unchanged. Store IBANs as text.

3. Add the query once
Excel for Windows: Data > Get Data > From Other Sources > Blank Query. In Advanced Editor, replace all code with the contents of iban-validation.pq.

4. Configure access
Choose Anonymous for https://www.iban-test.eu. The code sends your token in the Authorization header. Set suitable privacy levels for the workbook and API.

5. Load results
Name the query IBAN_Results. Close & Load to a new worksheet. Do not overwrite the input table.

6. Refresh later
Edit your input list and choose Data > Refresh All. Check your quota before each run. Editor previews can also send requests.

Read the results
VALID: API code 2100. INVALID: code 3100, 3101 or 3102. MISSING: empty input, no request. Token, quota or connection errors stop the refresh.

If refresh fails
Excel may retain old results. These are not current after a failed refresh. Check CheckedAtUTC and query status.

Example limit
At most 10 distinct non-empty IBANs per evaluation. Increase MaxUniqueIbans in the code only after checking your quota. HTTP calls per click are not guaranteed.

Sharing results
Copy result values to a new file before sharing. This workbook can contain your API token, inputs, queries and cached results.

Validation scope
Formal validity and available bank details. No proof of account ownership, existence, balance or payment success.

Template status
21 September 2026 · Version 1.0 · XLSX structure and M syntax checked; not fully tested in Microsoft Excel. Add the query manually once.
