Pivot Tables in Google Sheets: Turn Raw Data into Insights

A pivot table is the fastest way to answer questions like "what were sales by region by month?" without writing a single formula. If you have ever built a wall of SUMIFS to summarize a dataset, pivot tables will feel like a superpower. Here is a complete walkthrough for Google Sheets.

Set up your data first

Pivot tables want flat, tidy data: one header row, one record per row, no merged cells, no blank columns. If your data has subtotal rows sprinkled through it, remove them — the pivot table will do the subtotaling for you.

Create the pivot table

Select your data range (or just click a single cell inside it).
Go to Insert > Pivot table.
Choose "New sheet" — keeping pivots on their own tab keeps things tidy.

You will see an empty grid and the pivot table editor on the right with four buckets: Rows, Columns, Values, and Filters.

The four buckets, in plain English

Rows — what you want to break down by (region, product, salesperson).
Columns — a second breakdown across the top (months, years).
Values — the number being summarized (revenue, quantity), plus how: SUM, COUNT, AVERAGE, MAX.
Filters — limit the whole table (only 2026, only the West region).

For "sales by region by month": drag Region to Rows, Order Date to Columns, and Revenue to Values. Done — thousands of rows collapse into a readable summary.

Three features people miss

1. Date grouping

Right-click a date in the pivot table and choose Create pivot date group to roll daily data up to months, quarters, or years. No helper columns needed.

2. Calculated fields

In Values, choose Calculated Field to add a formula like =Revenue-Cost. It computes per-row and then summarizes, which is usually what you want for margins.

3. Show as percentage

Any value can be displayed as "% of grand total" or "% of row" — perfect for share-of-business questions without extra math.

Common traps

New rows not showing up? Your source range was fixed. Edit the range to cover the whole columns (e.g. A:F) so new data flows in.
COUNT instead of SUM? Your numeric column contains text somewhere — find and fix the offending cells.
Blank category rows? Filter them out, or better, fill in the source data.

Once pivots click, you will stop building summary formulas by hand. Ten minutes of practice with your own data is all it takes.