# What is a pivot table in Google Sheets or Excel? > A pivot table summarizes a long sheet into totals by group, like spending by category, without formulas. Where to find it in Google Sheets and Excel. Source: https://learn.ynteractive.com/content/glossary/pivot-table · Updated 2026-10-06 · Free from Stepthrough (https://learn.ynteractive.com) [Data, Sheets and Gmail](https://learn.ynteractive.com/content/glossary#topic-data-sheets-and-gmail) · [AI glossary](https://learn.ynteractive.com/content/glossary) Quick answer A pivot table is a spreadsheet tool that summarizes a long list of rows into a compact table of totals, counts or averages grouped by the values in a column, such as total spending per category or per vendor. You build it by choosing fields, not by writing formulas. Last updated October 6, 2026 Updated October 6, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about) ## Why it matters for a small business Lists grow fast. A sheet with hundreds of expenses, leads or tickets is hard to read row by row, but most questions about it are simple: how much per category, how many per month, which vendor costs the most. A pivot table answers those in a few clicks and updates when you refresh it. In Google Sheets you find it under Insert, then Pivot table. In Excel it is Insert, then PivotTable. Both ask for a data range, then let you pick rows, columns and values, like Category as rows and the sum of Amount as values. The data needs a clean [header row](https://learn.ynteractive.com/content/glossary/header-row) and consistent entries, or the groups split apart. ## In a real lesson: AI Receipt Extractor: Receipts to Google Sheets with n8n The [AI Receipt Extractor lesson](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) builds the kind of sheet a pivot table loves. An n8n agent reads a receipt photo and adds a row to a Google Sheet named Invoices, with four columns: Date, Category, Vendor and Amount. The test receipt becomes a row for groceries at Corner Mart. The [AI Expense Categorizer Agent lesson](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets) does something similar for Maple Street Bookkeeping, a made-up firm. Its Expense Log sheet has Date, Vendor, Amount, Category and Note, and the agent must pick from a fixed list such as Office Supplies, Meals or Needs Review. Neither lesson builds a pivot table. But once those sheets fill up, one pivot table with Category as rows and the sum of Amount as values shows spending by category. The fixed list matters: the finance agent's categories group cleanly, while free-form categories may split into near-duplicates. The [spreadsheet formula helper prompt](https://learn.ynteractive.com/content/prompts/spreadsheet-formula-helper-prompt) helps when you need a formula instead. [Try this lesson free](https://learn.ynteractive.com/modules/receipt-extractor) or [read the step-by-step guide](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets). ## Common confusions ### Pivot table vs filter A filter hides rows so you see only some of them. A pivot table summarizes rows into totals by group. You can use both, for example filtering a pivot table to one month. ### Pivot table vs chart A pivot table produces numbers in a grid. A chart draws a picture. Many people build a pivot table first, then chart its totals. ## Tips - Keep raw data on its own tab and put the pivot table on a separate one. - Make categories consistent first, using a fixed list like the finance agent's, so totals do not split. - Check one total by hand the first time to confirm the pivot table covers the full data range. ## Related terms [Google Sheets (as an automation database)](https://learn.ynteractive.com/content/glossary/google-sheets) · [Header row](https://learn.ynteractive.com/content/glossary/header-row) · [Expense categorization](https://learn.ynteractive.com/content/glossary/expense-categorization) · [Budget variance](https://learn.ynteractive.com/content/glossary/budget-variance) · [Cash flow forecast](https://learn.ynteractive.com/content/glossary/cash-flow-forecast) · [CSV](https://learn.ynteractive.com/content/glossary/csv) ## More Data, Sheets and Gmail terms [Plain-text email](https://learn.ynteractive.com/content/glossary/plain-text-email) · [Append row](https://learn.ynteractive.com/content/glossary/append-row) · [Email thread](https://learn.ynteractive.com/content/glossary/email-thread) · [Field mapping](https://learn.ynteractive.com/content/glossary/field-mapping) ## Where you use it: free lessons - [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) (n8n, 12 min) - [Build an AI Agent That Categorizes Business Expenses](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets) (n8n, 12 min) - [Analyze a Spreadsheet with ChatGPT: Upload a CSV, Get a Chart and Three Takeaways](https://learn.ynteractive.com/content/chatgpt-analyze-spreadsheet-csv) (ChatGPT, 10 min) - [An AI Resume Screener, with a Fairness Step (Recruiting & HR)](https://learn.ynteractive.com/content/ai-resume-screener-n8n-fairness) (n8n, 14 min) ## Prompt templates that use it [Spreadsheet formula helper prompt](https://learn.ynteractive.com/content/prompts/spreadsheet-formula-helper-prompt) ## Frequently asked questions **Do pivot tables change my original data?** No. A pivot table reads your data and builds a separate summary. Editing or deleting the pivot table leaves the source rows untouched. **Can AI build a pivot table for me?** AI chat tools can tell you which fields to choose, and some spreadsheet assistants can create one. Check the result against a quick manual total before trusting it. [All AI glossary terms, A to Z](https://learn.ynteractive.com/content/glossary) · [Free prompt templates](https://learn.ynteractive.com/content/prompts)