How To Create A Google Sheets Pivot Table

Let me start by saying what a delight it is to create a pivot table in Google Sheets. Right away, you’ll notice how clean and simple the process feels. It’s natural. It has that signature Google je ne sais quoi.

It’s different when you create a pivot table in Excel. Which, even if you’ve done it a thousand times, feels like it was designed by a surly robot. Not a laid back, easy-going robot. One who likes to watch people suffer as they organize simple data for their boss.

Luckily, Google has made pivot tables approachable and easy to use. But, if you’re reading this article, you’re probably still not sure how to create one in Google Sheets.

So, without further ado…

Here’s how to create a Google Sheets pivot table.

Step 1 Prepare your data

Enter the data you plan on sorting into Google Sheets.

pivot table in google sheets

Step 2 Click data, pivot table

Find the pivot table option under the data menu, click it.

pivot table in google sheets

Step 3 Add Fields

A new tab will be created that contains your pivot table. Select the fields that you would like to be displayed within your pivot table.

google sheets pivot table

Step 4 Experiment With Your Fields

Now that you know how to insert your pivot table, experiment with sorting your data. The way you do this will depend on your objectives.

Google Sheets pivot table

So there you have it. That’s how you create a Google Sheets pivot table. Pretty simple, if you ask me. Check back soon for more in-depth advice on what you can do with your Google Sheets pivot tables, now that you know how to create them.

Like what you read? Give Tyler Kirwan a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.