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
`read_sheet_data`
Read data from Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`read_sheet_formula`
Read formulas from Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`read_sheet_image`
[Windows only] Read data as an image from the Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`write_sheet_data`
Write data to the Excel sheet.
Arguments:
fileAbsolutePath
sheetName
range
data
`write_sheet_formula`
Write formulas to the Excel sheet.
Arguments:
fileAbsolutePath
sheetName
range
formulas
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
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
`read_sheet_data`
Read data from Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`read_sheet_formula`
Read formulas from Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`read_sheet_image`
[Windows only] Read data as an image from the Excel sheet with pagination.
Arguments:
fileAbsolutePath
sheetName
range
knownPagingRanges
`write_sheet_data`
Write data to the Excel sheet.
Arguments:
fileAbsolutePath
sheetName
range
data
`write_sheet_formula`
Write formulas to the Excel sheet.
Arguments:
fileAbsolutePath
sheetName
range
formulas
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