How to use the Pivot Table Maker Online
- 1. Add your dataPaste CSV or upload a file with column names in the first row.
- 2. Pick the fieldsChoose what goes in rows, in columns (optional) and as the value.
- 3. Build the pivotGet the summary table with totals and download it as CSV.
How a pivot table works
A pivot table groups rows that share a value and summarises another column for each group. With Region in rows, Product in columns and Sum of Sales as the value, every cell answers one question: how much of this product sold in this region?
- Sum: totals, such as revenue.
- Count: how many rows, such as number of orders. It works on any column, even text.
- Average, Min, Max: typical, lowest and highest values.
Grand totals are worked out from the raw rows. For Average that means the true average of all rows, as in Excel, not an average of the group averages.
Worked example
The sample has 8 sales rows. Build the default pivot (Region × Product, Sum of Sales) and you get a 3 × 2 table:
- East: Laptop 39,000, Mouse 2,800, total 41,800
- North: Laptop 1,11,000 (50,000 + 61,000), Mouse 4,000, total 1,15,000
- South: Laptop 87,000 (42,000 + 45,000), Mouse 3,500, total 90,500
- Grand total: 2,47,300
Change Summarise by to Count and the same layout shows how many orders each cell has: North Laptop becomes 2. Set Columns to (none) for a simple one-column summary, which is the same as SQL's GROUP BY region with SUM(sales).
Group labels are sorted A to Z, with numbers in natural order (2 before 10). Blank keys are shown as "(blank)" so they are not hidden.
Frequently asked questions
How many groups can it show?
Up to 500 row groups and 50 column groups, which keeps the table readable. Choose fields with fewer unique values for bigger data.
Why is Sum empty for my column?
The value column must contain numbers without commas or currency signs. Clean it in the CSV editor first, or use Count.
Can I filter before pivoting?
Filter in the CSV editor, download the filtered file and pivot that.
Is the pivot maker free?
Yes, it is free. The first pivot asks for your name and WhatsApp number once, and after that every Uncodemy tool opens directly.