Column Statistics
Profiles each column with count, nulls, unique values, min, max, mean, median and distribution.
A one-screen profile of every column: how many cells are filled, how many are empty, how many distinct values there are, and for the numeric ones the min, max, mean, median, quartiles and standard deviation. It is the first thing to run on a file you have not seen before.
Drop a CSV or TSV
Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.
How to use it
Drop the file
The whole profile is computed at once; there is nothing to configure.
Look at the empty counts first
A column that is 40% empty is highlighted. That is usually either an optional field or a broken export, and knowing which one changes what you do next.
Check unique against row count
Unique equal to the row count means the column is an id. Unique equal to two means it is a flag. Both are worth knowing before you group or join on it.
Download the profile
The same numbers as a table, which is what you attach when someone asks what is in the file.
Common questions
Mean or median — which should I read?
Compare them. When they are close the distribution is roughly symmetric; when the mean is far above the median a few large values are pulling it, which is normal for revenue and salary and misleading if you quote only the mean.
What does a mixed type mean?
The column holds more than one kind of value — numbers and text in the same place, usually because of a "N/A" or a "-" among the numbers. It is the reason a column sorts oddly or refuses to sum.
The profile’s column names are English
Deliberately. The downloaded profile is data, and a CSV whose headers change with the page’s language cannot be filtered by a script that ran yesterday. The cards on screen are in your language; the file is stable.
Feed it from
CSV Viewer
Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.
CSV Deduplicator
Removes duplicate rows on all or selected key columns, keeping the first, last or most complete row.
Pivot Table
Groups rows by one or two columns and aggregates with count, sum, average, min, max or distinct.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
Next
These accept what this tool produces, so the result can go straight in.
Quick Chart
Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
CSV Viewer
Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.
Descriptive Statistics
Computes mean, median, mode, variance, standard deviation, quartiles and outliers from pasted numbers.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.
Currency Converter
Converts between about thirty currencies at the ECB’s daily reference rates, crossed through the euro, or at a rate you type in.