Free · no signup · browser-local
CSV Pivot Table Generator for Grouped Summaries
Group CSV rows by a column and calculate the sum, average, count, minimum or maximum for each group. Sort the results and download a summary CSV.
Configure
LOCAL2 groups · 0 non-numeric rows skipped
| Group | sum | Rows |
|---|---|---|
| Boston | 20 | 2 |
| Denver | 15 | 1 |
Getting started
Paste or load CSV, choose group and value columns, select an aggregate, then download the summary.
Before you use the result
Numeric aggregates skip non-numeric cells and report the skipped count; inspect source units before summing.
Try an example
Group a city,amount table by city and sum each city’s sales.
How it works
A quote-aware CSV parser preserves commas and line breaks inside quoted fields before aggregation.
Frequently asked questions
Group CSV rows and calculate count, sum, average, min or max locally.
How do I use CSV Pivot Table?
Paste or load CSV, choose group and value columns, select an aggregate, then download the summary.
Does this tool upload my data?
Inputs and files are processed in your browser. Page-view analytics do not contain your tool input.
What should I check before using the result?
Numeric aggregates skip non-numeric cells and report the skipped count; inspect source units before summing.