Σ⊞
Group By & Summarize
Totals, averages and counts per group – several columns at once.
| region | Count | units_sum | revenue_sum | revenue_avg |
|---|---|---|---|---|
| North | 3 | 20 | 52.5 | 17.5 |
| South | 3 | 19 | 52 | 17.3333 |
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
Group By & Summarize: Totals, averages and counts per group – several columns at once. 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,count,units_sum,revenue_sum,revenue_avg North,3,20,52.5,17.5 South,3,19,52,17.3333
How do I use the Group By & Summarize?
Paste or type your text. Choose the options you need. Copy or download the result.
Is the Group By & Summarize 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.