Online Tool Store
Pivot Table Maker
Turn pasted CSV data into a pivot table by choosing row, column, and value fields with sum, count, or average aggregation, in your browser.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
How the pivot table maker works
- Paste CSV data with a header row.
- Choose which column becomes the row labels, which becomes the column labels, and which column's values to aggregate.
- Choose an aggregation method — sum, count, or average — and the pivot table updates instantly.
FAQ
What does a pivot table actually do?
It reorganizes rows of data into a summary grid — choosing one column's values as row labels, another's values as column labels, and aggregating a third column's values (by sum, count, or average) into each cell where a row and column intersect.
What's the difference between Sum, Count, and Average?
Sum adds up the value column's numbers for each cell; Count just counts how many matching rows there are, regardless of the value; Average divides the sum by the count. Count is useful even for non-numeric value columns, since it just counts occurrences.
Can I paste data straight from a spreadsheet?
This tool expects comma-separated CSV, so if you're copying from a spreadsheet, use a "paste as CSV" option or convert tab-separated data first with our TSV to CSV Converter.
Is my data sent anywhere?
No. The pivot table is built entirely in your browser as you type or change settings — nothing is sent to Online Tool Store or stored.
How we compare
| Feature | Online Tool Store | Google Sheets pivot table | Excel PivotTable |
|---|---|---|---|
| No spreadsheet app needed | ✓ | Requires Google Sheets | Requires Excel |
| Paste and go, no setup wizard | ✓ | Multi-step wizard | Multi-step wizard |
| Data never uploaded to a server | ✓ | Cloud-based | ✓ |
For a quick pivot summary of pasted CSV data without opening a spreadsheet app, the Online Tool Store Pivot Table Maker builds it instantly.