Excel MCP Server

1<p align="center">
2  <img src="https://raw.githubusercontent.com/haris-musa/excel-mcp-server/main/assets/logo.png" alt="Excel MCP Server Logo" width="300"/>
3</p>
4 
5[![PyPI version](https://img.shields.io/pypi/v/excel-mcp-server.svg)](https://pypi.org/project/excel-mcp-server/)
6[![Total Downloads](https://static.pepy.tech/badge/excel-mcp-server)](https://pepy.tech/project/excel-mcp-server)
7[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)
8[![smithery badge](https://smithery.ai/badge/@haris-musa/excel-mcp-server)](https://smithery.ai/server/@haris-musa/excel-mcp-server)
9[![Install MCP Server](https://cursor.com/deeplink/mcp-install-dark.svg)](https://cursor.com/install-mcp?name=excel-mcp-server&config=eyJjb21tYW5kIjoidXZ4IGV4Y2VsLW1jcC1zZXJ2ZXIgc3RkaW8ifQ%3D%3D)
10 
11A 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.
12 
13## Features
14 
15- 📊 **Excel Operations**: Create, read, update workbooks and worksheets
16- 📈 **Data Manipulation**: Formulas, formatting, charts, pivot tables, and Excel tables
17- 🔍 **Data Validation**: Built-in validation for ranges, formulas, and data integrity
18- 🎨 **Formatting**: Font styling, colors, borders, alignment, and conditional formatting
19- 📋 **Table Operations**: Create and manage Excel tables with custom styling
20- 📊 **Chart Creation**: Generate various chart types (line, bar, pie, scatter, etc.)
21- 🔄 **Pivot Tables**: Create dynamic pivot tables for data analysis
22- 🔧 **Sheet Management**: Copy, rename, delete worksheets with ease
23- 🔌 **Triple transport support**: stdio, SSE (deprecated), and streamable HTTP
24- 🌐 **Remote & Local**: Works both locally and as a remote service
25 
26## Usage
27 
28The server supports three transport methods:
29 
30### 1. Stdio Transport (for local use)
31 
32```bash
33uvx excel-mcp-server stdio
34```
35 
36```json
37{
38   "mcpServers": {
39      "excel": {
40         "command": "uvx",
41         "args": ["excel-mcp-server", "stdio"]
42      }
43   }
44}
45```
46 
47### 2. SSE Transport (Server-Sent Events - Deprecated)
48 
49```bash
50uvx excel-mcp-server sse
51```
52 
53**SSE transport connection**:
54```json
55{
56   "mcpServers": {
57      "excel": {
58         "url": "http://localhost:8000/sse",
59      }
60   }
61}
62```
63 
64### 3. Streamable HTTP Transport (Recommended for remote connections)
65 
66```bash
67uvx excel-mcp-server streamable-http
68```
69 
70**Streamable HTTP transport connection**:
71```json
72{
73   "mcpServers": {
74      "excel": {
75         "url": "http://localhost:8000/mcp",
76      }
77   }
78}
79```
80 
81## Environment Variables & File Path Handling
82 
83### SSE and Streamable HTTP Transports
84 
85When 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.
86- If not set, it defaults to `./excel_files`.
87 
88You can also set the `FASTMCP_PORT` environment variable to control the port the server listens on (default is `8017` if not set).
89- Example (Windows PowerShell):
90  ```powershell
91  $env:EXCEL_FILES_PATH="E:\MyExcelFiles"
92  $env:FASTMCP_PORT="8007"
93  uvx excel-mcp-server streamable-http
94  ```
95- Example (Linux/macOS):
96  ```bash
97  EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8007 uvx excel-mcp-server streamable-http
98  ```
99 
100### Stdio Transport
101 
102When 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.
103 
104## Available Tools
105 
106The server provides a comprehensive set of Excel manipulation tools. See [TOOLS.md](TOOLS.md) for complete documentation of all available tools.
107 
108## Star History
109 
110[![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)
111 
112## License
113 
114MIT License - see [LICENSE](LICENSE) for details.
115