How to Build Pivot Tables with Claude in Excel
Use Claude in Excel to design pivot tables, choose dimensions, and summarize data quickly.
Feb 6, 2026
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.