Spreadsheet
Pivot Table Generator
Group CSV rows by any column and aggregate values with sum, count, average, min, or max.
| region | sum(revenue) |
|---|---|
| East | 1200 |
| North | 5400 |
| South | 6100 |
Related Tools
More free utilities you might find useful
Frequently Asked Questions
Quick answers to common questions
What is a pivot table?+
A pivot table groups rows by one field and summarizes another field with an aggregation like sum or count.
Which aggregations are supported?+
Sum, count, average, minimum, and maximum.
Do I need Excel?+
No. This tool builds a pivot summary from CSV directly in your browser.
Is my data uploaded?+
No. All grouping runs client-side.
Can I copy the result?+
Yes. Use Copy pivot to get CSV output or read the table on screen.
What if values are not numeric?+
Non-numeric values are skipped for sum, avg, min, and max. Count still works.
Can I use multiple row fields?+
This simplified version groups by one column. Run multiple passes for complex pivots.
Is it free?+
Yes.