CSV Statistics Tool
Paste a CSV and get summary statistics for every numeric column.
What this tool does
A CSV statistics tool reads pasted comma-separated data and returns summary statistics for each numeric column: count, sum, average, minimum, maximum and median together. The median sits alongside the average deliberately, because a single outlier drags the mean while the median barely moves - a column of salaries with one enormous figure shows an average no employee earns and a median most do. The header row is detected automatically, non-numeric columns are skipped, and nothing leaves the browser.
Pastes a CSV and returns count, sum, average, minimum and maximum for every numeric column at once.
Detects the header row and skips non-numeric columns automatically, mixed files included.
Reports the median and the spread alongside the average, since the mean alone hides skewed data.
Handles both comma and semicolon delimited files and copes with quoted fields.
How to use it
- Paste your CSV data into the box.
- The tool detects the header and the delimiter.
- Each numeric column shows its full summary - count, sum, average, median, min and max.
- Read non-numeric columns as a distinct-values count instead.
- Copy any column's summary for your notes.
Why use this tool
A CSV statistics tool answers the first question asked of any dataset - what is actually in these columns - without opening a spreadsheet or writing code. Pasting a file and seeing count, sum, average, median, minimum and maximum per column takes seconds, and catches the things that break downstream analysis early: a text value sitting in a numeric column, an empty column, or a figure so far from the rest that it will skew every average built on it.
Why we built it
We built this CSV statistics tool to show the median next to the average and to report how many values each column actually had, because those two details decide whether the summary can be trusted. A mean without its median is half a statistic, and a count that quietly drops blank cells makes columns look more complete than they are. The CSV formatter tidies the raw text and the CSV sorter orders rows; this one summarises the numbers.
For a single column by hand, the statistics calculator takes a plain list of values, and the mean median mode calculator covers the three averages together.
Who this tool is for
- Anyone opening an export and wanting the shape of it in seconds
- Students summarising data sets for assignments
- Analysts sanity-checking a file before importing it
- Anyone who wants the statistics without a spreadsheet
When to use it
- Checking a data export before importing it anywhere.
- Summarising survey responses or measurement columns.
- Finding the outlier that is distorting an average.
- Getting column statistics for a report without Excel.
How it is calculated
Each row is split on commas or semicolons, honouring quoted fields. A column counts as numeric if every non-empty value parses as a number. For numeric columns the tool returns count (values present), sum, average (sum divided by count), median (the middle value, or the mean of the two middles), minimum and maximum. The spread is the range, maximum minus minimum, which shows the outlier straight away.
Worked example: a sales column of 4200, 3800, 4100, 15200, 3950 gives count 5, sum 31,250, average 6,250, median 4,100, minimum 3,800 and maximum 15,200. The average sits above every value but one - the median is the honest typical figure, and the range of 11,400 is the outlier announcing itself.
Values are not validated beyond parsing - a stray footnote row or an empty cell is skipped rather than counted, and a text value in a numeric column moves that column to the non-numeric list entirely. Check the value counts before trusting a column.
What each statistic means
| Statistic | What it says |
|---|---|
| Count | How many values the column actually holds |
| Sum | Total of all values |
| Average | Mean - sum divided by count |
| Median | Middle value - robust against outliers |
| Min / Max | The ends of the range |
| Range | Max minus min - the spread at a glance |
A worked example
These are the values the tool opens with, so you can see exactly what it does with them. Replace the sample with your own data and the statistics recalculate; the figures below come from the same calculation.
| Region | Sales | Returns |
|---|---|---|
| North | 4200 | 120 |
| South | 3800 | 95 |
| East | 4100 | 110 |
| West | 15200 | 80 |
| Central | 3950 | 130 |
With those inputs, the tool returns:
- Sales: count 5, sum 31,250, average 6,250, median 4,100, range 3,800 – 15,200
- Returns: count 5, sum 535, average 107, median 110, range 80 – 130
- Region: 5 distinct text values, skipped as non-numeric
- The West row is the outlier dragging the sales average above every other region
What you enter, and what you get back
| Item | Details |
|---|---|
| CSV data | Pasted text with a header row and delimited rows. |
| Delimiter | Detected automatically: comma or semicolon. |
| Result | Per-column summary: count, sum, average, median, min, max, range. |
Issues you may run into
| What you see | Why it happens | What to do |
|---|---|---|
| Column listed as text | One non-numeric value in the column. | Find the stray cell; the column is skipped entirely. |
| Columns look merged | Unexpected delimiter in the data. | Re-export with commas, or check for unquoted semicolons. |
| Count lower than rows | Empty cells skipped. | Count reflects values present, not rows. |
| Average looks wrong | Outlier skewing the mean. | Compare against the median and check the range. |
Assumptions and limitations
- Runs entirely in the browser on pasted data; very large files are limited by browser memory.
- A column counts as numeric only if every non-empty value parses as a number - one stray text cell reclassifies the whole column.
- Empty cells are skipped rather than counted, so the count can be lower than the row count.
- Summary statistics only; no charting, filtering or significance testing.
Frequently asked questions
How do I get statistics from a CSV file?
Paste the file's contents into the tool and the statistics appear per column immediately: count, sum, average, median, minimum, maximum and range for every numeric column, with non-numeric columns listed separately. Nothing is uploaded - the parsing happens in your browser.
What summary stats does it calculate?
For each numeric column: count of values, sum, average (mean), median, minimum, maximum and the range. The median is shown beside the average because a single outlier can drag the mean far from the typical value while the median barely moves.
Does it work with comma or semicolon files?
Yes - the delimiter is detected automatically from the data. Quoted fields containing the delimiter are handled correctly, so a quoted address with a comma inside does not split the column.
How are non-numeric columns handled?
A column is treated as numeric only if every non-empty value parses as a number. Anything else - names, dates, categories - is listed as a text column with its distinct value count, which is often useful in itself for spotting typos and variants.
Does the file leave my computer?
No. The entire calculation runs in the page on the pasted text. There is no upload, no server and no storage - closing the tab discards the data completely.
Is the CSV statistics tool free?
Yes, completely free with no account, no row limits and nothing uploaded. It runs entirely in your browser.