Spreadsheet Analyzer
Upload a CSV and get real statistics for every column — detected type, min/max/average/median for numbers, unique value counts for text.
How to use Spreadsheet Analyzer
- Start by providing the required input: Drop a CSV file. Use Load Sample to try example data first.
- No additional settings need to be configured.
- This tool has no separate run button; its results update as you add or change the input.
- Review the result or preview on the page and confirm it matches your input before using or sharing it.
Real column statistics, not just a preview of the first few rows
Opening a CSV in a spreadsheet app shows you the data but not its shape — which columns are actually numeric, what their range and average look like, how many unique values a text column really has. Computing real per-column statistics answers questions a quick scroll-through can't.
How numeric columns are distinguished from text
A column is treated as numeric only when the large majority of its filled values actually parse as numbers — a few stray non-numeric entries don't disqualify a column, keeping the detection useful on real-world, slightly messy data.
What statistics are shown for numeric columns?
Minimum, maximum, mean, and median — a real statistical summary, not just a min/max range.
What's shown for text columns instead?
Unique value count and the single most common value — useful for spotting how varied (or repetitive) a categorical column actually is.
Does this handle missing values in the calculations?
Yes — empty cells are excluded from numeric calculations and unique-value counts rather than being treated as a value themselves.