Learn how to create a pivot table in Google Sheets. A pivot table is a statistical tool that allows you to summarize or aggregate data sets.

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.

Select New sheet to make a cleaner presentation. When you select Existing Sheet, specify the cell you want to be the upper-left cell of your pivot table. Click Create.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.