Excel MCP Server

Name: Excel MCP Server
Author: bengbengbalabalabeng

@bengbengbalabalabeng

リポジトリ

Excel MCP Server について

Model Context Protocol (MCP) for Excel.

#excel #mcp #java #server

基本情報

カテゴリ

その他

ライセンス

Apache-2.0

ランタイム

java

トランスポート

stdio

公開者

bengbengbalabalabeng

投稿者

蹦蹦巴拉巴拉蹦

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "fastexcel-mcp-server": {
      "command": "java",
      "args": [
        "-jar",
        "<YOUR_PATH>/fastexcel-mcp-server-0.0.1-SNAPSHOT.jar"
      ],
      "env": {
        "MCP_WORKSPACES": "<YOUR_MULTIPLE_WORKSPACES_SEPARATED_BY_COMMAS>",
        "CACHE_INITIAL_CAPACITY": "[OPTIONAL] <MINIMUM_TOTAL_SIZE_FOR_THE_INTERNAL_DATA_STRUCTURES> <DEFAULT: 100>",
        "CACHE_MAXIMUM_SIZE": "[OPTIONAL] <MAXIMUM_NUMBER_OF_ENTRIES_THE_CACHE_MAY_CONTAIN> <DEFAULT: 1000>",
        "CACHE_EXPIRE_AFTER_WRITE": "[OPTIONAL] <LENGTH_OF_TIME_AFTER_AN_ENTRY_IS_CREATED_THAT_IT_SHOULD_BE_AUTOMATICALLY_REMOVED> <DEFAULT: 35s>"
      }
    }
  }
}

ツール

`excelPath` (string): Absolute or relative path to the Excel file.

Clear all cached Excel file data from memory.

Test if the specified Excel file is available in cache.

概要

What is Excel MCP Server?

Excel MCP Server is a Java implementation of the Model Context Protocol (MCP) for reading Excel files. It provides tools to extract headers, row data, sheet names, and row counts from XLSX, XLS, and CSV files while enforcing workspace‑based path validation. The server is intended for developers who want to enable AI assistants (e.g., Claude Desktop) to interact programmatically with spreadsheet data.

How to use Excel MCP Server?

Build the server with JDK 17+ GraalVM and Maven 3.9.6+ using mvn clean package -DskipTests=true. Then configure Claude Desktop by adding a server entry to claude_desktop_config.json, setting the command to java with the JAR path and the environment variable MCP_WORKSPACES (comma‑separated allowed directories). Optional cache settings can be tuned with CACHE_INITIAL_CAPACITY, CACHE_MAXIMUM_SIZE, and CACHE_EXPIRE_AFTER_WRITE. The server exposes tools such as get_total_rows_number, get_sheet_names, read_head_spec, read_rows_spec, and cache control tools.

Key features of Excel MCP Server

Read Excel files (XLSX, XLS, CSV) headers and data rows.
Validate input paths against configured workspace directories.
Support for multiple sheets and custom header‑row indices.
Retrieve total data row count excluding headers.
Built‑in performance caching for repeated file access.
Clear or test cache availability via dedicated tools.

Use cases of Excel MCP Server

Let an AI assistant read and summarize spreadsheet data.
Extract column headers and corresponding data rows for analysis.
Validate Excel file content against workspace permissions.
Efficiently reuse cached file data across multiple queries.

FAQ from Excel MCP Server

Which file formats are supported?

XLSX, XLS, and CSV files are supported.

What are the runtime requirements?

JDK 17+ (GraalVM) and Maven 3.9.6+ are required to build and run the server.

How does workspace restriction work?

The server only allows operations on files located inside directories listed in the MCP_WORKSPACES environment variable (comma‑separated). Paths outside those directories are rejected.

Can I adjust caching behaviour?

Yes. Environment variables CACHE_INITIAL_CAPACITY, CACHE_MAXIMUM_SIZE, and CACHE_EXPIRE_AFTER_WRITE let you control the internal cache parameters. Defaults are 100, 1000, and 35 seconds respectively.

How is the server invoked (transport)?

The server communicates over standard I/O (stdio) as a subprocess of the MCP host (e.g., Claude Desktop). No authentication or network configuration is required.