Google Sheets pivot table: A step-by-step guide

Overview

A pivot table reorganizes a large flat spreadsheet into a compact summary so you can answer questions like how much each client was billed per project without writing formulas. You build one by selecting your data, opening the Insert menu, and choosing Pivot table, then placing fields into Rows, Columns, Values, and Filters. Google Sheets now lets Gemini, its built-in AI, create the table from a plain-language request, turning several manual steps into one sentence for non-technical users.

Key Takeaways

A pivot table adds a third dimension to your data, letting you cross-tabulate one field against another (for example, clients against project types) and see totals at a glance.
Manual setup follows four steps: select your data with headers, open Insert then Pivot table, pick a location, and configure the editor panel.
The editor panel has four sections, Rows, Columns, Values, and Filters, that control how your summary is laid out.
Gemini, the AI built into Google Sheets, builds a pivot table from a typed request and writes a short summary explaining how it organized your data.
Edits to existing cells update the pivot table automatically, but adding new rows requires you to extend the data range by hand.
A single pivot table reads from one worksheet only, so combine multi-sheet data into one source first.

Stats & Key Facts

#4 configurable sections in the Pivot table editor: Rows, Columns, Values, and Filters
#1 worksheet is the maximum source for a single pivot table, so multi-sheet data must be consolidated first
#1 sentence to Gemini replaces the multiple manual steps needed to build a table by hand
#9,000+ apps connect to Google Sheets through Zapier for automatic data pulls

What a pivot table does for business data

A pivot table turns a wall of raw rows into a readable summary.

Most spreadsheets show data in flat two-axis form: rows of records and columns of fields. That view works until the dataset grows large and you need to summarize it. A pivot table reorganizes the same data to show totals across categories, such as how many units each sales rep sold per product.

The benefit is a third dimension of analysis. Instead of one long list, you get a grid where one field runs down the side, another runs across the top, and the numbers in the middle are automatically totaled. You reach this without writing a single formula.

Building a pivot table by hand in four steps

The manual path is short and repeatable once you know the menu.

›Select your full dataset, including the column headers; every column needs a header to continue.
›Open the Insert menu and choose Pivot table.
›Decide whether to place the table in a new sheet or the existing one, then click Create.
›Use the Pivot table editor panel that appears to add your fields.

Rows, Columns, Values, and Filters explained

These four sections of the editor control the entire layout.

›Rows: the field you list down the left side, such as client names.
›Columns: the field you spread across the top, such as project types.
›Values: the numbers to aggregate, using a function like SUM for billing amounts.
›Filters: a rule that limits which records are included, such as showing only the year 2025.

Using Gemini AI to create a pivot table from a sentence

Google Sheets includes Gemini, its AI assistant, for hands-off setup.

Rather than dragging fields into the editor, you describe the question you want answered in plain language. In the article's example, a user asked Gemini to create a pivot table showing billing data by client and project type, and the AI built it.

Gemini also generates a short written summary of how it used your data to construct the table. For a business owner who does not know spreadsheet mechanics, this turns a multi-step task into a single typed request, which is the approach the guide recommends for non-technical users.

Keeping a pivot table up to date

Pivot tables refresh in two different ways depending on the change.

›Editing values inside cells already in your data range updates the pivot table automatically.
›Adding brand new rows does not update the table on its own; you extend coverage with the Select data range icon in the editor.

Limits to know before you start

A few boundaries shape how you prepare your source data.

Each pivot table reads from only one worksheet. If your numbers live across several tabs, combine them into a single source sheet before you build the table.

You can keep several pivot tables in the same sheet, but Google Sheets does not merge two existing pivot tables. To combine them you bring the original data together and recreate the table from that single source.

Pulling data in automatically with Zapier

Connecting outside sources reduces manual copy-and-paste.

The guide notes that Zapier connects Google Sheets to more than 9,000 apps, so the rows feeding your pivot table can flow in from other tools without manual entry. It also mentions Zapier's MCP integration, which lets you request data updates from an AI assistant inside a chat window. For a small business, this means the underlying spreadsheet stays current so the summary stays accurate.

Frequently Asked Questions

What is a pivot table in Google Sheets?

It is a tool that reorganizes a large flat spreadsheet into a compact summary, totaling one field against another. For example, it can show total amount billed for each client broken down by project type without any formulas.

Can the AI in Google Sheets build a pivot table for me?

Yes. Gemini, the AI built into Google Sheets, creates a pivot table from a plain-language request and writes a short summary of how it organized your data, replacing the multiple manual steps with one sentence.

Why isn't my pivot table showing new rows I added?

Pivot tables update automatically when you change cells already inside the data range, but new rows fall outside that range. Extend the range using the Select data range icon in the Pivot table editor.

Can one pivot table pull from several sheets at once?

No. A single pivot table references only one worksheet. To analyze data spread across tabs, consolidate it into one source sheet first, then build the pivot table from that.

What are the four sections of the pivot table editor?

They are Rows, Columns, Values, and Filters. Rows list a field down the left, Columns spread a field across the top, Values aggregate numbers with a function like SUM, and Filters limit which records are included.

Pivot tables give non-technical business owners a fast way to summarize large datasets, and with Gemini built into Google Sheets, a single typed question now does the work that once took several manual steps.