⊞ Data Analysis

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.

🔒 Browser-only — data never leaves your device Free · No signup CSV, XLSX, TSV, JSON

1 Paste or Upload Data

Presets:
CSV, TSV, TXT, XLSX, JSON

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

  1. 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.
  2. 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.
  3. 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.
  4. Click Build Pivot Table. The result table appears below. Click any column header to sort it.
  5. 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:

ZoneWhat it controlsExample
RowsEach unique value becomes a row on the left side of the table. Add multiple row fields for nested grouping.Region: North, South, East, West
ColumnsEach unique value becomes a column header across the top (cross-tabulation). One field only.Month: Jan, Feb, Mar
ValuesThe numeric column(s) to aggregate. Each gets its own aggregation type.Sum of Revenue
FiltersNarrows 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:

TypeWhen to use it
SumTotals of numeric data: revenue, quantity, hours worked.
CountNumber of non-empty rows in each group, including duplicates.
AverageMean value: average order value, average satisfaction score.
MedianMiddle value. Use instead of Average when the data has extreme outliers — for example, ticket prices. The Outlier Calculator can confirm whether outliers exist.
Min / MaxLowest or highest value in each group: cheapest order per region, highest score per student.
Count DistinctUnique values only. If 1,000 order rows contain 400 unique customer IDs, Count = 1,000 and Count Distinct = 400.
% of Row TotalEach cell as a share of its row's total. Shows how a category distributes across columns.
% of Column TotalEach cell as a share of its column's total. Shows each row's contribution within a column.
% of Grand TotalEach 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.

Quick check: If the tool shows a "numbers stored as text" warning on a column you intend to Sum, look for dollar signs, commas, or spaces in the cells. Remove them in your spreadsheet and re-paste.

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.
When this tool is useful

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.

Summarizing CSV exports without ExcelSales by region and monthSurvey cross-tabsHeadcount by department and location
FAQ

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.