negokaz/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:
json
"mcpServers": {
"excel": {
"command": "cmd",
"args": ["/c", "npx", "--yes", "@negokaz/excel-mcp-server"],
"env": {
"EXCELMCPPAGINGCELLSLIMIT": "4000"
For other platforms:
json
"mcpServers": {
"excel": {
"command": "npx",
"args": ["--yes", "@negokaz/excel-mcp-server"],
"env": {
"EXCELMCPPAGINGCELLSLIMIT": "4000"
### Installing via Smithery
To install Excel MCP Server for Claude Desktop automatically via Smithery:
bash
npx -y @smithery/cli install @negokaz/excel-mcp-server --client claude
Tools
### exceldescribesheets
List all sheet information of specified Excel file.
Arguments:
fileAbsolutePath
Absolute path to the Excel file
### excelreadsheet
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]
showFormula
Show formula instead of value [default: false]
showStyle
Show style information for cells [default: false]
### excelscreencapture
[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]
### excelwritetosheet
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 "="
### excelcreatetable
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
### excelcopysheet
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
### excelformatrange
Format cells in the Excel sheet with style information