TSV Stats
A first look at an unfamiliar file. For every column you get the number of values, how many are empty, how many are distinct, and — where the values are numeric — the minimum, maximum, and mean. That's usually enough to spot the problems before you load anything: a column that's 60% null, an ID column that isn't unique, a price column whose maximum is impossible.
How to use
- Paste or drop the file. The summary appears as a table you can copy.
- Read the null counts first — they tell you which columns can be trusted.
- Compare unique counts to the row count to find candidate keys, and to spot columns that are constant.
- Copy or download the summary to paste into a ticket or a data review.
What each number is good for
Nulls is the most useful column in practice: a field that's mostly empty can't support the analysis someone is about to do with it. Unique equal to the row count means the column is a candidate key — worth confirming before you join on it, since duplicate keys multiply rows. Unique equal to 1 means the column is constant and can probably be dropped with delete columns. Min and max catch sentinel values that pretend to be data: a min of-999 or a max of 9999-12-31 is almost always a placeholder rather than a measurement. The mean is computed over the numeric values only, so a large gap between the value count and the numeric count tells you the column is mixed.
Where to go next
For the distribution of a single categorical column — the real category list, plus the typos hiding in the tail — use value counts. For types and nullability expressed as DDL, the schema generator. For aggregates grouped by a column rather than over the whole file, group and aggregate.
FAQ
Are non-numeric values counted in the mean?
No — they're skipped, not treated as zero. That means the mean is over the numeric subset, which is why the count column matters when you read it.
What counts as null?
An empty cell, or one containing only whitespace. A literal N/A, -, or NULL string counts as a value — value counts will show you those, and find and replace can convert them to genuinely empty.
Is there a median or standard deviation?
Not on this page. Group and aggregate offers median (group by a constant column to get it for the whole file); standard deviation isn't offered anywhere here.
Does it handle numbers with thousands separators?
Yes — 1,234.5 is read as a number. Currency symbols are not stripped, so $1,234 counts as non-numeric.
Privacy
100% client-side. No upload. See the privacy policy.