How to Create a Pivot Table in Google Sheets
Pivot tables summarize large datasets by grouping and aggregating data. They are essential for data analysis and reporting.
Select Your Data
Highlight the data range you want to analyze. Include header rows for better pivot table configuration.
Insert the Pivot Table
Go to Insert > Pivot table. Choose whether to place it in a new sheet or existing sheet.
💡 A new sheet keeps your raw data and pivot table organized separately.
Set Up Rows and Columns
In the Pivot table editor, drag fields to Rows and Columns to define your table structure.
Add Values to Aggregate
Drag numeric fields to Values. Choose aggregation type: SUM, COUNT, AVERAGE, MAX, MIN, or custom formulas.
Add Filters
Drag fields to Filters to limit data shown in the pivot table. Filters can be date ranges, categories, or any field.
Try These Templates
Frequently Asked Questions
Does the pivot table update when source data changes?
Yes. Pivot tables refresh when source data changes. Click Refresh in the pivot table editor to force an update.
Can I create a pivot table from multiple sheets?
Use IMPORTRANGE or QUERY to combine data from multiple sheets before creating a pivot table.