🛡️Data is processed locally – We cannot see your data
Group By
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
AboutGroup By
Group rows by category and calculate sums or averages.Category: Analysis & VisualizationTotaling revenue per customer IDAveraging order value per regionCounting transactions per day
The Group By tool is compatible with:.Use Group By for a quick one-column summary; if you later need to cross that category against a second dimension, graduate to Pivot Table, then visualize the totals with Charts.Group By collapses your CSV around one category column and applies a single aggregation — sum, average, count, min, or max — to a chosen value column. It's the CSV equivalent of a spreadsheet's SUMIF or AVERAGEIF, but applied automatically across every category in the column at once. Unlike Pivot Table, there's no dragging fields into rows and columns — you pick a group-by column, a value column, and an aggregation, and get a clean summary table back instantly.
Frequently Asked Questions:
What kind of aggregations can I compute?
Sums, averages, and other standard aggregations grouped by a category column, similar to a pivot table's core function.
Does it require SQL knowledge?
No, it's a point-and-click grouping tool, not a query language.
The fastest path from raw transaction rows to a per-category total, built for analysts who do not need a full pivot.