Spreadsheet Data Access Service (Excel MCP Adapter)

This implementation serves as an MCP server facilitating interaction with Microsoft Excel file structures.

Core Capabilities

• Data retrieval and persistence for textual entries
• Handling and manipulation of embedded formulae
• Provisioning of novel worksheet tabs within a workbook

Platform Constraint: Windows Environment Required For: - Interactive, live data manipulation sessions - Generating rasterized image captures of specific sheet regions

Refer to the Tools Reference section for specific operational details.

Prerequisites

• Node.js runtime, version 20.x or newer is mandatory.

Supported Workbook Formats

• .xlsx (Standard Open XML Spreadsheet)
• .xlsm (Macro-Enabled Spreadsheet)
• .xltx (Open XML Spreadsheet Template)
• .xltm (Macro-Enabled Spreadsheet Template)

Deployment Instructions

Installation via NPM Registry

Deployment is managed by incorporating the subsequent configuration snippet into your MCP server manifest structure.

For Windows Clients:

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

For Non-Windows Clients:

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

Automated Integration via Smithery

To deploy the Excel MCP Adapter to a Claude Desktop environment managed by Smithery:

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

Operational Tool Set

excel_describe_sheets

Retrieves metadata regarding all available sheets within the designated Excel document.

Parameters: - fileAbsolutePath - The absolute filesystem path pointing to the Excel container file.

excel_read_sheet

Fetches cell content from a specified worksheet, supporting paginated extraction.

Parameters: - fileAbsolutePath - Absolute path to the target Excel file. - sheetName - Identifier for the worksheet to be queried. - range - The cell subset for data retrieval (e.g., "A1:C10"). [Default behavior retrieves the initial paginated block] - showFormula - Boolean flag: If true, returns the formula string; otherwise, returns the calculated value. [Default: false] - showStyle - Boolean flag: If true, includes cell stylistic attributes in the output. [Default: false]

excel_screen_capture

[Windows Platform Exclusive] Renders a visual snapshot of a designated worksheet area.

Parameters: - fileAbsolutePath - Absolute path to the Excel file. - sheetName - The name of the worksheet to capture. - range - The cell address extent for the image capture (e.g., "A1:C10"). [Default: initial pagination extent]

excel_write_to_sheet

Inserts or overwrites data payloads into a specified worksheet location.

Parameters: - fileAbsolutePath - Absolute path to the Excel file. - sheetName - Target worksheet identifier. - newSheet - Boolean: If true, a new worksheet will be provisioned; otherwise, writes to the existing sheet. - range - The coordinate span where the input values should be placed (e.g., "A1:C10"). - values - The data payload to inject. Values designated as formulae must be prefixed with an equals sign (=).

excel_create_table

Defines a structured data range as a formal Excel Table object.

Parameters: - fileAbsolutePath - Absolute path to the Excel file. - sheetName - Worksheet where the tabular structure will be erected. - range - The cell coordinates defining the table boundary (e.g., "A1:C10"). - tableName - The assigned name for the resultant Excel Table object.

excel_copy_sheet

Duplicates an entire existing worksheet within the same workbook.

Parameters: - fileAbsolutePath - Absolute path to the Excel file. - srcSheetName - The identifier of the worksheet intended for duplication. - dstSheetName - The name to assign to the newly created sheet copy.

excel_format_range

Applies specific visual styling parameters to a selection of cells within a worksheet.

Parameters: - fileAbsolutePath - Absolute path to the Excel file. - sheetName - Target worksheet identifier. - range - The cell subset for style application (e.g., "A1:C3"). - styles - A two-dimensional array structure containing style object definitions corresponding cell-by-cell to the specified range. Null entries indicate no style modification for that specific cell. - Structure of the Style Object: - border: An array detailing border specifications (component type, color specification, line pattern). - font: Attributes controlling typeface appearance (weight emphasis, slant, underlining, point size, strikethrough status, color code, vertical alignment). - fill: Specifications for background shading (pattern type, pattern complexity, color specification, shading intensity). - numFmt: A string representing a customized numeric display format. - decimalPlaces: Integer specifying the precision for displayed decimal figures (range 0 to 30).

Operational Parameter Tuning

Service execution behavior can be modulated through environment variables:

EXCEL_MCP_PAGING_CELLS_LIMIT

Defines the maximum quantity of cells the server is permitted to process in a single data fetching transaction. [Default Setting: 4000]

Legal Notice

Copyright (c) 2025 Kazuki Negoro

This component, excel-mcp-server, is distributed under the terms of the MIT License.