Skip to main content
plugin

excel-mcp — GitHub Copilot plugin: what it does, how to install

Automates desktop Excel through GitHub Copilot: builds tables, refreshes Power Query, edits formulas, and runs VBA directly in the active app.

MIT ★ 2 updated 2026-10-23

Install into GitHub Copilot · Command from the source All methods and platforms ↓
copilot plugin install excel-mcp@awesome-copilot
Open on GitHub

What excel-mcp does

The plugin lets your assistant control a running desktop Excel instance. It exposes 63 MCP tools across 33 functional areas, covering 424 operations. You can generate workbooks, build PivotTables, plot charts, apply conditional formatting, and query data models with DAX. Because Excel handles every calculation itself, results match native spreadsheet logic.

Without Windows, desktop Excel 2016 or later, and Node.js 18 with npx, the plugin will not operate. It also requires an interactive desktop session. The tool detects IRM and AIP protection, opening the workbook visibly whenever manual sign-in is needed.

Data privacy stays local by default. Your M queries and DAX snippets never leave your machine unless you explicitly pass formatMCode=true or formatDax=true to call external formatters.

What it helps with

  • build a sales tracker with custom formulas and columns
  • generate PivotTables and regional charts from raw data
  • refresh Power Query queries inside an existing workbook
  • run VBA routines and automate Excel application windows

Example prompts for the agent

  • Create a sales tracker with Date, Product, Quantity, Unit Price, and Total columns.
  • Create a PivotTable showing revenue by region, then add a chart.
  • Refresh the Power Query queries in this workbook and save it.

How to install excel-mcp

Command from the source

copilot plugin install excel-mcp@awesome-copilot

Step by step, with commands for each platform: Claude Code plugins: marketplaces, installing, and building your own

Questions about excel-mcp

How to install excel-mcp in GitHub Copilot?

Run copilot plugin install excel-mcp@awesome-copilot in your terminal. The plugin handles the MCP server configuration automatically.

What does excel-mcp do?

It connects your assistant to desktop Excel via 63 MCP tools, enabling formula creation, PivotTable generation, Power Query refreshes, and VBA execution.

Does excel-mcp send data to external web services?

By default, DAX and M code stay on your computer. Code is sent to external formatters only if you set formatMCode=true or formatDax=true.

Source text

excel-mcp · MIT
# Excel MCP Plugin

**Let your AI assistant create and update Microsoft Excel workbooks using MCP
tools.**

ExcelMcp operates the actual Excel application, so Excel handles calculations
and workbook features.

## Requirements

- GitHub Copilot CLI or Claude Code
- Windows with desktop Excel 2016 or later
- Node.js 18 or later with `npx`

ExcelMcp runs in an interactive desktop session.

## What you can ask your assistant to do

| Request | Result |
| --- | --- |
| "Create a sales tracker with Date, Product, Quantity, Unit Price, and Total columns." | A workbook with a table and formulas. |
| "Create a PivotTable showing revenue by region, then add a chart." | A summary and chart built in Excel. |
| "Refresh the Power Query queries in this workbook and save it." | Updated query results saved in the workbook. |
| "Show me Excel while you work." | Excel is visible as the assistant makes changes. |

## Features

The server provides 63 MCP tools across 33 feature areas, with 424 operations.

- **Workbooks and data:** create or open workbooks, edit ranges and tables, and work with formulas.
- **Analysis:** refresh Power Query, query the Data Model with DAX, and build PivotTables and slicers.
- **Reports:** create and format charts, worksheets, and conditional formatting.
- **Automation:** manage connections, run VBA, and automate Excel windows.
- **Protected workbooks:** detect IRM/AIP protection and open Excel visibly for sign-in.

See the [complete feature reference](https://excelmcpserver.dev/features/).

## Privacy

M and DAX code stays on your computer by default. If you enable
`formatMCode=true` or `formatDax=true`, the corresponding code is sent to
powerqueryformatter.com or daxformatter.com for formatting. Only enable these
options when you want to send code to those services.

## Support

- [Documentation](https://excelmcpserver.dev/)
- [Issues](https://github.com/sbroenne/mcp-server-excel/issues)
- MIT License

## Install

Install from [Awesome Copilot](https://github.com/github/awesome-copilot), the
default marketplace in current Copilot clients:

```powershell
copilot plugin install excel-mcp@awesome-copilot
```

Or use the direct marketplace:

```powershell
copilot plugin marketplace add sbroenne/mcp-server-excel-plugins
copilot plugin install excel-mcp@mcp-server-excel-plugins
```

Choose one marketplace for this plugin; do not install both copies.

For Claude Code, use the direct marketplace:

```powershell
claude plugin marketplace add sbroenne/mcp-server-excel-plugins
claude plugin install excel-mcp@mcp-server-excel-plugins
```

The plugin includes the MCP server setup; no manual server configuration is
needed. For Claude Desktop or another MCP-compatible client without this plugin,
follow the
[MCP Server installation guide](https://excelmcpserver.dev/installation-mcp-server/).

© Stefan Brönner · MIT · sbroenne/mcp-server-excel-plugins

Similar plugins

All plugins for Office documents →

From the same set2

Project sponsors

Companies that keep this analytics open