Simple Pivot Table Builder
Group and aggregate CSV data like a pivot.
A lightweight pivot table
Choose a column to group by and a column to aggregate, and this sums or counts within each group — the core of a pivot table, without opening a spreadsheet.
It answers the common 'total sales by region' or 'count of tickets by status' question in one step, enough for a quick summary before a full spreadsheet pivot.
One level of grouping
It handles a single group-by for quick answers; complex pivots still want a spreadsheet. Your data is aggregated on your device and never uploaded.
Frequently asked questions
What does this simple pivot table builder do?
Create a small group-by count or sum table from CSV data.
How do I set up the pivot?
Type the header of the column to group by (such as "team") and, for sums, the column to add up (such as "revenue"). Choose count to count rows per group instead.
What happens to blank group values?
Rows with an empty group cell are collected under "(blank)" so they are still counted. In sum mode, values that are not numbers count as zero.
Can it group by two columns?
No, one group column at a time. Combine two columns into one in your spreadsheet first (for example "team - region") if you need a two-level breakdown.
Related tools
More free browser utilities for data cleanup, formatting, and developer workflows.