Excel Mcp Server
What is Excel Mcp Server
excel_mcp_server is a lightweight Model Context Protocol (MCP) server designed for automating Excel tasks using natural language prompts, powered by OpenAI’s ChatGPT (GPT-4o).
Use cases
Use cases include automating report generation, creating and modifying spreadsheets, executing complex workflows involving multiple Excel operations, and enhancing productivity through natural language commands.
How to use
To use excel_mcp_server, clone the repository, set up a virtual environment, install the required packages, and run the backend server followed by the Streamlit frontend to interact with Excel.
Key features
Key features include a FastAPI backend for Excel operations, natural language processing with GPT-4o, multi-tool call execution for workflows, a user-friendly Streamlit frontend, and minimal setup requirements.
Where to use
excel_mcp_server can be used in various fields such as data analysis, business automation, educational tools, and any domain where Excel is utilized for data management.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Excel Mcp Server
excel_mcp_server is a lightweight Model Context Protocol (MCP) server designed for automating Excel tasks using natural language prompts, powered by OpenAI’s ChatGPT (GPT-4o).
Use cases
Use cases include automating report generation, creating and modifying spreadsheets, executing complex workflows involving multiple Excel operations, and enhancing productivity through natural language commands.
How to use
To use excel_mcp_server, clone the repository, set up a virtual environment, install the required packages, and run the backend server followed by the Streamlit frontend to interact with Excel.
Key features
Key features include a FastAPI backend for Excel operations, natural language processing with GPT-4o, multi-tool call execution for workflows, a user-friendly Streamlit frontend, and minimal setup requirements.
Where to use
excel_mcp_server can be used in various fields such as data analysis, business automation, educational tools, and any domain where Excel is utilized for data management.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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.
✨ 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
- Clone this repo:
git clone https://github.com/vijjeswarapusuryateja/excel_mcp_server.git
cd excel_mcp_server
- Create a virtual environment:
python3 -m venv venv
source venv/bin/activate # Mac/Linux
venv\Scripts\activate # Windows
- Install required packages:
pip install -r requirements.txt
- Run the backend server:
python excel_mcp_server.py
- 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!
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
