CSV Group By & Aggregate

CSV input

Group keys

Column

Resolved

city

Aggregations

Column

Operator

Alias (optional)

Numeric

Column

Operator

Alias (optional)

Numeric

Column

Operator

Alias (optional)

Numeric

Aggregated CSV

city,sum(sales),avg(age),rows
Austin,75,28,1
Portland,212.3,28.5,2
San Francisco,150.2,29,1
Seattle,320.5,30.5,2

Options

Parsing

Header rowSkip empty lines

Trim whitespace

Output

Keep headerSort groupsQuote all fields

About Group By & Aggregate

Group rows by one or more columns and compute aggregates such as count, countDistinct, sum, avg, min, and max. Use column names when a header exists, or reference columns by index (#1, c2, 3 for 1-based indexing).

Tips

Enable Numeric for numeric aggregations to ignore non-numeric values safely.
Use aliases to control output column names (e.g., total_sales).
Switch output delimiter to generate TSV (\t) or pipe-separated results quickly.

Related Tools

About this collection

Each page is built around one practical task. Enter what you need, review the result, and use the actions provided by the tool.

What to expect

Inputs and results kept together
Layouts that adapt to smaller screens
Direct links for returning to a tool
No account needed for the listed utilities

Need something else? Request a tool.