X

excel-mcp-server

Rating

ALL
5.0
Correctness
5.0
Helpfulness
5.0
Interesting
5.0

Information

Excel MCP Server Logo

[![PyPI version](https://img.shields.io/pypi/v/excel-mcp-server.svg)](https://pypi.org/project/excel-mcp-server/) [![Total Downloads](https://static.pepy.tech/badge/excel-mcp-server)](https://pepy.tech/project/excel-mcp-server) [![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT) [![smithery badge](https://smithery.ai/badge/@haris-musa/excel-mcp-server)](https://smithery.ai/server/@haris-musa/excel-mcp-server) [![Install MCP Server](https://cursor.com/deeplink/mcp-install-dark.svg)](https://cursor.com/install-mcp?name=excel-mcp-server&config=eyJjb21tYW5kIjoidXZ4IGV4Y2VsLW1jcC1zZXJ2ZXIgc3RkaW8ifQ%3D%3D) A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent. ## Features - **Excel Operations**: Create, read, update workbooks and worksheets - **Data Manipulation**: Formulas, formatting, charts, pivot tables, and Excel tables - **Data Validation**: Built-in validation for ranges, formulas, and data integrity - **Formatting**: Font styling, colors, borders, alignment, and conditional formatting - **Table Operations**: Create and manage Excel tables with custom styling - **Chart Creation**: Generate various chart types (line, bar, pie, scatter, etc.) - **Pivot Tables**: Create dynamic pivot tables for data analysis - **Sheet Management**: Copy, rename, delete worksheets with ease - **Triple transport support**: stdio, SSE (deprecated), and streamable HTTP - **Remote & Local**: Works both locally and as a remote service ## Usage The server supports three transport methods: ### 1. Stdio Transport (for local use) \`\`\`bash uvx excel-mcp-server stdio \`\`\` \`\`\`json \{ "mcpServers": \{ "excel": \{ "command": "uvx", "args": ["excel-mcp-server", "stdio"] \} \} \} \`\`\` ### 2. SSE Transport (Server-Sent Events - Deprecated) \`\`\`bash uvx excel-mcp-server sse \`\`\` **SSE transport connection**: \`\`\`json \{ "mcpServers": \{ "excel": \{ "url": "http://localhost:8000/sse", \} \} \} \`\`\` ### 3. Streamable HTTP Transport (Recommended for remote connections) \`\`\`bash uvx excel-mcp-server streamable-http \`\`\` **Streamable HTTP transport connection**: \`\`\`json \{ "mcpServers": \{ "excel": \{ "url": "http://localhost:8000/mcp", \} \} \} \`\`\` ## Environment Variables & File Path Handling ### SSE and Streamable HTTP Transports When running the server with the **SSE or Streamable HTTP protocols**, you **must set the \`EXCEL_FILES_PATH\` environment variable on the server side**. This variable tells the server where to read and write Excel files. - If not set, it defaults to \`./excel_files\`. You can also set the \`FASTMCP_PORT\` environment variable to control the port the server listens on (default is \`8017\` if not set). - Example (Windows PowerShell): \`\`\`powershell $env:EXCEL_FILES_PATH="E:\MyExcelFiles" $env:FASTMCP_PORT="8007" uvx excel-mcp-server streamable-http \`\`\` - Example (Linux/macOS): \`\`\`bash EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8007 uvx excel-mcp-server streamable-http \`\`\` ### Stdio Transport When using the **stdio protocol**, the file path is provided with each tool call, so you do **not** need to set \`EXCEL_FILES_PATH\` on the server. The server will use the path sent by the client for each operation. ## Available Tools The server provides a comprehensive set of Excel manipulation tools. See [TOOLS.md](TOOLS.md) for complete documentation of all available tools. ## Star History [![Star History Chart](https://api.star-history.com/svg?repos=haris-musa/excel-mcp-server&type=Date)](https://www.star-history.com/#haris-musa/excel-mcp-server&Date) ## License MIT License - see [LICENSE](LICENSE) for details.

Prompts

Reviews

Tags


  • AI Hub Admin 2025-08-25 17:48
    5.0
    Interesting:5,Helpfulness:5,Correctness:5

    The python based excel mcp server is a useful tool for local spreadsheet management. For example, if you want to create a workbook named "test.xlsx" and write a data list to the "demo" sheet, you can call the tool in consecutive orders. Note that the local mode takes absolute path as input. Security Concern: Since the excel mcp server have privilege to create workbook and write data to local disk, there is security check necessary for the input contents to avoid scripts or sql injection or other hazardous contents. 1. create_workbook filepath : /Users/xxxxxx/Desktop/workspace/github/mcp-marketplace-local/app/mcp_tool_use/workspace/USER_1234/test.xlsx sheetname: demo 2. create_worksheet filepath : /Users/xxxxxx/Desktop/workspace/github/mcp-marketplace-local/app/mcp_tool_use/workspace/USER_1234/test.xlsx sheetname: demo 3. Add Data filepath: /Users/xxxxxx/Desktop/workspace/github/mcp-marketplace-local/app/mcp_tool_use/workspace/USER_1234/test.xlsx sheetname : test data: [[1,2,3,4]] start_cell:A1

    1
    0
    Follow
    Share

Write Your Review

Detailed Ratings

ALL
Correctness
Helpfulness
Interesting
Upload Pictures and Videos

Name
Size
Type
Download
Last Modified
tool_excel_mcp_server.json
25.0 KB
json
2025-08-25
mcp_config_haris-musa_excel.json
127.0 B
json
2025-08-25

  • Community

Add Discussion

Upload Pictures and Videos