Negokaz Excel MCP Server

🚀 Excel MCP Server

A server supporting Model Context Protocol (MCP) for reading and writing Microsoft Excel data.

🚀 Quick Start

Excel MCP Server is a server that supports the Model Context Protocol (MCP) and is used to read and write Microsoft Excel data.

✨ Features

• Read text values from MS Excel files.
• Write text values to MS Excel files.
• Read formulas from MS Excel files.
• Write formulas to MS Excel files.
• Capture screen images of files (Windows only).

For more details, please refer to the Tools section.

📦 Installation

System Requirements

• Node.js 20.x or higher.

Supported File Formats

• xlsx (Excel Workbook)
• xlsm (Excel Workbook with Macros)
• xltx (Excel Template)
• xltm (Excel Template with Macros)

Installation via NPM

To automatically install Excel MCP Server, add the following to your MCP server 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"
            }
        }
    }
}

Installation via Smithery

To automatically install Excel MCP Server for Claude Desktop, use Smithery:

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

📚 Documentation

Tools

read_sheet_names

List all worksheet names in an Excel file.

Parameters:

• fileAbsolutePath
  • The absolute path of the Excel file.

read_sheet_data

Read data from an Excel worksheet by page.

Parameters:

• fileAbsolutePath
  • The absolute path of the Excel file.
• sheetName
  • The name of the worksheet in the Excel file.
• range (Optional)
  • The range to read, formatted as "A1:B2".
  • Default value: The entire worksheet.
• returnHeaders (Optional)
  • Whether to return column headers. Default is true.

read_sheet_data_all

Read data from all worksheets in an Excel file by page.

Parameters:

• fileAbsolutePath
  • The absolute path of the Excel file.

write_sheet_data

Write data to an Excel worksheet.

Parameters:

• fileAbsolutePath
  • The absolute path of the Excel file.
• sheetName
  • The name of the worksheet to write to.
• data
  • The data to write, formatted as {row: number, column: string, value: any}.
• headers (Optional)
  • Whether to add headers in the first row. Default is true.

write_sheet_data_all

Write data to all worksheets in an Excel file.

Parameters:

• fileAbsolutePath
  • The absolute path of the Excel file.

🔧 Technical Details

Adjust the behavior of the MCP server through the following environment variables:

EXCEL_MCP_PAGING_CELLS_LIMIT

The maximum number of cells to read in each paging operation.
[Default value: 4000]

📄 License

Copyright (c) 2025 Kazuki Negoro

Excel MCP Server is released under the MIT License.