Data & CSV

CSV grouped summary

Summarise a numeric column separately for each category.

CSV grouped summary
Esc to restore

Your inputs

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Groups exact text values in first-seen order. Shows row count, non-blank numeric count, sum, mean, minimum and maximum. Blank numeric cells are ignored; other non-numeric values are rejected. Empty groups have sum zero and blank mean/min/max. All calculations stay local; up to 50,000 groups.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data
ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09
Column separator
Comma
Group column
Department
Numeric value column
Amount

Example result

Example result
GroupRowsNumeric valuesSumMeanMinimumMaximum
Design3333011060150
Writing2180808080

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile