Excel MCP Server 🚀
About
# Excel MCP Server 🚀 This project implements a lightweight **Model Context Protocol (MCP)** server for Excel automation, powered by **OpenAI's ChatGPT (GPT-4o)**. You can create, edit, and automate Excel files through natural language prompts, with GPT translating your intent into structured tool calls. --- ## ✨…
Explore
- Lightweight FastAPI backend exposing Excel operations as MCP tools
- Natural language prompt handling with GPT-4o orchestration
- Multi-tool call execution (supports workflows like creating sheets + writing cells)
- Streamlit frontend to interact easily
- Minimal setup — no complex SDKs required
---
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Excel MCP Server 🚀Command (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Run the backend (python excel_mcp_server.py) and the Streamlit frontend (streamlit run frontend.py) after cloning the repository, creating a virtual environment, and installing dependencies from requirements.txt. No complex SDKs are required.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"excel mcp server \ud83d\ude80": {
"excel_mcp_server": {
"command": "python3",
"args": [
"-m",
"venv",
"venv"
]
}
}
}
}McpServers
{
"excel_mcp_server": {
"command": "python3",
"args": [
"-m",
"venv",
"venv"
]
}
}This project implements a lightweight Model Context Protocol (MCP) server for Excel automation, powered by OpenAI's ChatGPT (GPT-4o).
You can create, edit, and automate Excel files through natural language prompts, with GPT translating your intent into structured tool calls.
---
✨ Features
- Lightweight FastAPI backend exposing Excel operations as MCP tools
- Natural language prompt handling with GPT-4o orchestration
- Multi-tool call execution (supports workflows like creating sheets + writing cells)
- Streamlit frontend to interact easily
- Minimal setup — no complex SDKs required
---
📦 Project Structure
| File | Purpose |
|:--|:--|
| excel_mcp_server.py | FastAPI backend with Excel MCP tools and GPT integration |
| frontend.py | Streamlit frontend for chatting with Excel |
| requirements.txt | (Coming soon) List of Python dependencies |
---
🚀 How to Run Locally
1. Clone this repo:
git clone https://github.com/vijjeswarapusuryateja/excel_mcp_server.git
cd excel_mcp_server
2. Create a virtual environment:
python3 -m venv venv
source venv/bin/activate # Mac/Linux
venv\Scripts\activate # Windows
3. Install required packages:
pip install -r requirements.txt
4. Run the backend server:
python excel_mcp_server.py
5. In a new terminal, run the frontend:
streamlit run frontend.py
---
📚 Related Article
I wrote a full Medium article explaining the architecture, how I built this project, and what I learned about MCP:
---
🧐 Future Improvements
- Dockerize backend + frontend
- Add batch writing tools
- Add style formatting (bold, colors)
- Support uploading/downloading Excel files through API
---
📜 License
MIT License
---
🌟 If you found this project useful, give it a ⭐ star and feel free to fork/extend!
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
