Skip to main content

How to use pivot tables in Google Sheets

Implementing a pivot table in Google Sheets will compress the data within your spreadsheet into a custom table. As such, the tool is practical and convenient for those who want their data outlined via an easy-to-understand format.

Say you’re a student, or someone who uses Google Sheets regularly, and want to refer to an abbreviated version of all your data — look no further than the pivot table. Even if you don’t have a detailed spreadsheet, you can still utilize the feature to enhance that sheet by making it more accessible.

Difficulty

Moderate

Duration

10 minutes

What You Need

  • A computer, laptop, tablet, or phone with access to Google Sheets

Using the Pivot tables tool

Step 1: Select the data that will be added to the pivot table.

Selecting data/cells in Google Sheets in order to create a pivot table.
Image used with permission by copyright holder

Step 2: Now click the Insert tab > Pivot table.

The Pivot table option in Google Sheets.
Image used with permission by copyright holder

Step 3: Choose where you want to insert the pivot table via the New sheet and Existing sheet options. I’ve selected New sheet for this demonstration. Click the Create button once you’ve selected a location.

Choosing where to insert a pivot table in Google Sheets.
Image used with permission by copyright holder

Step 4: Google will now create a new sheet where your pivot table will be based. Conveniently, Google Sheets provides a Suggested section where they’ll do most of the work.

However, in some cases the algorithm won’t be able to suggest anything, as is the case with mine.

The suggested section for the pivot table editor in Google Sheets.
Image used with permission by copyright holder

Step 5: Don’t worry, though: You can fill in the pivot table yourself and customize it per your requirements.

There are four components that will determine what your pivot table will showcase. In this demonstration, I’ve used a variation of them.

I’ve used the Add button for Rows to insert the Month, Revenue, and Profit sections of my spreadsheet. You’ll need to use the Add button to add any specific column or row. In my case, I clicked the Add button three times for Rows to include the Month, Revenue, and Profit.

Adding Rows in Google Sheets for a pivot table.
Image used with permission by copyright holder

Step 6: Within the Values section, I chose Revenue again, in addition to adding Profit. I chose the SUM option in the Summarize by section, as well as selecting % of column in the adjacent Show as area.

On my pivot table, I can now see which month accounted for what percentage of the overall revenue and profit. With this, I can determine, for example, which months the company should pay attention to and others they can improve.

Adding the Values as section to add data into a pivot table in Google Sheets.
Image used with permission by copyright holder

Step 7: As such, if you want to insert the pivot table on the main spreadsheet, then there’s no need for the Revenue and Profits rows anymore. Remove them by clicking the X button on its section and then repeat the steps above for adding a pivot table into the main spreadsheet where the data is located.

If you have many years of revenue and profits and implement the pivot table as explained above, then you can quickly scan the table itself to see which month made the most revenue and profit instead of scouring through all the data manually to find out the answers.

As you can see via the image below, without even looking at my original data, I can determine that July had the highest revenue and profit compared to all other months.

Using a variation of different fields will allow you to see what is relevant and what isn’t, so don't worry if you don't get it right on the first go. For example, you can use the Average option in Values to calculate the average value of certain data.

With this in mind, pivot tables can prove to be an extremely useful feature of Google Sheets.

A pivot table added onto an exiting spreadsheet in Google Sheets.
Image used with permission by copyright holder

How do I update a pivot table in Google Sheets?

Step 1: You don’t need to update anything in regard to the pivot table once it’s been created and you’ve filled it in. Simply make any edits within the cells you selected to form the pivot table. Google Sheets will do the rest by updating the pivot table to implement the changes.

Step 2: For example, I will be changing the value of two of my cells to a higher revenue and profit amount. As you can see within the pivot table, it has updated the entire table alongside those two fields.

Updating a pivot table in Google Sheets.
Image used with permission by copyright holder

For more on Google Sheets, check out our guides on how to merge cells and make a graph or chart.

Editors' Recommendations

Zak Islam
Computing Writer
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
What is Google Bard? Here’s how to use this ChatGPT rival
Google Bard responses on a screen.

These days, Google is all-in on AI, and Google Bard is its flagship product. It's an AI chatbot, and it's very much meant to be a rival to the ever-popular ChatGPT.

And while it does replicate a lot of what ChatGPT does, Google has become highly invested in this space and has already made some significant updates to the tool that take it beyond what ChatGPT can do.

Read more
How to use Google SGE — try out the search generative experience for yourself
Google SGE search tool.

Google's Search Generative Experience, or SGE, is an in-development tool for finding information faster and more readily in Google search. It involves an AI summary of some of the results from your search at the top of the page, letting you get quicker access to the information you're looking for -- at least in theory.

If you're eager to try it out for yourself, here's how to use Google SGE.

Read more
How to delete a page in Google Docs
A pair of hands using a keyboard on a laptop.

There are a few reasons you might want to delete a page in Google Docs. You may decide to remove all of the content on a particular page, you might have a blank page in the middle, or you may have a lingering blank page at the end of your document.

Here, we’ll show you how to delete a page in Google Docs for each of these situations.

Read more