mcp-excel-server
If you are the rightful owner of mcp-excel-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Node.js server implementing Model Context Protocol (MCP) for excel file operations.
mcp-excel-server
Node.js server implementing Model Context Protocol (MCP) for excel file operations.
Features
- Read files
- list directories
- Search files
- Read Excel
Note: The server will only allow operations within directories specified via args.
๐ง Install
NPM Installation
npm install @qian33/mcp-excel-server
๐ API Reference
Resources
- The primary mcp-excel-server operations interface
file://system
Tool Functions
๐ Reading Operations
- read_file_content
- Reads the complete contents of a file
- Input:
path(string) - Uses UTF-8 encoding for text files
๐Writing Operations
- write_file_content
- Creates a new file or overwrites an existing one with the specified content
- Inputs:
path(string): File location to write tocontent(string): Content to write to the file
- Uses UTF-8 encoding for text files
- Returns confirmation message upon successful write
๐ Directory Operations
- list_directory
- Lists directory contents with type indicators
- Input:
path(string) - Returns entries with [FILE] or [DIR] prefixes
๐ Reading Excel and Information
-
get_excel_content
- Reads the Excel contents of a file
- Input:
path(string) - Uses UTF-8 encoding for excel file
-
get_online_excel_content
- Fetches and reads Excel content from a URL
- Input:
path(string): ONLINE URL to the Excel file - Returns the Excel data as a JSON array
- Useful for reading Excel files hosted on remote servers
๐ Writing Excel
- write_excel_content
- Creates a new Excel file or overwrites an existing one with the specified data
- Inputs:
path(string): File location for the Excel filecontent(string or array): JSON data to write to the Excel file- Accepts either a JSON string or a direct array of objects
- Each object represents a row in the Excel sheet
- Automatically creates a workbook with a 'Sheet1' worksheet
- Returns confirmation message upon successful write
๐ง Usage Guide
Integration with Claude Desktop
Add the following configuration to your : claude_desktop_config.json
Note: You can sandbox directories by mounting them to . Adding the
roflag makes directories read-only./projects
NPX Method
{
"mcpServers": {
"mcp-excel-server": {
"command": "npx",
"args": [
"-y",
"@qian33/mcp-excel-server",
"/Users/username/Desktop",
"/path/to/other/allowed/dir"
]
}
}
}
Bunx Method
{
"mcpServers": {
"mcp-excel-server": {
"command": "bunx",
"args": [
"@qian33/mcp-excel-server",
"/Users/username/Desktop",
"/path/to/other/allowed/dir"
]
}
}
}
Usage with VS Code
For quick installation, click the installation buttons below...
For manual installation, add the following JSON block to your User Settings (JSON) file in VS Code. You can do this by pressing Ctrl + Shift + P and typing Preferences: Open Settings (JSON).
Optionally, you can add it to a file called .vscode/mcp.json in your workspace. This will allow you to share the configuration with others.
Note that the
mcpkey is not needed in the.vscode/mcp.jsonfile.
You can provide sandboxed directories to the server by mounting them to /projects. Adding the ro flag will make the directory readonly by the server.
NPX
{
"mcp": {
"servers": {
"mcp-excel-server": {
"command": "npx",
"args": [
"-y",
"@qian33/mcp-excel-server",
"${workspaceFolder}"
]
}
}
}
}
๐ค Contributing
Contributions are welcome! To contribute:
- Fork the repository
- Create a feature branch
- Implement your changes with tests
- Submit a pull request
Please ensure your code adheres to the project's coding standards and includes appropriate tests.
๐ License
This MCP server is licensed under the MIT License. You are free to use, modify, and distribute the software, subject to the MIT License terms and conditions. See the LICENSE file in the repository for details.
