Pivot Table Builder
Build a pivot table from CSV: rows × columns × values with an aggregation.
About this tool
Cross two categorical columns and aggregate a third: regions down the side, products across the top, revenue in the cells. Choose sum, mean, count, min or max. Nothing leaves your browser.
How to use
How it works
Each unique value of the row column becomes a row and each unique value of the column column becomes a field. The cell holds the aggregation of the value column for rows matching both. Rows are listed alphabetically; the column fields follow the order they first appear in the data.
Worked example
Revenue by region and product
- Input
- Row: region, Column: product, Value: revenue, sum
- Output
- East: Widget 30, Gadget 45 North: Widget 200, Gadget 80 South: Widget 70, Gadget 190
- Walkthrough
- North Widget is 100 + 100 = 200 because two North Widget rows exist in the table.
Limitations
- One value column and one aggregation per pivot.
- No totals row or column.
- High-cardinality columns create very wide tables.
Questions
How do I make a pivot table from a CSV?
Does it add grand totals?
What aggregations can I use?
Is a pivot the same as group by?
Features
- Row x column pivot
- Five aggregations
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
Learn JSON - Full Crash Course
freeCodeCamp.org
JSON is a primary interchange format for data utilities.
Watch on YouTubeMean, Variance and Standard Deviation
StatQuest with Josh Starmer
Spread metrics when analyzing pasted datasets.
Watch on YouTube
- Fetch API
MDN
How browsers pull remote data into local tools.
- Getting started with JSON Schema
JSON Schema
Validate structured data after converting formats.