Your files stay on your device

Spreadsheet column profiler

Profile every column of an XLSX or CSV: inferred types, blanks, distinct counts, top values, quartiles, Tukey outliers, date ranges, and import warnings.

The profiler reads your file the way an importer would: it classifies each cell, counts blanks and distinct trimmed values, and computes mean, median, and standard deviation over the numbers, where the standard deviation divides by n (population). Quartiles use linear interpolation, the same rule as Excel's QUARTILE.INC, and a value outside the Tukey fences (Q1 or Q3 plus or minus 1.5 x IQR) counts as an outlier. Workbook formulas show the results Excel last saved; nothing is recalculated. Dates in a workbook come from its number formats, and slash dates in CSV read US-style month first. A column of consistent nonsense still passes: these checks look at shape, not truth.
Options

More PDF & file tools

- Excel sheets (XLSX) (/files/xlsx)
- CSV studio (/config/csv)
- ZIP files (/files/zip)
All PDF & file tools (/files)

Was this tool useful?
YesNo

Canonical HTML: https://nutter.tools/files/spreadsheet-column-profiler
Markdown version: https://nutter.tools/files/spreadsheet-column-profiler.md
Plain-text version: https://nutter.tools/files/spreadsheet-column-profiler.txt
Agent index: https://nutter.tools/llms.txt