Excel MCP Server

Example Use Cases

• 1

  Perform real-time edits on Excel files with immediate visual feedback.

• 2

  Automate complex Excel operations including charts, pivot tables, and VBA execution.

• 3

  Integrate Excel file manipulation into local or remote workflows via MCP protocol.

Description

This MCP server provides a service for real-time editing of Excel files by connecting directly to a locally opened Excel instance using xlwings. It supports various Excel operations including formula editing, formatting, chart creation, pivot tables, and VBA execution. The server can run locally or remotely with multiple transport methods such as stdio and streamable HTTP, facilitating seamless integration and instant update visualization within Excel. It is designed for users who need dynamic and programmatic control over Excel workbooks.