How to Build Pivot Tables with Claude in Excel
Use Claude in Excel to design pivot tables, choose dimensions, and summarize data quickly.
2026/02/06
When this guide helps
Use this guide when you need to summarize large datasets by category, time, region, or any dimension.
Step-by-step workflow
1. Describe the summary you want
Prompt:
Create a pivot table that summarizes total revenue by region (column B) and month (column A). Use revenue from column F.2. Add filters and segments
Prompt:
Update the pivot to include a filter for product category (column C) and show only the top 5 regions by revenue.3. Add calculated fields
Prompt:
Add a calculated field to show average order value using total revenue divided by number of orders.4. Validate the output
Prompt:
Verify the pivot results against rows 2 through 20 and call out any mismatches.Practical tips
- Clearly name your columns and avoid merged header cells.
- If the dataset is large, convert it to a structured table first.
- Use separate sheets for raw data and pivot outputs.
Common pitfalls
- Inconsistent column names can break pivot configuration.
- Duplicated rows can skew totals.