Repository files navigation

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.

• 📊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

The server supports three transport methods:

uvx excel-mcp-server stdio

{"mcpServers": {"excel": {"command":"uvx","args": ["excel-mcp-server","stdio"]      }   }}

uvx excel-mcp-server sse

SSE transport connection:

{"mcpServers": {"excel": {"url":"http://localhost:8000/sse",      }   }}

uvx excel-mcp-server streamable-http

Streamable HTTP transport connection:

{"mcpServers": {"excel": {"url":"http://localhost:8000/mcp",      }   }}

When running the server with theSSE or Streamable HTTP protocols, youmust set theEXCEL_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 theFASTMCP_PORT environment variable to control the port the server listens on (default is8000 if not set).

• Example (Windows PowerShell):

  $env:EXCEL_FILES_PATH="E:\MyExcelFiles"$env:FASTMCP_PORT="8007"uvx excel-mcp-server streamable-http

• Example (Linux/macOS):

  EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8007 uvx excel-mcp-server streamable-http

When using thestdio protocol, the file path is provided with each tool call, so you donot need to setEXCEL_FILES_PATH on the server. The server will use the path sent by the client for each operation.

The server provides a comprehensive set of Excel manipulation tools. SeeTOOLS.md for complete documentation of all available tools.

MIT License - seeLICENSE for details.