Excel Pivot Wizard

Table of Contents

• Overview — Prerequisites — Instructions — Output — Examples — Error Handling — Resources

Overview

Creates pivot tables and visualizations from raw data using natural language commands. Automates the full workflow from data inspection to formatted pivot tables with charts, calculated fields, and conditional formatting so analysts can produce polished reports without manual Excel work.

Prerequisites

• Node.js 18+
• @negokaz/excel-mcp-server MCP server configured
• Claude Code 1.0+
• Source data in .xlsx format accessible locally