Validate the data in a file
A mistyped IBAN, a company number one digit short, a social security number whose key does not add up: see it before the bank or the payroll software rejects the import. Each column gets its check, suggested from its name.
What this tool does
- IBAN (mod 97 and length per country), BIC, SIREN and SIRET (Luhn, with the La Poste exception), EU VAT numbers.
- French social security numbers, Corsica included, EAN codes, emails, phone numbers, postcodes, impossible dates, required fields.
- The failing cells listed, with the reason.
- An annotated workbook: a "Check" column per row, failing cells highlighted, a sheet of issues.
What it does not do: These are form checks: a valid SIRET does not prove the company is trading, nor a valid IBAN that the account is open. Nothing is looked up online.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Column profile : Blanks, duplicates, mixed types, outliers: each column at a glance.
- Pre-import check : The format the software expects, and row by row what it will reject.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- Formula audit : Errors, hard-coded values, formulas that stand out: what to check in a model.
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.