excel-mcp
Installation
Summary
Automate Excel workbooks on Windows with 226 COM-based operations covering data, formulas, tables, Power Query, and DAX.
- Supports full Excel object model: ranges, tables, worksheets, PivotTables, charts, slicers, conditional formatting, and VBA macro execution
- Includes Power Query (M code evaluation and creation) and Data Model (DAX measures) for advanced analytics workflows
- Provides calculation mode control for batch write performance optimization when handling large data volumes
- Requires Windows host with Excel 2016+, full file paths, and exclusive file access; session-based with auto-discovery of 226 tools
SKILL.md
Excel MCP Server Skill
Provides 227 Excel operations via Model Context Protocol. The MCP Server forwards all requests to the shared ExcelMCP Service, enabling session sharing with CLI. Tools are auto-discovered - this documents quirks, workflows, and gotchas.
Workflow Checklist
| Step | Tool | Action | When |
|---|---|---|---|
| 1. Open file | file |
open or create |
Always first |
| 2. Create sheets | worksheet |
create, rename |
If needed |
| 3. Write data | range |
set-values |
Always (2D arrays) |
| 4. Format | range |
set-number-format |
After writing |
| 5. Structure | table |
create |
Convert data to tables |
| 6. Save & close | file |
close with save: true |
Always last |
Preconditions
- Windows host with Microsoft Excel installed (2016+)
- Use full Windows paths:
C:\Users\Name\Documents\Report.xlsx
Related skills