Use this pivot table creator to summarize and analyze your data. Upload your dataset, configure the pivot table, and visualize the results with charts.
Upload a CSV or Excel file to create a pivot table, or clickhere to load sample data. Save your data when you are done because this tool does not save your data anywhere.
A pivot table is an interactive data summarization tool that allows you to reorganize, sort, and analyze your data in various ways. Pivot tables are especially useful for:
Row Fields
Categories that appear as rows in your pivot table
Column Fields
Categories that appear as columns in your pivot table
Value Fields
Numerical data that gets summarized in the table cells
Aggregation Function
How values are combined (sum, average, count, etc.)
| Region | Product | Month | Sales | Profit |
|---|---|---|---|---|
| North | Widgets | January | 1200 | 250 |
| North | Widgets | February | 1500 | 310 |
| North | Gadgets | January | 900 | 170 |
| North | Gadgets | February | 950 | 180 |
| South | Widgets | January | 1000 | 220 |
| South | Widgets | February | 1100 | 240 |
| (showing 6 of 16 rows) | ||||
Row Fields
Region
Column Fields
Product
Value Field & Aggregation
Sales (Sum)
| Gadgets | Widgets | Grand Total | |
|---|---|---|---|
| East | 1,550 | 2,700 | 4,250 |
| North | 1,850 | 2,700 | 4,550 |
| South | 1,680 | 2,100 | 3,780 |
| West | 1,350 | 2,300 | 3,650 |
| Grand Total | 6,430 | 9,800 | 16,230 |
Use this pivot table creator to summarize and analyze your data. Upload your dataset, configure the pivot table, and visualize the results with charts.
Upload a CSV or Excel file to create a pivot table, or clickhere to load sample data. Save your data when you are done because this tool does not save your data anywhere.
A pivot table is an interactive data summarization tool that allows you to reorganize, sort, and analyze your data in various ways. Pivot tables are especially useful for:
Row Fields
Categories that appear as rows in your pivot table
Column Fields
Categories that appear as columns in your pivot table
Value Fields
Numerical data that gets summarized in the table cells
Aggregation Function
How values are combined (sum, average, count, etc.)
| Region | Product | Month | Sales | Profit |
|---|---|---|---|---|
| North | Widgets | January | 1200 | 250 |
| North | Widgets | February | 1500 | 310 |
| North | Gadgets | January | 900 | 170 |
| North | Gadgets | February | 950 | 180 |
| South | Widgets | January | 1000 | 220 |
| South | Widgets | February | 1100 | 240 |
| (showing 6 of 16 rows) | ||||
Row Fields
Region
Column Fields
Product
Value Field & Aggregation
Sales (Sum)
| Gadgets | Widgets | Grand Total | |
|---|---|---|---|
| East | 1,550 | 2,700 | 4,250 |
| North | 1,850 | 2,700 | 4,550 |
| South | 1,680 | 2,100 | 3,780 |
| West | 1,350 | 2,300 | 3,650 |
| Grand Total | 6,430 | 9,800 | 16,230 |
