How to Make a Pivot Table in Google Sheets
In Google Sheets, select your data, choose Insert > Pivot table, then use the editor on the right to add Rows, Columns, Values, and Filters. It summarizes thousands of rows into a clear report without a single formula. Here is the full walkthrough.
Pivot tables in Google Sheets work much like Excel's, but the editor lives in a side panel and updates live as you build. If you can drag a field name, you can build a report — totals, counts, and averages, with no formulas. This guide uses a sales list, but the steps fit any tidy data.
Step 1: Select your data and insert the pivot table
- Select the range you want to summarize, including the header row.
- Click Insert > Pivot table.
- Choose New sheet (recommended) and click Create.
- An empty pivot table appears with the Pivot table editor on the right.
Step 2: Add Rows, Columns, and Values
In the editor, click Add next to each area and pick a field. This is where your report takes shape.
| Area | What it does |
|---|---|
| Rows | Groups your data down the left |
| Columns | Groups your data across the top |
| Values | The number that gets calculated (Sum, Count, Average...) |
| Filters | Limits which data the whole report uses |
Add Product to Rows and Sales to Values to get total sales per product. Add Region to Columns and you get a grid of products by region. Google Sheets also shows a Suggested section that can build a common report for you in one click.
Step 3: Change how values are calculated
In the Values area, use the "Summarize by" dropdown to switch between SUM, COUNT, COUNTA, AVERAGE, MAX, and MIN. The "Show as" option can display each result as a percentage of the row, column, or grand total — handy for share-of-sales reports.
Group by month or year
If your Rows field is a date, right-click any date in the pivot table and choose "Create pivot date group" to roll daily rows up into months, quarters, or years. It is the fastest way to turn a long transaction log into a monthly summary — no helper columns needed.
Filter the report
Add a field to the Filters area to limit the whole report — for example, filter Region to show only "North", or filter Status to hide cancelled orders. Filters change what the pivot table summarizes without touching your source data.
Common issues
- Empty pivot table — you have not added fields yet; add at least one to Rows and one to Values.
- New rows not showing — they fell outside the source range; use whole-column ranges like A:D.
- Wrong totals — a number column may contain text; clean it so every value is a real number.
Coming from Microsoft's tool? The concept is identical — compare the steps with how to make a pivot table in Excel. Turn your summary into a visual with a chart in Google Sheets, or deciding between the two apps entirely? Read our Excel vs Google Sheets comparison.
Frequently asked questions
Why is my Google Sheets pivot table empty?
You have inserted it but not added any fields yet. Use the Pivot table editor on the right to add at least one field to Rows and one to Values, and the report will populate.
Do Google Sheets pivot tables update automatically?
Yes, they refresh on their own when the source data changes — provided the new data is within the range you selected. Using whole-column ranges keeps future rows included automatically.
How do I group dates by month in a Google Sheets pivot table?
Right-click any date inside the pivot table and choose "Create pivot date group", then pick month, quarter, or year. Google Sheets rolls the daily rows up into that period without any helper columns.
Can I show values as a percentage in a pivot table?
Yes. In the Values area, open the "Show as" dropdown and choose a percentage of the row, column, or grand total. It is the quickest way to build a share-of-total report.