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:C10"). [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:C10"). [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:C10").
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:C10")
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
This server cannot be installed
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 that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.Last updated -44PythonMIT License
- AsecurityAlicenseAqualityA Model Context Protocol server that enables AI assistants to create, read, edit, and format Microsoft Word documents through standardized tools and resources.Last updated -16139PythonMIT License
- -securityAlicense-qualityA Model Context Protocol server that enables AI assistants like Claude to read from, append to, and format text in Google Documents programmatically.Last updated -11TypeScriptMIT License
- -securityAlicense-qualityA simple Model Context Protocol server that enables AI assistants to interact with local file systems, allowing them to read, write, update, and delete files within a specified project directory.Last updated -PythonMIT License