Check a file before importing it
The import into payroll, the ERP or the CRM stops at row 4,212 with an unreadable message. Here you describe what the software expects, and every row it will reject is listed before the import, with the reason.
What this tool does
- The format inferred from a template file, or from the file itself, then corrected on screen.
- Per column: the type, required or not, the maximum length, the allowed values, uniqueness, and a format check (IBAN, email…).
- Missing, extra or out-of-order columns, matched by name.
- The format is saved in a small file, to drop again with next week's file.
What it does not do: The check covers what can be seen in the file: it does not know that a customer code must exist in the software. To check one list against another, look up the two files.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Validate data : IBAN, VAT, EAN, emails, dates: every value checked against its check digits.
- Column profile : Blanks, duplicates, mixed types, outliers: each column at a glance.
- 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.