How to Put a Pivot Table in Google Sheets: Step by Step

To put a pivot table in Google Sheets, select a cell in your data, choose Insert > Pivot table, select where to place it, and use the Pivot table editor to add rows, columns, values, or filters. A pivot table summarizes a larger list—such as sales by product or expenses by month—without changing the original data.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A rectangular data range with one header row and consistent columns. For example, a sales list might have Date, Product, Region, and Amount.
At least one field to group by and, for a useful numerical summary, a column containing numbers such as quantities or sales amounts.

Before you begin, check that every column has a distinct, descriptive header and that there are no completely blank rows or columns inside the data. You can create a pivot table from text-only data too, but it will be most useful when your list contains fields to group and values to summarize.

Step-by-Step

Prepare and select the source data. Open the sheet containing your data. Make sure the first row of the range contains the field names, with one type of information per column. Click a cell inside the data to let Sheets detect the surrounding range, or drag to select the exact range, including the header row. If the sheet has other tables nearby, selecting the exact range helps prevent unrelated columns from being included.
Open the pivot table command. In the top menu, choose Insert > Pivot table. Google Sheets opens a dialog showing the proposed data range and asks where to put the pivot table. Review the range before continuing. If it is wrong, edit it to include the full dataset and its headers.
Choose where the pivot table goes. In the dialog, select New sheet to place the pivot table on a separate tab, which is usually easiest to read and keeps the source list intact. Choose Existing sheet if you want it on the current sheet, then specify the cell where the top-left corner should go. Leave clear space around that cell so the pivot table can expand. Click Create.
Add a row field. The Pivot table editor appears, usually on the right. Under Rows, click Add and choose a field such as Product or Region. The pivot table groups records by the distinct values in that column. For example, choosing Product creates a row for each product category. Use the row field options to adjust sorting or the order of the groups when those controls are available.
Add a value to summarize. Under Values, click Add and choose a numeric field, such as Amount or Quantity. Sheets typically selects a suitable summary method, but check the Summarize by setting. Choose SUM to total amounts, COUNT to count entries, or another available method that suits the data. If a sales amount field is summarized as COUNT instead of SUM, the table will show the number of records rather than total sales.
Add columns or another row grouping if useful. To compare groups across a second dimension, add a field under Columns. For instance, use Region as rows and Product as columns to compare product totals by region. You can also add a second field under Rows to create nested groups, such as Region followed by Product. Keep the layout simple at first; too many groupings can make a pivot table wide or difficult to scan.
Filter and review the result. Under Filters, click Add and select a field to limit which source records contribute to the summary. Use the filter controls to include or exclude specific values. Then check the headings, totals, and a few groups against the original list. If the summary is not what you intended, return to the editor and change the field placement or summary method. The pivot table updates as you adjust its settings.

For a concrete setup, imagine a list with Date, Product, Region, and Amount columns. Add Region under Rows and Amount under Values, summarized by SUM, to see total amount by region. Add Product under Columns to compare each product across regions. This arrangement answers a different question from putting Product under Rows, so decide what comparison you want readers to see before adding more fields.

Common Mistakes

Missing or duplicated headers: Each source column needs a useful header. Blank or repeated headings make fields difficult to identify in the editor and may lead to confusing labels. Give every column a distinct name before creating the pivot table.
Including totals in the source range: If your source list already ends with a manually calculated grand total and that row is included, the pivot table may count that total as another record. Select the actual data rows, not a separate summary row.
Mixing different kinds of data in one column: A column intended for amounts should contain numbers consistently. Text entries such as n/a, symbols typed into values, or numbers stored as text can affect how Sheets summarizes the field. Keep units and notes in separate columns.
Choosing the wrong summary method: COUNT and SUM answer different questions. COUNT counts entries; SUM adds numeric values. Check the setting in the Values section rather than assuming the default matches your goal.
Putting the pivot table over existing content: When choosing Existing sheet, leave enough room for the result to grow. A pivot table can expand as you add fields or as new category values appear, potentially occupying cells you expected to keep for other content.
Expecting new source rows to be included automatically: The pivot table uses a specified source range. If you append records outside that range, they may not appear. Review or edit the range when your data grows.

Tips

Use a separate tab for the summary. New sheet is a tidy choice when you want to preserve a clean source-data tab and share the summary without rearranging the original list.
Name the source fields for the question they answer. Labels such as Order date, Net sales, and Sales region are easier to recognize than generic names such as Date, Value, and Type.
Start with one row field and one value field. Confirm that the basic grouping and calculation are right before adding columns, nested rows, or filters. This makes mistakes easier to spot.
Use filters to focus a view, not to erase data. A pivot table filter changes which source records contribute to the displayed summary; it does not delete those records from the source sheet.
Keep the source list consistently structured. Add new records beneath the existing data using the same column layout. If the data range does not cover the added rows, update the range through the pivot table editor so the new records are included.
Make the result readable. Use clear field labels, sensible groupings, and enough space around the table. Avoid adding every available field just because it is listed in the editor.

Google Sheets pivot tables are not the same as a separate copy of the source data: they provide a summary view based on the selected range. If you need to inspect the records behind a summarized number, double-click the relevant pivot table value. Sheets can show the underlying rows in a new sheet, which is useful for checking a total or tracing an unexpected result.

Troubleshooting

The pivot table does not include some records: Open the editor and check its source data range. Expand the range to include the missing rows and columns, including the header row. Also check that the records are in the same columns as the existing data.
A field is missing from the editor: Confirm that the source range includes that column and that its header is in the first row of the range. If the range was set incorrectly, correct it and check the editor again.
Numbers are being counted instead of added: In the editor, locate the field under Values and change Summarize by to SUM if the values are truly numeric. If SUM is unavailable or produces an unexpected result, inspect the source column for text-formatted numbers, blanks, or other inconsistent entries.
The total looks too high: Check for duplicated source records, a total row included in the range, and values that should have been filtered out. Double-click a result to view the underlying records when available, then compare those records with the source list.
The pivot table overlaps other content: Move it to a new sheet or place it in a clear area. If it is on an existing sheet, the safest fix is to choose a new starting cell with room for the table to expand.
The table looks stale after adding rows: Check whether the new rows fall inside the range used by the pivot table. Update that range if needed, then verify the summary. Changes within the included source range are reflected in the pivot table; rows beyond it cannot contribute until included.

Frequently Asked Questions

Can I create a pivot table in Google Sheets for free?
Yes. Pivot tables are available in Google Sheets, including the browser-based version. You need access to a Google account and a spreadsheet containing the data you want to summarize.

Can a Google Sheets pivot table summarize text?
It can group records by text fields, such as names or regions. For a Values summary, use a suitable operation such as COUNT to count entries. SUM is for numeric values.

How do I add another field after creating the pivot table?
Click a cell in the pivot table to open its editor if it is not already visible. Under Rows, Columns, Values, or Filters, choose Add and select the field you want. The summary changes to reflect the new layout.

Will the pivot table update when I edit the source data?
Changes to records inside its source range are reflected in the pivot table. If you add records outside the defined range, edit the range in the pivot table editor to include them.

Can I make a pivot table on the same sheet as my data?
Yes. Choose Existing sheet in the creation dialog and select a starting cell with enough empty space. A new sheet is often simpler if the pivot table might grow or the source list is near the intended location.

Is the process the same in Excel?
No. This guide uses Google Sheets menus. In Excel, pivot tables are created through Excel’s Insert tab and the dialog and field-list controls differ, although the basic idea of arranging rows, columns, values, and filters is similar.

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.