Excel MCP Server
local-only server
The server can only run on the client’s local machine because it depends on local resources.
Excel MCP Server
A Model Context Protocol (MCP) server that reads and writes MS Excel data.
Features
- 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)
For more details, see the tools section.
Requirements
- Node.js 20.x or later
Supported file formats
- xlsx (Excel book)
- xlsm (Excel macro-enabled book)
- xltx (Excel template)
- xltm (Excel macro-enabled template)
Installation
Installing via NPM
excel-mcp-server is automatically installed by adding the following configuration to the MCP servers configuration.
For Windows:
For other platforms:
Installing via Smithery
To install Excel MCP Server for Claude Desktop automatically via Smithery:
read_sheet_names
List all sheet names in an Excel file.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
read_sheet_data
Read data from Excel sheet with pagination.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
range- Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range]
knownPagingRanges- List of already read paging ranges
read_sheet_formula
Read formulas from Excel sheet with pagination.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
range- Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range]
knownPagingRanges- List of already read paging ranges
read_sheet_image
[Windows only] Read data as an image from the Excel sheet with pagination.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
range- Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range]
knownPagingRanges- List of already read paging ranges
write_sheet_data
Write data to the Excel sheet.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
range- Range of cells to read in the Excel sheet (e.g., "A1:C10").
data- Data to write to the Excel sheet
write_sheet_formula
Write formulas to the Excel sheet.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
range- Range of cells to read in the Excel sheet (e.g., "A1:C10").
formulas- Formulas to write to the Excel sheet (e.g., "=A1+B1")
You can change the MCP Server behaviors by the following environment variables:
EXCEL_MCP_PAGING_CELLS_LIMIT
The maximum number of cells to read in a single paging operation.
[default: 4000]
License
Copyright (c) 2025 Kazuki Negoro
excel-mcp-server is released under the MIT License
This server cannot be installed
A Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.