Utility
CSV Group By Aggregator
Group CSV rows by columns and aggregate totals in your browser
Paste CSV data to group and summarize it.
Group CSV Data Without Leaving The Browser
This tool brings a common spreadsheet and pandas workflow into a lightweight browser utility. Paste CSV data, select the grouping columns, define the value columns, and calculate summaries instantly.
Supported Aggregations
You can create counts for any grouped slice, then add numeric summaries such as sum, average, minimum, and maximum for the value columns that matter to your analysis.
Good For Fast Exploratory Analysis
Use this tool to summarize revenue by segment, orders by country, transactions by month, or any other repeated pattern in a flat CSV table.
Frequently Asked Questions
How do I choose group-by columns?
Use the columns that define the buckets you want in the output table, such as country, segment, month, or product. Each unique combination becomes one grouped row.
Can I aggregate non-numeric columns?
Count works for any column set because it only counts rows. Numeric aggregations such as sum, average, min, and max only use numeric values and skip text cells.
What if my CSV contains missing values?
Missing or non-numeric cells are ignored for numeric aggregations. The tool shows warnings when some rows in a selected value column could not be used.
Does this upload my file?
No. The parsing and aggregation run in the browser from pasted CSV text, so the data stays on your machine.