Excel MCP Server
by MCP-Mirror (based on negokaz's work)
The Excel MCP Server is a Model Context Protocol (MCP) server designed to read and write data to MS Excel files. It allows for programmatic interaction with Excel spreadsheets, enabling applications to extract and modify data within them.
Last updated: N/A
What is Excel MCP Server?
This is a Model Context Protocol (MCP) server that facilitates reading and writing data, including formulas, to Microsoft Excel files. It also supports capturing screen images from Excel on Windows systems.
How to use Excel MCP Server?
The server can be installed via NPM or Smithery. Configuration involves adding the server to the MCP servers configuration with appropriate command and arguments. Once installed, you can use the provided tools (e.g., read_sheet_data, write_sheet_data) by sending requests with the required arguments (file path, sheet name, range, data, etc.) to the server.
Key features of Excel MCP Server
Read text values from MS Excel file
Write text values to MS Excel file
Read formulas from MS Excel file
Write formulas to MS Excel file
Capture screen image from MS Excel file (Windows only)
Use cases of Excel MCP Server
Automated data extraction from Excel spreadsheets for reporting
Programmatic modification of Excel data based on external events
Integration of Excel data with other applications and systems
Automated generation of Excel reports
Using Excel as a data source for AI models via MCP
FAQ from Excel MCP Server
What file formats are supported?
What file formats are supported?
The server supports xlsx, xlsm, xltx, and xltm file formats.
What is the EXCEL_MCP_PAGING_CELLS_LIMIT environment variable for?
What is the EXCEL_MCP_PAGING_CELLS_LIMIT environment variable for?
It defines the maximum number of cells to read in a single paging operation. The default value is 4000.
Is screen capture supported on all platforms?
Is screen capture supported on all platforms?
No, screen capture is only supported on Windows.
How do I specify the range of cells to read or write?
How do I specify the range of cells to read or write?
You can use the range argument with a standard Excel range notation (e.g., "A1:C10").
How do I install the server?
How do I install the server?
You can install it via NPM or Smithery. See the installation instructions in the README.