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.

Related Videos




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.

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

The Pivot table option in Google Sheets.

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.

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.

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.

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.

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.

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.

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

Editors' Recommendations

You can use the power of ChatGPT in Google Slides now
The MagidSlides extension for Google Slides up close.

The prowess of OpenAI's ChatGPT continues to expand beyond its initial interface, most recently via a new Google Workspace app called MagicSlides that has surfaced to be a companion for building projects in Google Slides.

The app works as a Google Workspace plug-in, which you can install and then access from the Extensions option within a Google Slides presentation. It also requires you to have an OpenAI account, because you will need to have an API key to keep track of your usage. You can generate a key from your account in the View API keys section.

Read more
How to reset a Chromebook
A person sitting at an Asus Chromebook 15 and using it.

Everything used to work perfectly on your Chromebook. The speeds were quick. Your media played flawlessly. But now, you’re experiencing lag, and you can’t figure out what went wrong.

If you need to fix specific issues without completely wiping your Chromebook, we provide a separate guide on how to fix the most common Chromebook problems. However, if resetting appears to be your only solution, we'll show you how to get your Chromebook running like new.

Read more
How to watch Google’s highly anticipated AI event in Paris today
A Google search page for most popular movie of 2022 is shown falling into a vortex.

Hot on the heels of Microsoft’s event on Tuesday in which it showed off a ChatGPT-powered version of the Edge browser and Bing search engine, Google is making final preparations for its own AI event in Paris on Wednesday that’s expected to showcase its recently unveiled generative AI chatbot, Bard.

“We're reimagining how people search for, explore, and interact with information, making it more natural and intuitive than ever before to find what you need,” the web giant says in a message on its YouTube channel. “Join us to learn how we're opening up greater access to information for people everywhere, through Search, Maps, and beyond.”

Read more