Pivot Table Builder

Build a pivot table from CSV: rows × columns × values with an aggregation.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

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

1
Step 1
Paste the CSV or drop a file.
2
Step 2
Set the row column, the column column and the value column.
3
Step 3
Choose the aggregation and press Process.

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?
Pick row, column and value columns plus an aggregation and press Process.
Does it add grand totals?
No. The pivot table does not include a grand total row or column.
What aggregations can I use?
sum, mean, count, min and max.
Is a pivot the same as group by?
A group-by uses one key; a pivot spreads a second key across columns.

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 YouTube
  • Mean, Variance and Standard Deviation

    StatQuest with Josh Starmer

    Spread metrics when analyzing pasted datasets.

    Watch on YouTube