Group and aggregate CSV rows byany column
Pick the columns to group by, choose a numeric measure, and get one aggregated row per distinct combination — sum, average, count, min, or max, computed instantly in your browser.
Pick the columns to group by, choose a numeric measure, and get one aggregated row per distinct combination — sum, average, count, min, or max, computed instantly in your browser.
Group By collapses your rows into one summary row per distinct combination of the columns you choose, then aggregates a measure across each group. It is the fastest way to answer questions like total sales per region or average score per category without a spreadsheet.
Select one or more columns to group on. Every distinct combination of their values becomes a single output row, in first-seen order so the result stays predictable.
Select a numeric column as the measure, then choose sum, average, count, min, or max. Non-numeric and blank cells are skipped automatically so a few dirty values never break the math.
The tool returns a clean RFC-4180 CSV with one row per group and a clearly named aggregate column. Copy or download it — all computation happened locally, so nothing was uploaded.
A focused, private alternative to dragging a CSV into a pivot table just to get one aggregated column.
Grouping and aggregation run in your browser with JavaScript. Your CSV is never uploaded, logged, or stored on a server — it never leaves your device.
Group by any number of columns at once. The tool builds a row for each distinct combination, so you can break down totals by region and product in one pass.
Sum, average, count, min, and max cover the common reporting needs. Counts work on any column; the numeric aggregations cleanly ignore blanks and non-numbers.
Results are emitted as strict RFC-4180 CSV with properly quoted fields and a self-describing measure header, ready to drop into any spreadsheet or BI tool.