Group CSV rows by any column and aggregate values with sum, count, average, min, or max.
More free utilities you might find useful
Quick answers to common questions
A pivot table groups rows by one field and summarizes another field with an aggregation like sum or count.
Sum, count, average, minimum, and maximum.
No. This tool builds a pivot summary from CSV directly in your browser.
No. All grouping runs client-side.
Yes. Use Copy pivot to get CSV output or read the table on screen.
Non-numeric values are skipped for sum, avg, min, and max. Count still works.
This simplified version groups by one column. Run multiple passes for complex pivots.
Yes.
Your data is processed entirely in your browser. Nothing is sent to any server.
| region | sum(revenue) |
|---|---|
| East | 1200 |
| North | 5400 |
| South | 6100 |