Home › Dev & Data › CSV Column Summary
Dev & Data
CSV Column Summary
A fast look at what is actually in a CSV before you use it: how many rows, which columns have blanks, how many distinct values each holds, and min/median/mean/max/sum for the numeric ones. The check that catches a broken export before it becomes a broken report.
Try it now
Worked example
4 column(s), 5 row(s)
region
filled 5 / 5 blank 0 distinct 3
rep
filled 5 / 5 blank 0 distinct 4
units
filled 5 / 5 blank 0 distinct 4
numeric: min 60.0000 median 90.0000 mean 102.0000 max 150.0000 sum 510.0000
revenue
filled 5 / 5 blank 0 distinct 4
numeric: min 7200.0000 median 10800.0000 mean 12240.0000 max 18000.0000 sum 61200.0000
Counts and statistics only — nothing here is uploaded or stored.
Learn the method
Frequently asked
Why does it skip statistics on some columns?
It only reports number statistics when most of the filled values in a column actually parse as numbers. Averaging a column of postcodes would be worse than saying nothing.
Does it change my data?
No. It reads and counts; there is no output file and nothing is uploaded.