How to make your first pivot table To start, navigate to Google Sheets and open the spreadsheet you want to work on. This example uses a coin collection because that's more interesting than ...

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

You can create pivot tables in Google Sheets manually or automatically and sort your spreadsheet's data by rows, columns, values, and filters.

Let’s get started. How to create a Pivot Table in Google Sheets? Google Sheets allows you to create a pivot table for some raw data that you’ve already entered into the spreadsheet.