Does Google Sheets Have Pivot Tables? How to Use Them

Yes. Google Sheets has pivot tables, which let you summarize and reorganize rows of data without changing the original table. In a web browser, choose Insert > Pivot table, select a data range, and use the Pivot table editor to decide how to group and summarize it.

What a pivot table does

A pivot table turns a detailed list into a compact summary. Instead of manually adding up every transaction or counting every response, you assign fields from the source data to rows, columns, values, or filters. Sheets then groups records and calculates a result for each group.

For example, a sales list might have columns for Date, Region, Product, and Amount. A pivot table can show total sales by region, put product categories across the columns, or count how many orders came from each region. The same underlying records can answer different questions by rearranging the fields.

A pivot table is a report, not a replacement for the source data. It does not normally rewrite or delete the rows it summarizes. You can keep the raw list on one sheet and place the pivot table on another, making it easier to review the summary alongside the original records.

Prepare your data first

Pivot tables work best when the source is a simple rectangular table: one header row followed by one record per row. Each column should represent one kind of information, such as date, department, or amount. Avoid merged cells, blank header cells, and subtotal rows embedded among the records; these can make fields confusing or cause the summary to include unintended values.

Before creating the pivot, check that:

Every column has a unique, descriptive header, such as “Order date” or “Net sales.”
Values in a column use a consistent type. Dates should be dates, and amounts should be numbers rather than numbers stored as text.
There are no completely blank rows splitting the data range.
The range includes all records you want summarized, but not unrelated notes or totals.

One row should describe one record. If a sales table has a single row per order, for instance, the order’s region, product, and amount should each appear in their own columns. This structure makes it possible to group or filter the same records in several useful ways.

Create a pivot table in Google Sheets

In Google Sheets in a web browser, click a cell in the source data or select the range, then choose Insert > Pivot table. Confirm the data range in the dialog, choose whether to place the pivot table in a new sheet or an existing sheet, and click Create. Sheets opens a Pivot table editor, usually at the right of the page.

Under Rows, click Add and select a field to form the row groups, such as Region.
Under Values, click Add and choose a field to calculate, such as Amount.
Check the value’s summary method. For numeric amounts, SUM is often appropriate; for other questions, options such as COUNT or AVERAGE may be more useful.
Optionally add a field under Columns to split each row group into categories, or under Filters to restrict which source records are included.

The editor’s field names come from the source headers. If the wrong range or header row was selected, cancel or adjust the source data and create the pivot again. To edit an existing pivot, click inside it; the editor appears so you can add, remove, or rearrange fields.

Choose rows, columns, values, and filters

Each part of the editor answers a different question. Rows creates the groups listed down the side. Columns adds a second dimension across the top. Values calculates a result for each intersection, and Filters limits the records used to produce the results.

Suppose the source has Region, Product, and Amount. Putting Region in Rows and Amount in Values gives a total for each region. Adding Product in Columns changes the report into a region-by-product comparison. Adding a year or salesperson as a filter lets a reader focus on a subset without deleting any source records.

For a value field, Sheets may offer different ways to summarize it, including sum, count, and average. The best choice depends on the question and on the data type. Summing a quantity can answer “How many units?” while counting a field can answer “How many records?” Averages are useful for measures such as order value, but an average of transaction averages is not necessarily the same as the average across all underlying items.

Pivot tables can also be sorted and filtered to make a report easier to scan. The exact controls available depend on the field and the current pivot configuration. If a result looks unexpected, first verify the selected summary method and the source values rather than assuming the pivot has calculated a different kind of total.

A practical example

Imagine a store keeps a list of orders with columns for Order date, Region, Product, and Sales. The manager wants to compare product revenue between regions. Add Region to Rows, Product to Columns, and Sales to Values, then set the Sales summary to SUM. The resulting table shows a total for each region-product combination, with row and column totals where applicable.

If the manager instead wants the average order amount by region, remove Product from Columns if it is not needed and change the Sales summary from SUM to AVERAGE. To look at one region or a particular reporting period, use a filter field. The original order list remains available, so the summary can be checked against individual records when a number needs explaining.

This example also shows why the layout matters: the source table stays the same, while the questions change through the arrangement of fields. A pivot table is especially handy for exploratory analysis, when someone needs to compare several groupings without building a separate formula-based report for every possibility.

Do pivot tables update automatically?

Google Sheets recalculates a pivot table when relevant cells in its source data change. However, the pivot’s source range is important. If the range used when creating the table ends at row 500, adding new records below that boundary may leave those records out. Check the source range when new rows do not appear, and adjust the range or create the pivot from a range that includes the intended data.

