excel-mcp

SKILL.md

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

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