Clear search
Close search
Google apps
Main menu

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

  1. On your computer, open Google Sheets.
  2. Open the spreadsheet with the data you want to put in a table.
  3. 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.
  4. In the menu, click Data and then Pivot table. Click the pivot table sheet, if it’s not already open.
  5. 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.
  6. You can change how your data is listed, sorted, summarized or filtered. Next to what you want to change, click the Down Arrow Down Arrow.
  7. 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 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.

Was this article helpful?
How can we improve it?