drio
Open app

Excel MCP Server

Source

Excel数据处理微服务

Catalog onlyCatalog onlySTDIO

Overview

Excel MCP Server is a microservice for processing Excel files based on the Model Context Protocol (MCP), providing functionalities for reading, writing, and analyzing Excel files.

To use Excel MCP Server, install the dependencies, build the project, and start the service using npm commands. You can then access the API tools for reading and writing Excel data.

  • 📖 Read Excel files: Get sheet names, read specific sheet data, and read all sheet data. - ✍️ Write to Excel files: Create new files and write data to specified sheets. - 🔍 Analyze Excel structure: Analyze and export the structure of Excel files. - 💾 Cache management: Automatically cache file contents and manage cache expiration. - 📝 Log management: Automatically record operation logs and manage log expiration.
  1. Automating data entry and extraction from Excel files.
  2. Analyzing data structures for reporting and visualization.
  3. Integrating Excel processing into larger data workflows.

Add to your AI client

Use these steps to connect Excel MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "excel-mcp-server-zhiwei5576": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-excel-mcp-server-zhiwei5576"
      ]
    }
  }
}

FAQ

Can Excel MCP Server handle large Excel files?

Yes, it is designed to efficiently process large Excel files.

Is there a limit to the number of sheets it can read/write?

No, it can handle multiple sheets as long as system resources allow.

What programming language is used for this project?

The project is developed in TypeScript.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":3247,"uuid":"4091c3c6-44df-4ef3-a4d2-67aa0b2c8b00","name":"excel-mcp-server","title":"Excel MCP Server","description":"Excel数据处理微服务","avatar_url":"https://avatars.githubusercontent.com/u/40907291?v=4","created_at":"$D2025-03-18T12:02:06.030Z","updated_at":"$D2025-03-18T14:00:41.938Z","status":"created","author_name":"zhiwei5576","author_avatar_url":"https://avatars.githubusercontent.com/u/40907291?v=4","tags":"[]","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/zhiwei5576/excel-mcp-server","target":"_self","content":"$29","summary":"$2a","img_url":"https://camo.githubusercontent.com/415ab3bff9980f67456ce1d46cb93133d217a20afaceefa37d3ba2622ab430a7/68747470733a2f2f696d672e736869656c64732e696f2f6e706d2f762f407a686977656978752f657863656c2d6d63702d736572766572","type":null,"metadata":"{\"star\":\"11\",\"license\":\"MIT license\",\"language\":\"TypeScript\",\"is_official\":false,\"latest_commit_time\":\"2025-04-10 14:17:33\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Research and data