excel mcp server

Local 2025-08-31 23:14:11 0

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.

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:

{
    "mcpServers": {
        "excel": {
            "command": "cmd",
            "args": ["/c", "npx", "--yes", "@negokaz/excel-mcp-server"],
            "env": {
                "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000"
            }
        }
    }
}

For other platforms:

{
    "mcpServers": {
        "excel": {
            "command": "npx",
            "args": ["--yes", "@negokaz/excel-mcp-server"],
            "env": {
                "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000"
            }
        }
    }
}

Installing via Smithery

To install Excel MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @negokaz/excel-mcp-server --client claude

Tools

`read_sheet_names`

List all sheet names in an Excel file.

Arguments: - fileAbsolutePath - Absolute path to the Excel file

`read_sheet_data`

Read data 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

`read_sheet_formula`

Read formulas from Excel sheet with pagination.

`read_sheet_image`

[Windows only] Read data as an image from the Excel sheet with pagination.

`write_sheet_data`

Write data to the Excel sheet.

`write_sheet_formula`

Write formulas to the Excel sheet.

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"). - formulas - Formulas to write to the Excel sheet (e.g., "=A1+B1")

Configuration

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

excel-mcp-server is released under the MIT License