-
securityF
license-
qualityA Model Context Protocol server that provides tools for reading, updating, filtering, and visualizing Excel data through a simple API.
Last updated -
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.
Tools
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 enables AI agents to create, read, and modify Excel workbooks without requiring Microsoft Excel installation.Last updated -MIT License
- -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 -17MIT License
- AsecurityAlicenseAqualityA 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 -33MIT License