A pivot table is a tool that allows you to quickly summarize and analyze data in your spreadsheet. You can use a pivot table when: You want to arrange and summarize your data. The data in your spreadsheet is too large and complex to analyze in its original format.