May 26, 2026

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.

Ready to automate your busywork?

Carly schedules, researches, and briefs you—so you can focus on what matters.

See what people say

"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.

Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.

On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."

Gus Ibrahim, Founder & Director, IHR