Pivot Table Generator
Summarise data without touching the pivot dialog.
Choose rows, columns and a value to aggregate, and get an instant cross-tab plus a downloadable workbook containing both the summary and a native pivot table wired to your source data.
- Rating
- 4.9(2.0K)
- Monthly uses
- 268K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Live cross-tab preview that updates as you drag fields
- Six aggregations plus percentage-of-total and running-total modes
- Grand totals, subtotals and blank handling all configurable
How to use Pivot Table Generator
- 1
Upload your dataset.
- 2
Drag fields into rows, columns and values.
- 3
Choose the aggregation — sum, count, average, min, max or distinct count.
- 4
Download the workbook with the pivot table included.
Watch a walkthrough
Common problems and fixes
Numbers are counted instead of summed.
The value column is stored as text. Convert it with the Number Formatter and the sum aggregation becomes available.
Too many columns to read.
The column field has high cardinality. Move it to rows, or filter it down to the top values first.
Frequently asked questions
What people say
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Our IT team blocked every other online tool because they upload files. This one does not, so pivot table generator finally got approved for use on real data.
Our IT team blocked every other online tool because they upload files. This one does not, so pivot table generator finally got approved for use on real data.
More generate tools
Build test datasets, starter sheets, pivot summaries and chart-ready workbooks from a short description — no manual typing.
Browse Generate