ffee
All tools
Column Statistics
Paste tabular data and get count, unique, min, max, mean, median and top values per column.
Summarise every column
Rows: 0 · Columns: 0
· Numeric columns: 0
How to use the Column Statistics
- Paste the tabular data you want to summarise.
- Check the delimiter and whether the first row holds column names.
- Calculate the statistics and read or copy the per column summary.
Features
- Count, empty count and unique count for every column
- Min, max, mean and median for numeric columns
- Top values with their frequencies for text columns
- Summary shown as both a table and copyable text
Advertisement
Frequently Asked Questions
Common questions about the free online column statistics.
Every column gets its row count, empty count, unique count, minimum, maximum and top values,
plus mean and median when it holds numbers.
A column counts as numeric when every non empty value parses as a number, so a single stray
word stops the numeric summary.
The values are sorted, then the middle value is used, or the average of the two middle values
when the count is even.
For each column the most frequent values are listed with the number of times they appear,
which quickly reveals common categories.
No. Values that differ only by letter case are counted as the same unique value, which
matches how people read the data.
No. Empty cells are counted in the empty column and excluded from the mean and median so the
numbers stay meaningful.
The parser follows RFC 4180, so quoted values with commas, doubled quotes or line breaks are
read as a single cell.
No. Every statistic is calculated in your browser and nothing is sent anywhere.
Yes. Copy cells from Excel, Numbers or Google Sheets and paste them, and tab separated data
is detected automatically.
Yes. It is completely free with no account, no sign-up and no limit on how much data you
summarise.
Last updated: October 10, 2026