How to Create a Pivot Table in Google Spreadsheets

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.

Comments (9) Write a comment

  1. 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.



    • Hi Alicia,

      In the Report Editor, do you have the option to ‘Update table on each change’ selected?


      • Correct, but the range for the Pivot Table does not automatically update when the data table is updated with more rows.


  2. Hi Gooru,

    Is there a way to do a side by side chart, with 2 x y-axis in a Google spreadsheet?


  3. 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,



  4. 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.


  5. 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?


    • You can use the IMPORTRANGE function to pull data from multiple sheets into one sheet.


Leave a Reply

Required fields are marked *.