Create and use pivot tables
You can use pivot tables to narrow down a large data set or analyze relationships between data points.
Add and edit pivot tables
- On your computer, open Google Sheets.
- Open the spreadsheet with the data you want to put in a table.
- Select the cells with data you want to use.
- Put the data you want to use into columns. Each column is one data set.
- Each column needs a header.
- In the menu, click Data Pivot table. Click the pivot table sheet, if it’s not already open.
- Next to each category in the "Report editor" window, click Add field, then click a column to use.
- Your table has one row or column for each number in the column you use, even if the number is in more than one cell.
- Data from the columns you use for "Values" is sorted into the matching rows and columns.
- If you want to add a field to the "Values" category that calculates values based on a formula, click Calculated field and enter the formula.
- "Filters" hide data that you don't want to show in the table.
- You can change how your data is listed, sorted, summarized or filtered. Next to what you want to change, click the Down Arrow .
- To format the pivot tables, use the buttons in the toolbar.
Change or remove data
- To move a data set from one category to another, drag it to the category you want.
- To remove a data set from a category, click Remove .
- To expand the range of data used for your pivot table, click Edit range.
- The pivot table refreshes any time you change the cells it's drawn from.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.