About this tool
Pivot Table Generator is a free, in-browser tool that summarizes a CSV the way a spreadsheet pivot table does — pick a row field, an optional column field, a value field, and an aggregation, and it builds a cross-tabulated summary with row totals, column totals, and a grand total. It all runs on your device, so nothing is uploaded.
Choose sum, count, average, minimum, or maximum as the aggregation; count works on any field, while the numeric aggregations parse the value column and ignore non-numeric cells. Leave the column field as none for a simple grouped summary, or set it to spread a second dimension across the columns.
Because the grouping and aggregation happen locally it is a private, offline-friendly alternative to opening a spreadsheet, and you can download the resulting pivot as a CSV.
Frequently asked questions
How do the row, column, and value fields work?
The row field groups rows down the left, the optional column field spreads a second dimension across the top, and the value field supplies the numbers that are aggregated in each cell. Set the column field to (none) for a single-column summary.
Which aggregations are available?
Sum, count, average, minimum, and maximum. Count tallies the matching rows regardless of value type; sum, average, min, and max parse the value column as numbers and skip blank or non-numeric cells.
What do the totals represent?
Each row's total re-aggregates all of that row's underlying values, each column's total aggregates its whole column, and the grand total aggregates the entire dataset — so averages are true overall averages, not an average of the cell averages.
What CSV conventions are expected?
Fields are split on your chosen delimiter, quoted fields (inner quotes doubled) are handled, and the first row is treated as the header of field names when the box is ticked; otherwise generic Column N names appear in the field pickers.
More tools