The column profile of a file
Before analysing an unfamiliar file, look at what it really holds: how many blanks, distinct values, numbers stored as text, values out of the ordinary. One card per column, and a report to keep.
What this tool does
- Filled and empty cells, distinct and repeated values, and the columns that could serve as an identifier.
- Mixed types and numbers stored as text, stray spaces.
- Minimum, maximum, mean and median; outliers by Tukey's rule.
- The most frequent values, the period covered by dates.
What it does not do: An "outlier" is out of the ordinary, not necessarily wrong: a large customer is still a customer. The profile reads the whole file into memory.
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.
- 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.