excel-mcp-server

excel-mcp-server

23
file_systems

Excel MCP Server is a tool based on the Model Context Protocol (MCP) for processing Excel files, offering functionalities like reading, writing, and analyzing spreadsheet data. It features robust cache and log management for efficient operation. The server is designed to integrate smoothly with multiple platforms.

Excel MCP Server

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

Features

  • Read Excel Files: Get worksheet list, read specific worksheet data, read all worksheets data.
  • Write Excel Files: Create new Excel files, write to specific worksheet, support multiple worksheets.
  • Analyze Excel Structure: Analyze worksheet structure, export structure to new file.
  • Cache Management: Automatic file content caching, scheduled cache cleanup, manual cache clearing.
  • Log Management: Automatic operation logging, periodic log cleanup.

Installation

Installing via Smithery

To install excel-mcp-server for Claude Desktop automatically via Smithery.

Installing Manually

Excel-mcp-server can be installed automatically by configuring MCP servers on different platforms.

API Tools

  • Structure Tools: analyzeExcelStructure, exportExcelStructure.
  • Read Tools: readSheetNames, readDataBySheetName, readSheetData.
  • Write Tools: writeDataBySheetName, writeSheetData.
  • Cache Tools: clearFileCache.

Configuration

Environment Variables

  • LOG_PATH
  • CACHE_MAX_AGE
  • CACHE_CLEANUP_INTERVAL
  • LOG_RETENTION_DAYS
  • LOG_CLEANUP_INTERVAL

Default Configuration

  • Cache Configuration: Cache expiration 1 hour, cleanup 4 hours.
  • Log Configuration: Log retention 7 days, cleanup 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.