Pivot Table Maker — Summarize & Group Your Data Instantly
Paste or upload a CSV, drag column names into the Rows, Columns, Values, and Filters zones, pick an aggregation, and get a cross-tabulation table in seconds. Ten aggregation types. Export to CSV, XLSX, or Markdown. No Excel, no account, no upload.
1 Paste or Upload Data
Pivot Table Guide
How to group and summarize tabular data, what each zone does, and when to use each aggregation type.
What Is a Pivot Table?
A pivot table takes a list of records — 10,000 sales transactions, 5,000 survey responses, an inventory log — and collapses it into a grouped summary. You tell it which column to group by (Rows), which column to spread across the top (Columns), and which column to calculate (Values). The result is a compact cross-tabulation where every cell holds one aggregated number for the intersection of a row category and a column category.
The name comes from the idea of "pivoting" a column of values into column headers. A flat list has one row per transaction; after pivoting, you have one row per region and one column per month, with total revenue in each cell. The row count drops from thousands to dozens.
Before pivot tables existed, analysts ran SUMIF formulas for every combination by hand.
If you need to understand how aggregation functions work, the
Descriptive Statistics Calculator
covers mean, median, min, max, and count with worked examples.
How to Use This Tool
- Paste or upload your data. Copy cells from Excel or Google Sheets and paste them — the tab-separated output is auto-detected. Or upload a .csv, .xlsx, .tsv, or .json file. If your data needs cleaning first (blank rows, inconsistent casing, merged cells), run it through the CSV Data Cleaner first.
- Drag fields to zones. After the tool parses your data, every column header appears as a chip in the Available Fields pool. Drag each chip to Rows, Columns, Values, or Filters. On mobile, tap a chip to select it, then tap the destination zone.
- Choose aggregation types. Each chip in the Values zone has a dropdown selector for its aggregation type: Sum, Count, Average, Median, Min, Max, Count Distinct, % of Row Total, % of Column Total, or % of Grand Total.
- Click Build Pivot Table. The result table appears below. Click any column header to sort it.
- Export or share. Download as CSV or XLSX, copy as Markdown or TSV, or generate a shareable permalink that encodes your data and configuration.
The Four Zones
Every pivot table is built from four decisions:
| Zone | What it controls | Example |
|---|---|---|
| Rows | Each unique value becomes a row on the left side of the table. Add multiple row fields for nested grouping. | Region: North, South, East, West |
| Columns | Each unique value becomes a column header across the top (cross-tabulation). One field only. | Month: Jan, Feb, Mar |
| Values | The numeric column(s) to aggregate. Each gets its own aggregation type. | Sum of Revenue |
| Filters | Narrows which source rows enter the calculation. The pivot sees only matching rows. | Channel = Online |
You do not need to fill all four zones. A pivot with only Rows and Values produces a simple grouped summary — total sales per region, headcount per department. Adding a Columns field turns it into a cross-tabulation.
Which Aggregation to Choose
The ten aggregation types cover most real-world analysis needs:
| Type | When to use it |
|---|---|
| Sum | Totals of numeric data: revenue, quantity, hours worked. |
| Count | Number of non-empty rows in each group, including duplicates. |
| Average | Mean value: average order value, average satisfaction score. |
| Median | Middle value. Use instead of Average when the data has extreme outliers — for example, ticket prices. The Outlier Calculator can confirm whether outliers exist. |
| Min / Max | Lowest or highest value in each group: cheapest order per region, highest score per student. |
| Count Distinct | Unique values only. If 1,000 order rows contain 400 unique customer IDs, Count = 1,000 and Count Distinct = 400. |
| % of Row Total | Each cell as a share of its row's total. Shows how a category distributes across columns. |
| % of Column Total | Each cell as a share of its column's total. Shows each row's contribution within a column. |
| % of Grand Total | Each cell as a share of the entire dataset total. Useful for contribution analysis. |
For a deeper look at how mean and median behave with skewed data, the Descriptive Statistics Calculator runs all summary statistics on a column in one pass.
Prepare Your Data
A pivot table requires data in long format (also called tidy data): one header row, one record per row, and consistent values within each column. The most common preparation mistakes and their fixes:
- Existing subtotal rows. If your spreadsheet has a "Total" row at the bottom, remove it. The pivot adds its own totals and double-counts any pre-existing ones.
- Merged cells. Merge cells in Excel fill only the top-left cell; all other positions export as blank. Unmerge before exporting (Home → Format → Unmerge Cells).
- Numbers stored as text. Currency symbols ($1,200), thousand-separator commas, or percent signs in a numeric column prevent Sum from working. Strip them out or use the CSV Data Cleaner.
- Wide-format data. If your spreadsheet already has Jan Revenue, Feb Revenue, Mar Revenue as separate columns, that is wide format. Unpivot it in Excel (Power Query → Unpivot Columns) to get one row per month before pasting here.
- Blank headers. Every column needs a unique name. Columns without headers get auto-named Column_1, Column_2, and so on.
If the data has blank or inconsistent values, use the Missing Value Checker to find which columns are affected before building the pivot.
Common Use Cases
Sales reporting. Export transactions from a CRM. Drag Region → Rows, Month → Columns, Revenue → Values (Sum). The result is a revenue matrix you can copy straight into a report. For the full distribution within any cell, the Histogram Maker can chart a column of the raw data.
Survey analysis. Drag a demographic column (Gender, Age Group) to Rows, a satisfaction category column to Columns, and a numeric score column to Values (Average). The result is an average score per demographic per satisfaction category. For count-based frequency analysis, the Frequency Table Maker handles categorical data directly.
HR headcount. One row per employee. Drag Department → Rows, Location → Columns, Employee ID → Values (Count). Each cell shows the number of employees in that department-location combination.
E-commerce analytics. Drag Category → Rows, Channel → Columns, Revenue → Values (Sum). After the pivot, check whether any two columns move together using the Correlation Calculator.
Pivot Tables vs. SUMIF Formulas
SUMIF(range, criteria, sum_range) computes one conditional sum for one criterion.
To get revenue for every region and every month, you need one SUMIF per cell — North/Jan,
North/Feb, North/Mar, South/Jan, and so on. For a 4-region × 12-month table that is 48 formulas,
each prone to range errors if the source data changes shape.
A pivot table generates the full grid in one operation and handles any number of row-column combinations
without formula maintenance. The trade-off: a SUMIF stays live when the source data updates,
while this tool requires a re-paste. For a one-off export from a database or CRM, this tool is faster.
For a dashboard that must refresh automatically, keep the formulas.
Troubleshooting
Sum shows 0 or the wrong number. The column contains text-formatted numbers. Look for currency symbols, comma separators, or percent signs. Remove them in your source data, then re-paste.
Every date is its own row. Without grouping, each distinct date value (2026-01-01, 2026-01-02, …) becomes a separate row group. Use the Date Grouping option on the date field to group by Month, Quarter, or Year.
Blank cells in the output. A blank cell means no source rows matched that row-column combination. Use the Blank value display option to show 0, dash, or N/A instead of an empty cell.
% of Row Total shows 100% in every cell. This happens when no Columns field is set. With only one column of values, every cell is 100% of its own row. Either add a Columns field, or switch to a different aggregation type.
For cells that show unexpectedly large or small values, run the source column through the Outlier Calculator to check for data entry errors or extreme values pulling the aggregate.
Beyond Totals: Visualizing the Pivot
A grouped bar chart from the Visualize tab shows whether one category dominates across columns. For a deeper look at the spread within each group — the median, quartiles, and outliers — use the Box Plot Maker on the original column data. The pivot tells you the total; the box plot tells you whether that total is driven by a handful of large transactions or a consistent pattern.
Key Takeaways
- Long-format data (one row per record) is required. Remove existing subtotals before pasting.
- Rows determines the row groups; Columns creates the cross-tabulation; Values specifies what to calculate; Filters narrows the source data.
- Use Median instead of Average when the column contains extreme values.
- Count Distinct counts unique values; use it for unique customers, unique orders, or unique IDs.
- % aggregations require at least one Columns field or the result is always 100%.
- Merged cells and text-formatted numbers are the two most common causes of broken pivot output.
- Return to all free data tools for the full analysis toolkit.
Use it for grouped data analysis.
Fastest when you have a CSV or spreadsheet export and need a summary table without setting up a full spreadsheet pivot workflow.
Pivot Table Maker — common questions
How the tool works and how to interpret pivot results.
Is the Pivot Table Maker free?+
Yes. It needs no account, install or API key.
What file formats can I use?+
Paste comma, tab, semicolon or pipe-separated text, or upload .csv, .tsv, .txt, .xlsx or .json files.
Is my data private?+
Yes. Calculations run in your browser. A shareable link encodes your data in the URL, so only share it with people who may see that data.
Why are my totals wrong?+
Usually the source already contains total or subtotal rows, which get counted twice. Remove them before pasting.