sbroenne

mcp-server-excel: Automate Microsoft Excel with AI

mcp-server-excel lets AI assistants and coding agents automate the real Microsoft Excel application through MCP or a CLI. It suits Windows users who need workbook operations that file parsers cannot perform, such as refreshing Power Query or running VBA.

View on GitHub Compare
Stars
802
Forks
90
Stars, last 30 days
+73

Our take

Health score

74/100

How it is scored
Activity
90
Community
32
Issues
91
Pull requests
82

+73 stars in the last 30 days

  • Releases more often than 93% of the projects we track
  • Merges more pull requests than 92% of the projects we track
  • Closes issues faster than 81% of the projects we track

Project history

Daily GitHub snapshots since Oct 7, 2026. History covers stars and forks; health signals are not tracked historically.

Selected snapshot

Stars

901

Forks

113

Change since Nov 17, 2026: +3 stars·0 forks

Overview

mcp-server-excel connects AI assistants and scripts to the actual Microsoft Excel application, using Excel's COM API rather than editing workbook files with a parser. It provides MCP and CLI interfaces for issuing commands to Excel, with a shared core for workbook operations.

This is aimed at workflows that depend on Excel's own calculation and automation capabilities, or need to preserve workbook features such as macros, PivotTables, charts, and the Data Model. It is a fit for Windows desktop use, not headless or cross-platform spreadsheet processing.

Key Features

  • Automate Excel through either an MCP server or the excelcli command-line interface.
  • Work with cells, formulas, formatting, worksheets, files, and named ranges.
  • Refresh Power Query, work with data connections, and evaluate DAX and Power Pivot operations.
  • Create and manage Excel Tables, PivotTables, charts, slicers, and conditional formatting.
  • Run VBA and Python in Excel, and use tools such as Goal Seek and scenarios.
  • Keep Excel's workbook features, including macros and formatting, while operating on the workbook in the real application.

Use Cases

  • A finance or operations analyst can ask an AI assistant to build a PivotTable and chart from workbook data, then review the result in Excel.
  • A data analyst can refresh Power Query and load data into the Data Model as part of an interactive workflow.
  • A coding agent or developer can use the CLI to automate workbook edits from scripts without relying on conversational MCP tool discovery.
  • An Excel user can use natural-language requests for tasks such as finding an input with Goal Seek or running a VBA macro.

Getting Started

Choose an entry point based on your workflow: install the VS Code extension, install the MCP server, or install the CLI. See the installation overview and the repository README for details.

Alternatives

  • OfficeCLI: OfficeCLI edits Excel files through cross-platform commands, while mcp-server-excel automates the Windows Excel application for tasks such as refreshing Power Query or running VBA.
ProjectLanguageLicenseStarsStatus
mcp-server-excelC#MIT802Not checked yet
OfficeCLIC#Apache-2.031.5kActive

Considerations

  • Requires Windows, Microsoft Excel 2016 or later, and an interactive desktop session.
  • It is not intended for Linux, macOS, or server-side batch processing.
  • ExcelMcp requires exclusive access while automating workbooks, so close open Excel workbooks before starting.
  • The project controls the installed Excel application, so it is best suited to workflows where using real desktop Excel is acceptable.

Found this useful?

Share it with someone who would like mcp-server-excel.

Comparisons