Excel MCP Server

🚀 Excel MCP Server

An Excel file processing server based on the Model Context Protocol (MCP), providing functions for reading, writing, and analyzing Excel files.

✨ Features

• 📖 Read Excel files

  • Get the list of worksheets
  • Read data from a specific worksheet
  • Read data from all worksheets

• ✍️ Write Excel files

  • Create a new Excel file
  • Write to a specific worksheet
  • Support multiple worksheets

• 🔍 Analyze Excel structure

  • Analyze the worksheet structure
  • Export the structure to a new file

• 💾 Cache management

  • Automatic content caching
  • Scheduled cache cleanup
  • Manual cache clearing

• 📝 Log management

  • Automatic operation log recording
  • Periodic log cleanup

📦 Installation

Install via Smithery

To automatically install excel-mcp-server for Claude Desktop, visit Smithery and run the following command:

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

Manual installation

Install via NPM excel-mcp-server can be automatically installed by adding the following content to the MCP server configuration.

On Windows:

{
  "mcpServers": {
    "excel": {
        "command": "cmd",
        "args": ["/c", "npx", "--yes", "@zhiweixu/excel-mcp-server"],
        "env": {
            "LOG_PATH": "[Set an accessible absolute path]",
            "CACHE_MAX_AGE": "1",
            "CACHE_CLEANUP_INTERVAL": "4",
            "LOG_RETENTION_DAYS": "7",
            "LOG_CLEANUP_INTERVAL": "24"
        }
    }
}

On other platforms:

{
  "mcpServers": {
    "excel": {
        "command": "npx",
        "args": ["--yes", "@zhiweixu/excel-mcp-server"],
        "env": {
            "LOG_PATH": "[Set an accessible absolute path]",
            "CACHE_MAX_AGE": "1",
            "CACHE_CLEANUP_INTERVAL": "4",
            "LOG_RETENTION_DAYS": "7",
            "LOG_CLEANUP_INTERVAL": "24"
        }
    }
}

📚 Documentation

Environment Variables

Default Configuration

• Cache configuration

  • Cache expiration time: 1 hour
  • Cache cleanup interval: 4 hours

• Log configuration

  • Log retention days: 7 days
  • Cleanup interval: 24 hours

Dependencies

• @modelcontextprotocol/sdk: ^1.7.0
• xlsx: ^0.18.5
• typescript: ^5.8.2

Development Dependencies

• @types/node: ^22.13.10
• nodemon: ^3.1.9
• ts-node: ^10.9.2

📄 License

This project is licensed under the MIT License. This means you can freely:

• Use it for commercial or non - commercial purposes
• Modify the source code
• Distribute the original or modified code

Requirements:

• Retain the original copyright notice
• Cannot claim liability against the author for software use

For detailed license information, please refer to the LICENSE file.