excel-pivot-wizard

Creates pivot tables and visualizations from natural language requests.

• Generates pivot tables from natural language commands
• Supports cross-tabulation and time-based analysis
• Creates charts like columns, lines, and pie charts
• Adds filters, conditional formatting, and calculated fields

• Pivot table generation with rows, columns, values, filters
• Natural language parsing into structured analysis
• Visualization support (line, column, pie, combo)
• Conditional formatting for heatmaps and top/bottom values
• Calculated fields like profit margin and growth %
• Supports time-based trend analysis and top N rankings

1. 1.Understand data structure and user intent
2. 2.Parse request into pivot structure (rows, columns, values)
3. 3.Build pivot table using Excel MCP server
4. 4.Apply formatting and enhancements (filters, colors, formulas)
5. 5.Generate visualization if requested
6. 6.Present insights and offer follow-up actions