A Google Sheets pivot table summarizes a large data set into a compact report by grouping rows and columns and calculating totals, counts or averages. If you have ever scrolled through hundreds of sales rows trying to total them by region, a pivot table does it in a few clicks. This guide shows how to build one, tweak it and avoid the usual stumbling blocks.
Key takeaways
- Your data needs a single header row and no blank columns inside the range.
- Create the table from the Insert menu, then drag fields into Rows, Columns, Values and Filters.
- Values can be summarized by SUM, COUNT, AVERAGE and other options.
- The table refreshes automatically when the source data changes.
What a Google Sheets Pivot Table Does
A pivot table reads a table of raw records and rearranges it without altering the source. Rows might list regions, columns might list months and the cells in between hold the sum of sales for each pair. Because you choose the layout, you can answer a new question just by dragging a field somewhere else.
Pivot tables suit questions such as “How much did each salesperson sell per quarter?” or “How many support tickets arrived per category?” For one-off lookups, a formula like VLOOKUP is lighter, but for grouped summaries a pivot table is the right tool.
Prepare Your Data First
Clean source data saves frustration later. Check these points before you start.
- Every column has a unique header in the first row.
- There are no completely blank rows or columns inside the data.
- Each column holds one kind of value: dates in one column, numbers in another.
- Numbers are stored as numbers and not as text, otherwise they are counted rather than summed.
- Avoid merged cells in the data range.

How to Create a Pivot Table in Google Sheets
The wording of menus can change, but the process at the time of writing is as follows.
- Click any cell in your data, or select the whole range including headers.
- Open the Insert menu and choose Pivot table.
- In the dialog, confirm the data range and choose whether to place the table on a new sheet or an existing one. A new sheet is the tidiest choice.
- Click Create. A blank table and a side panel called the pivot table editor appear.
- Next to Rows, click Add and choose a field such as Region.
- Next to Values, click Add, choose a numeric field such as Amount and set “Summarize by” to SUM.
- Optionally add a field under Columns, such as Month, to build a cross-tab.
Google also describes this process on its pivot table help page, and the editor sometimes offers suggested pivot tables you can click to insert.
Understand the Editor Panel
| Section | What it controls |
|---|---|
| Rows | Categories listed down the left side. |
| Columns | Categories listed across the top. |
| Values | The numbers to calculate, with a choice of summary function. |
| Filters | Conditions that limit which source rows are included. |
Customize Values and Display
Under each value field, “Summarize by” offers options such as SUM, COUNTA, AVERAGE, MAX and MIN. The “Show as” option can display each number as a percentage of the row, column or grand total, useful for share-of-sales reports. You can add the same field twice, once as a sum and once as a count, to see both side by side.
Under Rows and Columns you can change sort order, show or hide totals and sort by a value instead of by label. Use the Filters section to include only certain categories, for example a single year.
Group Dates and Add Calculated Fields
If your rows hold a date column, right-click a date value in the pivot table and look for the option to create a pivot date group. This lets you roll daily records up to months, quarters or years. The editor also provides a calculated field option under Values, where you write a formula such as =Revenue - Cost that works across the whole table.

Fix Common Pivot Table Problems
- Values are counted, not summed. The source cells are probably text. Convert them to numbers and change “Summarize by” back to SUM.
- New rows do not appear. Edit the data range in the editor and extend it, or use a whole-column range such as
A1:F. - Blank headings. Every source column needs a header; fill in missing ones.
- Cannot type inside the table. Pivot tables are generated output. Add formulas next to the table or edit the source data.
To pull a specific subset of rows before summarizing them, try the FILTER function. If you also work in Microsoft’s spreadsheet, our Google Sheets vs Excel comparison explains how pivot features line up.
Frequently Asked Questions
Does the pivot table update automatically?
Yes. When the data inside the source range changes, the pivot table recalculates. If rows are added outside the range, extend the range in the editor.
Can I build a pivot table from several sheets?
Not directly. Combine the data into one range first, for example with the query or array features, then build the table from that range.
How do I sort a pivot table?
Use the Order and Sort by settings under a row or column field in the editor.
Can I turn a pivot table into a chart?
Yes. Select the pivot table and use the Insert menu to add a chart, which stays linked to the table.
Is a pivot table the same as a filter?
No. A filter hides rows in existing data. A pivot table builds a new summarized view while leaving the source untouched.
Wrap-Up
Prepare tidy data, drag fields into Rows and Values and let the table do the arithmetic. Once you have built your first Google Sheets pivot table, you will find yourself reaching for it whenever a spreadsheet gets long.



