Create & use pivot tables

Want advanced Google Workspace features for your business?

Try Google Workspace today!

You can use pivot tables to:

Narrow down a large data set.
See relationships between data points .

For example, you could use a pivot table to analyze which salesperson produced the most revenue for a specific month.

To use pivot tables, go to sheets.google.com on a computer.

Customize a pivot table
GETPIVOTDATA function

To learn about Spreadsheets, Databases, and Query Languages, click the button below:

Tutorial: Intro to Spreadsheets, Databases, and Query Languages

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu

Create & use pivot tables

Related articles

Need more help?

Try these next steps: