-
securityA
license-
qualityA Model Context Protocol server that enables AI agents to create, read, and modify Excel workbooks without requiring Microsoft Excel installation.
Last updated -
Python
MIT License
The Excel MCP Server is a tool for reading, writing, and manipulating Microsoft Excel files programmatically. It enables you to:
- Read/write text values and formulas in Excel sheets
- Create new sheets within Excel files
- List all sheet information of a specified Excel file
- Read values from Excel sheets with pagination support
- Create tables within a specified range
- Copy existing sheets to new sheets within the same file
- Write specific values or formulas to designated ranges
- Capture screenshots of Excel sheets (Windows only)
- Supports multiple Excel formats: .xlsx, .xlsm, .xltx, and .xltm
Excel MCP Server
A Model Context Protocol (MCP) server that reads and writes MS Excel data.
Features
- Read/Write text values
- Read/Write formulas
- Create new sheets
🪟Windows only:
- Live editing
- Capture screen image from a sheet
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:
excel_describe_sheets
List all sheet information of specified Excel file.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
excel_read_sheet
Read values 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"). [default: first paging range]
knownPagingRanges- List of already read paging ranges
showFormula- Show formula instead of value
excel_screen_capture
[Windows only] Take a screenshot of 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"). [default: first paging range]
knownPagingRanges- List of already read paging ranges
excel_write_to_sheet
Write values to the Excel sheet.
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name in the Excel file
newSheet- Create a new sheet if true, otherwise write to the existing sheet
range- Range of cells to read in the Excel sheet (e.g., "A1").
values- Values to write to the Excel sheet. If the value is a formula, it should start with "="
excel_create_table
Create a table in the Excel sheet
Arguments:
fileAbsolutePath- Absolute path to the Excel file
sheetName- Sheet name where the table is created
range- Range to be a table (e.g., "A1")
tableName- Table name to be created
excel_copy_sheet
Copy existing sheet to a new sheet
Arguments:
fileAbsolutePath- Absolute path to the Excel file
srcSheetName- Source sheet name in the Excel file
dstSheetName- Sheet name to be copied
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
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
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.
Related Resources
Related MCP Servers
- -securityAlicense-qualityA Model Context Protocol server for intelligent Excel processing and data analysis, offering tools for reading, validating, executing code, and generating interactive visualizations with Excel files.Last updated -17PythonMIT License
- -securityAlicense-qualityA Model Context Protocol server designed for AI assistants to directly process spreadsheet files, enabling them to read, display, modify, and save various table formats like CSV and Excel.Last updated -3PythonMIT License
- AsecurityFlicenseAqualityA Model Context Protocol server that enables reading and analyzing Excel documents with features like flexible data access, multiple output formats, and advanced analysis capabilities.Last updated -2TypeScript