excel MCP 工具

Secondary: Install via .NET tool (requires .NET 10 runtime)

dotnet tool install --global Sbroenne.ExcelMcp.McpServer dotnet tool install --global Sbroenne.ExcelMcp.CLI

Install one or both plugins

copilot plugin install excel-mcp@mcp-server-excel-plugins # For conversational AI copilot plugin install excel-cli@mcp-server-excel-plugins # For scripting / coding agents

- **`excel-mcp`** — MCP server for conversational workflows
- **`excel-cli`** — Skill for coding agents (install `excelcli` separately if you want the CLI tool)

**Note:** After each release, there may be a short delay before plugins appear in the marketplace. You may need to wait a few moments for updates to sync.

📖 [Full Installation Guide →](docs/INSTALLATION.md)

<details>
<summary>📊 Benchmark Results (same task, same model)</summary>

| Metric | CLI | MCP Server | Winner |
|--------|-----|------------|--------|
| **Tokens** | ~59K | ~163K | 🏆 CLI (64% fewer) |

**Key insight:** MCP sends 23 tool schemas to the LLM on each request (~100K+ tokens).

</details>

**Manual Installation:**

After installing either way, auto-configure all your coding agents:

npx add-mcp "mcp-excel" --name excel-mcp

> ⚠️ **Step 2 requires [Node.js](https://nodejs.org/)** for `npx`. Install with `winget install OpenJS.NodeJS.LTS` if needed.

Optional: Install agent skills for better AI guidance

npx skills add sbroenne/mcp-server-excel --skill excel-cli # Coding agents npx skills add sbroenne/mcp-server-excel --skill excel-mcp # Conversational AI ```

💡 Skills provide AI guidance - The CLI skill is highly recommended (agents don't work perfectly with CLI without it). The MCP skill is recommended - it adds workflow best practices and reduces token usage.

💬 Example Prompts

Create & Populate Data: - "Create a new Excel file called SalesTracker.xlsx with a table for Date, Product, Quantity, Unit Price, and Total with sample data" - "Put this data in A1:C4 - Name, Age, City / Alice, 30, Seattle / Bob, 25, Portland" - "Add a formula column that calculates Quantity times Unit Price"

Analysis & Visualization: - "Create a PivotTable from this data showing total sales by Product, then add a bar chart" - "Use Power Query to import products.csv, load it to the Data Model, and create a measure for Total Revenue" - "Create a slicer for the Region field so I can filter the PivotTable interactively" - "Create a relationship between the Orders and Products tables using ProductID"

Formatting & Styling: - "Format the Price column as currency and highlight values over $500 in green" - "Convert this range to an Excel Table with a blue style and add a totals row" - "Make the headers bold with a dark background and auto-fit column widths" - "Apply the same section-header styling to A1:G1, A12:G12, and A24:G24 in one step"

Formatting split: number display formats use the range tool, while visual styling and auto-fit use range_format.

Automation: - "Export all Power Query M code to files for version control" - "Run the UpdatePrices macro" - "Show me Excel while you work" - watch changes in real-time

🪟 Agent Mode — Watch AI Work in Excel: - "Show me Excel side-by-side while you build this dashboard" - real-time visibility - "Let me watch while you create the chart" - AI asks your preference, then shows Excel - Status bar shows live progress: "ExcelMcp: Building PivotTable from Sales data..."

🚀 Quick Start

⚠️ Important: Close all Excel files before using. The server requires exclusive access to workbooks during automation.

- ExcelMcp-CLI-{version}-windows.zip → extract excelcli.exe (optional, for scripting)

📦 GitHub Copilot Plugins

ExcelMcp is available as two GitHub Copilot CLI plugins in the Copilot plugin marketplace:

```powershell

Register the plugin marketplace (one-time)

copilot plugin marketplace add sbroenne/mcp-server-excel-plugins

🔧 CLI vs MCP Server

This package provides both CLI and MCP Server interfaces. Choose based on your use case:

Installation: - CLI via Copilot plugin (Recommended for Copilot CLI): Install the excel-cli plugin for skill guidance, then install excelcli separately - CLI Standalone: Download ZIP from releases or install via NuGet - Skill only: Install the excel-cli skill separately when your agent already has excelcli available on PATH - MCP Server: Download from releases or install VS Code Extension

⚡ CLI Commands: Generated automatically from Core service definitions using Roslyn source generators. All 22 command categories maintain exact 1:1 parity with MCP tools through shared code generation. See code generation docs for details.