概览
What is Excel MCP Server?
A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. It allows AI agents to create, read, and modify Excel workbooks.
How to use Excel MCP Server?
Clone the repository and install with uv pip install -e .. Start the server with uv run excel-mcp-server (default port 8000). Configure the EXCEL_FILES_PATH environment variable to specify where Excel files are stored.
Key features of Excel MCP Server
- Create and modify Excel workbooks
- Read and write data
- Apply formatting and styles
- Create charts and visualizations
- Generate pivot tables
- Manage worksheets and ranges
Use cases of Excel MCP Server
- Creating and modifying Excel workbooks without Excel installed
- Reading and writing data in spreadsheets via an AI agent
- Applying formatting and styles to cells automatically
- Generating charts and pivot tables on demand
- Managing worksheets and named ranges programmatically