Excel MCP Server
| English
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
Installing via NPM
excel-mcp-server can be automatically installed by adding the following configuration to the MCP servers configuration.
Windows Platform:
Other Platforms:
Note: LOG_PATH is optional. If not set, logs will be stored in the 'logs' folder under the application root directory.other arguments are optional.
API Tools
Structure Tools
- analyzeExcelStructure
- exportExcelStructure
Read Tools
- readSheetNames
- readDataBySheetName
- readSheetData
Write Tools
- writeDataBySheetName
- writeSheetData
Cache Tools
- clearFileCache
Configuration
Environment Variables
LOG_PATH: Log files storage path
CACHE_MAX_AGE: Cache expiration time (hours)
CACHE_CLEANUP_INTERVAL: Cache cleanup interval (hours)
LOG_RETENTION_DAYS: Log retention days
LOG_CLEANUP_INTERVAL: Log cleanup interval (hours)
Default Configuration
- Cache Configuration
- Log Configuration
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 are free to:
- Use the software for commercial or non-commercial purposes
- Modify the source code
- Distribute original or modified code Requirements:
- Retain the original copyright notice
- No liability can be claimed against the authors for software use For detailed license information,please see the LICENSE file.
Excel MCP Server
| English
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
Installing via NPM
excel-mcp-server can be automatically installed by adding the following configuration to the MCP servers configuration.
Windows Platform:
Other Platforms:
Note: LOG_PATH is optional. If not set, logs will be stored in the 'logs' folder under the application root directory.other arguments are optional.
API Tools
Structure Tools
- analyzeExcelStructure
- exportExcelStructure
Read Tools
- readSheetNames
- readDataBySheetName
- readSheetData
Write Tools
- writeDataBySheetName
- writeSheetData
Cache Tools
- clearFileCache
Configuration
Environment Variables
LOG_PATH: Log files storage path
CACHE_MAX_AGE: Cache expiration time (hours)
CACHE_CLEANUP_INTERVAL: Cache cleanup interval (hours)
LOG_RETENTION_DAYS: Log retention days
LOG_CLEANUP_INTERVAL: Log cleanup interval (hours)
Default Configuration
- Cache Configuration
- Log Configuration
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 are free to:
- Use the software for commercial or non-commercial purposes
- Modify the source code
- Distribute original or modified code Requirements:
- Retain the original copyright notice
- No liability can be claimed against the authors for software use For detailed license information,please see the LICENSE file.