CSV numeric column statistics
This tool calculates summary statistics for one column of numbers in a CSV file. It is a quick way to check totals, averages and spread without writing a spreadsheet formula.
- Runs in your browser
- Free, no account needed
- Copy or download the result
Result
Example
name,email,score Ada,[email protected],12 Lin,[email protected],9
{
"column": "score",
"dataRows": 2,
"numericRows": 2,
"blankRows": 0,
"nonNumericRows": 0,
"min": 9,
"max": 12,
"sum": 21,
"mean": 10.5,
"median": 10.5,
"stdDevPopulation": 1.5
}How to use the csv numeric column statistics
- Paste CSV with a header row into the CSV with a header box.
- Set Input separator and type the header name in Numeric column.
- Choose Nonnumeric cells: Stop and show the row, or Count and skip.
- Press Run, then Copy result or Download.
How it works
The result shows row counts plus min, max, sum, mean, median and population standard deviation.
Standard deviation divides by the number of values. This is the population version, not the sample version that divides by one less.
Empty cells are counted as blank and skipped. A cell holding only spaces is not blank, so it counts as nonnumeric.
Numbers must be plain, like 12, -3.5 or 1e3. Currency symbols, percent signs and thousands separators like 1,000 make a cell nonnumeric.
The column name must match the header exactly, including case.
Everything runs in your browser. Your input is not uploaded or stored.
Questions and answers
How do I find the average of a CSV column?
Paste the CSV, type the column name in Numeric column, and press Run. The mean in the result is the average.
Which standard deviation does it use?
It reports population standard deviation, which divides by the count of values. For the sample version, which divides by one less, use a dedicated standard deviation calculator.
What happens to cells with text?
By default the tool stops and names the first row that is not a plain number. Choose Count and skip to ignore those cells and see how many there were.
Is my CSV uploaded?
No. The math runs in your browser, so the numbers in your file stay on your computer.