Descriptive statistics for your spreadsheet or CSV, computed in your browser — for every column you get count, missing count, distinct values, and (for numeric columns) sum, average, min, max, median, mode and standard deviation. You can also group rows by one column and aggregate another. Everything runs locally — no upload.
100% in-browser — your data is never uploaded. Load an .xlsx / .xls / .csv / .tsv file, review the statistics cards, and export the summary report as CSV.
Drop a spreadsheet or CSV file here or click to choose
XLSX / XLS / CSV / TSV — up to 200 MB
Data preview (first rows):
Group by one column and aggregate another:
What do these controls do? (click to expand / collapse)
The three controls
Group by — the column whose values define the buckets (one row per unique value in the output table).
Aggregate — the column whose numbers you want to roll up per bucket (must be numeric; text cells are skipped the same way Excel does it).
Function — how the roll-up is calculated: SUM (total), AVERAGE (mean), COUNT (count of numeric cells), MIN (smallest), MAX (largest), MEDIAN (middle value), MODE (most frequent).
Worked example
Suppose your sheet looks like this (Region in column A, Amount in column C):
Row
Region
Sales Rep
Amount
1
North
Alice
100
2
South
Bob
200
3
North
Carol
50
4
South
Dave
300
Picking Group by = A (Region), Aggregate = C (Amount), Function = SUM produces:
Region
SUM(C)
North
150
100 + 50
South
500
200 + 300
Same example, other functions
Function
North
South
How
SUM
150
500
add up the column
AVERAGE
75
250
sum / count of numeric rows
COUNT
2
2
how many rows in the bucket (with a numeric Amount)
MIN
50
200
smallest numeric value
MAX
100
300
largest numeric value
MEDIAN
75
250
middle value of the numeric rows
Tip: pick a text column (e.g. Region, Category) for Group by and a numeric column (e.g. Amount, Price, Qty) for Aggregate. AVERAGE ignores blank & text cells in the Aggregate column (same as Excel AVERAGE).
Which standard deviation you are getting
The StdDev on this page is the population standard deviation — the same as Excel's STDEV.P: it divides the squared deviations by N (the number of values). Excel's STDEV.S divides by N−1 instead (Bessel's correction) and therefore reports a slightly larger number for the same data. The mean is also outlier-sensitive: one extreme value can drag it far from where most values sit, while the median barely moves — check both before trusting an "average".
Example: for 2, 4, 4, 4, 5, 5, 7, 9 the population StdDev is exactly 2, while the sample StdDev is ≈ 2.14. Use the sample figure when your numbers are a sample of a larger population; use the population figure when you have every value. For interactive statistical calculators see Math Statistics.
