CSV Statistics Summary
Compute count, min, max, mean, and sum for every numeric column in a CSV, directly in your browser.
Pure browser JavaScript. CSV parsing by PapaParse (MIT), self-hosted.
How to use this tool
- Paste CSV or upload a .csv file with a header row.
- Click Compute stats.
- Read the per-column count, min, max, mean, and sum table.
Compute count, min, max, mean, and sum for every numeric column in a CSV, directly in your browser.
How it works
This tool computes descriptive statistics for every numeric column in a CSV file: count of non-empty values, minimum, maximum, mean (average), and sum. It runs entirely in your browser and produces results instantly.
Paste or upload your CSV. The tool detects which columns contain numeric data and calculates the statistics for each one. Non-numeric columns (text, dates, etc.) are shown in a summary table but numeric stats are not computed for them.
Use this for a quick sanity-check of a dataset — spotting outliers, verifying totals, or getting a sense of the range and center of your data — before loading it into a heavier analysis tool.
Results are displayed in a table and can often be copied or downloaded. This is ideal for a fast first look at exported data from a database, spreadsheet, or reporting tool.
Worked example
Summarize a sales export to check total revenue and average order value
- Upload the sales CSV with columns like Order ID, Amount, and Quantity.
- Click Compute Stats.
- Read the Sum row for the Amount column to see total revenue.
- Read the Mean row for the Amount column to see average order value.
- Check the Min and Max rows to spot any suspicious outliers.
A stats table showing count, min, max, mean, and sum for Amount and Quantity columns.
Common mistakes to avoid
- Having thousands separators (commas in numbers like 1,000) in numeric columns, which makes the tool treat them as text.
- Expecting stats on date columns — dates are not numeric and will not produce min/max/mean values.
- Interpreting the sum of an ID column as meaningful — always check whether a column represents a quantity or just an identifier.
Key terms
- Mean
- The arithmetic average: the sum of all values divided by the count of non-empty values.
- Min / Max
- The smallest and largest numeric values found in a column.
- Count
- The number of non-empty cells in a column; blank cells are excluded from all calculations.
Frequently asked questions
- Which columns are analysed?
- Only columns that contain numeric values. Non-numeric cells in a column are ignored when computing its stats.
- Is anything uploaded?
- No — all statistics are computed locally in your browser via PapaParse.