Group By
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About Group By
Group rows by category and calculate sums or averages.
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.
Category: Analysis & VisualizationCommon Use Cases
- Totaling revenue per customer ID
- Averaging order value per region
- Counting transactions per day
Key Features
- Single-Column Grouping
- Sum/Average/Count/Min/Max
- Instant Summary Table
- CSV Export of Results
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.
Frequently Asked Questions
Sums, averages, and other standard aggregations grouped by a category column, similar to a pivot table's core function.
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.
Read the related guide →