It is also sensible to keep new records within the source range and preserve the same column headers. Inserting a total row into the middle of the raw data can distort the summary by treating that total as another record. Keep totals in the pivot output or outside the source table instead.

Pivot output can expand as new categories appear, so leave room around it. If there is existing content where the pivot needs to place additional rows or columns, the report may not be able to expand as expected. A dedicated sheet is often a simple way to avoid collisions and keep the raw data separate from its summary.

Common problems and how to fix them

The total is zero or too small: Check whether the source amounts are real numbers rather than text, and confirm that the chosen data range contains every record.
There is no useful field name in the editor: Make sure the first row of the selected range contains headers and that none of the header cells are blank.
The pivot includes an unexpected category: Look for extra spaces, inconsistent spelling, or mixed formats in the source field. “North” and “North ” may be treated as different text values.
New records are missing: Review the source range to see whether it extends far enough to include them.
The report is hard to read: Remove unnecessary dimensions, use a clear value summary, and place the pivot on a separate sheet if it is crowded by other content.

A pivot table reflects the quality of its input. If a column mixes dates, text, and numbers, or if category labels are inconsistent, its groups and calculations may be confusing. Correcting the source list is usually more reliable than trying to hide data-quality problems in the report.

Google Sheets pivot tables versus Excel

Both Google Sheets and Microsoft Excel include pivot tables, and the core idea is the same: choose fields to group records and summarize values. The interfaces differ. In Sheets, the browser workflow begins with Insert > Pivot table and uses the Pivot table editor. Excel for Microsoft 365 on Windows has its own PivotTable tools and ribbon interface, so instructions and menu names for one product should not be assumed to match the other.

Sheets has an advantage for shared, browser-based spreadsheets: collaborators with access can work in the same file, and the pivot can be viewed alongside live source data. Excel may be a better fit for a workflow built around Excel-specific features, a large workbook, or an organization’s established desktop reporting process. Which is preferable depends on the dataset, collaboration needs, and the tools the people maintaining the report already use.

A Google Sheets pivot table is not an Excel PivotTable file merely because the features are similar. When moving data between applications, review the result in the destination program; layout, formatting, and some behaviors may not transfer exactly.

Privacy and sharing considerations

A pivot table does not create a separate privacy boundary around the source records. People who can access the spreadsheet may be able to see other sheets or underlying information depending on the file’s sharing permissions. A summary that hides details from view should not be treated as a secure way to conceal them.

Before sharing a report, review who has access to the spreadsheet and whether they should see the raw data. If recipients need only a summary, consider creating a separate file containing only the information they are permitted to receive, then set its sharing permissions appropriately. Also remember that pivot results can reveal sensitive patterns even when individual records are not displayed.

When to use an alternative

A pivot table is a strong choice for interactive grouping and quick summaries, but it is not the only option. A chart can communicate a small number of comparisons more clearly, while a filter view can help someone inspect records without building an aggregate report. Functions such as SUMIF or COUNTIF can produce a fixed calculation in a cell, but require formulas and may be less convenient when readers need to rearrange categories.

Choose a pivot table when the question involves grouping many records across one or more dimensions, or when you expect to explore different summaries. Use a chart when the main goal is visual communication. Use a straightforward formula when the report needs a fixed result in a particular location or must feed another calculation. These approaches can also be combined: a pivot table can provide the summary data for a chart.

Frequently Asked Questions

Are pivot tables free in Google Sheets?
Google Sheets includes pivot tables as a spreadsheet feature. Access to a particular Google account or organization’s services can depend on its account and administrator settings, but creating a basic pivot table does not require a separate pivot-table add-on.

Can Google Sheets make a pivot table from multiple sheets?
A standard pivot table is built from a selected data range. If records are split across sheets, first bring them into one consistent table or otherwise create a suitable combined range, then use that range as the pivot’s source. Make sure the combined data has matching columns and one header row.

Can I add a calculated field to a Google Sheets pivot table?
Yes. The Pivot table editor includes an option to add a calculated field under Values. It can calculate from source fields, but it is different from adding a new calculated column to the original data. Check the field references and resulting totals carefully to confirm the calculation fits the question.

Why is my pivot table not showing new rows?
The source range may not include the added rows. Click the pivot table and inspect the range shown in its editor; expand it to cover the new records if needed. Also verify that new entries use the same column structure and headers as the existing source table.

Can I edit the original data from a pivot table?
A pivot table summarizes source records; it is not a direct editing view of those records. Make changes in the source data, then use the pivot to review the updated summary. This separation helps preserve the distinction between detailed records and their aggregated report.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.