Pivot tables help you summarize and analyze large datasets by displaying the information in more digestible formats. They make it much easier to take out small pieces of information and conclusion from a large set of information.

  • To create a pivot table in a Google Spreadsheet, first select all of your data.
  • Then go to “data” on the top menu
  • Select “Pivot Table Report”

  •  Once you click on “Pivot Table Report,” you will be led to a new page on your Google Spreadsheet with your Pivot Table
  • On the right side of your screen, you can determine the rows, columns, values, and filters for your pivot table
  • Once you set your values, you can also create a chart out of your data
  • To create a chart, click on “insert chart” on the top navigation menu.


The #1 resource for Google Apps how-to videos. Follow The Gooru to keep up to date on the latest Google Apps features, news, updates and more! You can also check out The Gooru's library of Google Drive Training videos and Gmail Training videos!



  1. Alicia

    Hi there Google Gooru,

    I created a Pivot Table but the data for that Pivot Table is updated on a daily basis.

    Is there a way for the data range of the Pivot Table to automatically update? Currently I have to manually update the range in order for the Pivot Table to be accurate.


  2. Finn

    Great site!

    I’m creating a google spreadsheet pivot chart –and trying to remove the grand totals.
    I have data label called “priority 1” in “rows” and the same in “values” so i can count each unique text and count the number of times one appears, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off.

    Thank you,


  3. zack

    Hi, previously i am using excel and do my pivot table from excel. How do i open my excel file in google spreadsheet and do the pivot table. I have tried open but unable to do the pivot table. Please help.

  4. B.Baker

    I collect data for 500+ students. Each quarter I need to add another score so that by the end of the year I have all 4 scores for each student. each quarter I add the new data sheet to the workbook. At the end of the year I have to look on 4 different workbook pages to see a students scores to check progress. I would love to have all scores on one workbook page. Is this possible?

  5. Pingback: The Gooru Case Study: Stumptown Coffee | The Gooru

Leave a Reply

Your email address will not be published. Required fields are marked *