How do I add a pivot table to a Google Sheets spreadsheet?
If you are looking to analyze and summarize large amounts of data in a Google Sheets spreadsheet, a pivot table can be a great tool to use. Pivot tables allow you to quickly and easily summarize data, calculate averages, and compare different data points. With a pivot table, you can quickly identify trends and patterns in your data that may not be immediately obvious. Knowing how to add a pivot table to a Google Sheets spreadsheet can help you make better decisions and gain valuable insights from your data.
Grace Everwood
|
12 steps
|
28 seconds
Google Account
1
Go to [https://sheets.google.com](https://sheets.google.com) and open the spreadsheet you want to add a pivot table to.
2
Click the “Data” tab at the top of the page.
3
Click the “Pivot Table” button.
4
Select the range of cells you want to include in the pivot table.
5
Click the “Create” button.
6
Select the columns you want to include in the pivot table.
7
Click the “Add” button to add the columns to the pivot table.
8
Click the “Rows” field and select the rows you want to include in the pivot table.
9
Click the “Values” field and select the values you want to include in the pivot table.
10
Click the “Filter” field and select the filters you want to apply to the pivot table.
11
Click the “Options” button to customize the pivot table.
12
Click the “Save” button to save the pivot table.