Pivot Table Maker
Choose what goes down the side, optionally what goes across the top, and the number to add up. Get sums, counts, averages, smallest, largest and counts of different values.
Drag a file here or choose one
Worked examples
Sales by region and product
Region,Product,Sales North,Tea,120 North,Coffee,80 South,Tea,95 North,Tea,70 South,Coffee,60
Region,Coffee,Tea,Total North,80,190,270 South,60,95,155 Total,140,285,425
Sum of Sales, region down the side and product across the top. North Tea is 120 + 70 = 190.
Count of rows
Same table, count of rows by region
Region,Count of rows North,3 South,2
No field to summarise, so each cell counts rows.
About Pivot Table Maker
A pivot table groups the rows of a list and summarises a number for each group. With regions down the side and products across the top, each cell holds the total sales for that region and product. It turns a list of thousands of transactions into a table you can read at a glance.
Choose the field for the rows, optionally the field for the columns, and the field to summarise, then pick how: sum, count of rows, average, smallest, largest, count of different values or count of filled cells. Totals can be added along the right and at the bottom, and the rows can be sorted by label or by total with the biggest first. Amounts with currency signs and thousands commas are read as numbers, and cells that are not numbers are ignored in sums and averages.
How to use Pivot Table Maker
- Paste your CSV or open a file.
- Choose what goes down the side, and what goes across the top if you want a second dimension.
- Choose the numbers to summarise and how: sum, count, average, smallest, largest or different values.
- Choose whether to add totals, then download the pivot table.
Common uses
- Totalling sales by region and product
- Counting tickets by status and team
- Averaging scores by class
- Finding the largest order for each customer
Frequently asked questions
What if I do not choose a field to summarise?
Each cell then counts the rows in that group, which is the quickest way to see how many records fall in each combination.
How are blank group labels shown?
They are collected under (blank), so no rows disappear from the totals.
Are the labels sorted as numbers when they are numbers?
Yes. Labels such as 2, 10 and 100 are put in numeric order. Other labels are sorted alphabetically, ignoring capitals, or by total if you choose that.
What does count of different values do?
It counts how many distinct values the field has in each group, ignoring capitals. It answers questions such as how many different customers ordered in each region.
Why must the column field have few values?
Each value becomes a column. Beyond about 200 columns a table is too wide to use, so the tool asks you to pick a field with fewer values.