Pivot Table Generator
Summarize a table by row and column fields – sum, average, count, min, max.
| region | Apples | Pears | Total |
|---|---|---|---|
| North | 40.5 | 12 | 52.5 |
| South | 25 | 27 | 52 |
| Total | 65.5 | 39 | 104.5 |
Runs entirely in your browser. Nothing is sent anywhere.
How it works
- 1Paste or type your text.
- 2Choose the options you need.
- 3Copy or download the result.
About this tool
Pivot Table Generator: Summarize a table by row and column fields – sum, average, count, min, max. Paste your text and the result appears immediately, ready to copy or download. Everything happens locally in your browser — nothing you paste is uploaded or stored.
Example
Input
region,product,month,units,revenue North,Apples,Jan,10,25.5 North,Pears,Jan,4,12 South,Apples,Jan,7,17.5 South,Apples,Feb,3,7.5 North,Apples,Feb,6,15 South,Pears,Feb,9,27
Output
region,Apples,Pears,Total North,40.5,12,52.5 South,25,27,52 Total,65.5,39,104.5
How do I use the Pivot Table Generator?
Paste or type your text. Choose the options you need. Copy or download the result.
Is the Pivot Table Generator free?
Yes. It is completely free with no sign-up, no usage limits and no watermark.
Is my data sent to a server?
No. Everything is calculated locally in your browser. Nothing you enter is uploaded, logged or stored.
Does it work on my phone?
Yes. It works in any modern browser on Android, iPhone, iPad, Windows, Mac and Linux — no app needed.