How to Create a Pivot Table in Google Sheets (2026)
A pivot table summarizes a large table into a compact report — totals by category, counts by month, averages by group — without writing a single formula. Here’s how to build one in Google Sheets and shape it.
1. Prepare Your Data
Pivot tables work best on clean, tabular data:
- One header row at the top, with a clear name for each column.
- No blank columns or rows inside the data.
- Each column holds one type of value (dates, numbers, or text).
2. Insert the Pivot Table
- Select your data range, including the headers (or click any cell inside the data).
- Go to Insert > Pivot table.
- Choose where to put it — New sheet (recommended) or Existing sheet.
- Click Create.
An empty pivot table appears with the Pivot table editor panel on the right.
3. Add Rows, Columns, and Values
The editor has four areas:
- Rows — the categories to group down the left (e.g., Region, Salesperson).
- Columns — categories to spread across the top (e.g., Month).
- Values — what to calculate (e.g., Revenue summed).
- Filters — limit which rows are included.
Click Add next to each area and pick a field. For example, add Region to Rows and Revenue to Values to get total revenue per region.
Tip: Use Suggested at the top of the editor for one-click common summaries.
4. Change How Values Are Summarized
By default, numbers are summed and text is counted. To change it:
- In the Values section, click the Summarize by dropdown.
- Choose SUM, COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN, and more.
Use Show as to display values as a % of total, % of row, or % of column instead of raw numbers.
5. Filter and Sort
- Filters: Add a field to the Filters area, then choose which values to include or set a condition.
- Sort: Under Rows, use Order (ascending/descending) and Sort by to rank by a value column — e.g., sort regions by total revenue, highest first.
6. Add a Calculated Field
To create a metric that isn’t in your data (e.g., profit margin):
- In the Values section, click Add > Calculated field.
- Enter a formula referencing your column names, e.g.
=Profit / Revenue. - Set Summarize by to Custom.
7. Refresh When Data Changes
Pivot tables update automatically when you edit data inside the original range. If you add new rows below the range, the pivot table won’t include them until you fix the source range:
- Click any cell in the pivot table.
- In the editor, find the data range at the top and update it (or re-select a wider range).
Tip: Reference a whole column (e.g.,
A:D) as the source so new rows are picked up automatically.
8. Troubleshooting
New data isn’t showing up
The source range doesn’t include the new rows. Update the range in the editor, or use full-column references.
”Summarize by” only shows COUNT
The field is being read as text. Make sure number columns contain real numbers, not numbers stored as text (left-aligned values are usually text).
The pivot table is empty
You’ve added fields to Rows/Columns but nothing to Values — add a field to Values to see calculations.
Related Google Sheets guides: How to use VLOOKUP · How to use the QUERY function · How to remove duplicates · How to use conditional formatting · How to use the IF function
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or explore our free tools
