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.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
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
More generate tools
Build test datasets, starter sheets, pivot summaries and chart-ready workbooks from a short description — no manual typing.
Browse Generate