excel-mcp-server
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
excel-mcp-server
An MCP server that lets an AI coding agent work with Excel and CSV files:
inspect a workbook, merge a folder of CSVs, clean a messy workbook, and
convert between .csv and .xlsx.
It speaks the Model Context Protocol over stdio, so it plugs straight into Claude Code, Cursor, Claude Desktop and any other MCP client. The merge check is borrowed from csv-merge-check: rows in must equal rows out.
Tools
Tool | What it does |
| Sheets, headers, data-row counts and the first rows. Read-only. |
| Merge every |
| Write a cleaned copy: trim whitespace, collapse header whitespace, drop blank rows and exact-duplicate rows. |
| Convert a |
| Convert one sheet of an |
Related MCP server: Excel MCP Server
What it does not do
It never overwrites its input. Cleaning, merging and conversion always write a new file and refuse when the output path is the input file.
It does not preserve cell formatting when cleaning. The cleaned workbook keeps values, not styles.
It does not guess missing values, repair dates or parse currency amounts.
It does not read anything except the file paths the caller passes, and it makes no network requests.
What you need
Python 3.10 or newer
pip install excel-mcp-server(or clone this repo andpip install -e .)
1. Install
pip install excel-mcp-serverOr from source:
git clone https://github.com/hwu121380-afk/excel-mcp-server.git
cd excel-mcp-server
python -m venv .venv
source .venv/bin/activate # Windows: .venv\Scripts\activate
pip install -e .2. Connect it to your agent
Claude Code:
claude mcp add excel-mcp-server -- excel-mcp-serverClaude Desktop (claude_desktop_config.json):
{
"mcpServers": {
"excel-mcp-server": {
"command": "excel-mcp-server"
}
}
}If you installed from source, use the full path to the virtual environment's
binary instead of excel-mcp-server, for example
/home/you/excel-mcp-server/.venv/bin/excel-mcp-server.
3. Try it
Ask your agent something like:
Inspect
sample_input/orders.xlsx, then clean it intosample_input/orders_clean.xlsxand tell me how many duplicates it had.
Or try the merge check on the bundled samples:
Merge the CSVs in
sample_input/intomerged.csvand check the row counts.
The files in sample_input/ are SAMPLE – FICTIONAL DATA. They are not
from a real shop or a real customer.
Development
pip install -e ".[dev]"
python -m pytest -q中文简介
这是一个 MCP 服务器,让 AI 编程助手能直接操作 Excel 和 CSV 文件:查看表 格结构、合并一文件夹的 CSV、清洗脏数据(去重、去空格、去空行)、CSV 和 xlsx 互转。清洗与合并永远写新文件,绝不覆盖原文件,适合接单时处理客户 发来的表格,也适合放进简历。
License
MIT. See LICENSE.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.
Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.
File tools for your AI chat: PDF tables to Excel, merge PDFs, images to PDF, fill PDF forms.
Write Excel .xlsx from rows, read spreadsheets or CSV from a URL, extract text from PDFs
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to create, read, and modify Excel workbooks without requiring Microsoft Excel, supporting operations like formulas, charts, pivot tables, formatting, and data validation.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to create, read, and manipulate Excel workbooks without Microsoft Excel installed, supporting formulas, formatting, charts, pivot tables, and data validation operations.MIT
- AlicenseBqualityBmaintenanceEnables LLMs to work with Excel and CSV files through structured tools for workbook operations, formatting, charts, ETL, analysis, and more.695MIT
- AlicenseAqualityBmaintenance50 tools and 400 functions for working with Excel/.xlsx spreadsheets — read/write, recalculate formulas, diff, repair broken references, and audit. Built for AI agents.503,087 npm6MIT