Excel MCP Server

by kousunh

Not rated
GitHub

About

Interact with Microsoft Excel to read data, edit cells, execute VBA code, and manage worksheets.

Details

Author
kousunh
Categories
Productivity, Other

Setup

Install Excel MCP Server in your MCP client (Claude Desktop, Cursor, Windsurf, and others).

Repository: https://github.com/kousunh/Excel-mcp-server

Follow the installation instructions in the repository README, then restart your MCP client.

A cross-platform MCP server for reading, writing, and formatting Excel files. Works with both open Excel workbooks (live) and closed .xlsx files (no Excel needed).

- workbook— Operate on an open Excel workbook in real-time via xlwings
- path— Edit closed .xlsx files directly using pure Python (preserves images, charts, and all embedded content)

- Node.js18+
- Python3.8+
- xlwings(for live Excel mode —pip install xlwings)
- Microsoft Excel(only needed forworkbookmode andexecute_vba)

Works onWindowsandmacOS. Thepathmode also works on Linux.

git clone https://github.com/kousunh/excel-mcp-server.git cd excel-mcp-server npm install pip install -r scripts/requirements.txt

Add to your MCP client config (Claude Desktop, Cursor, etc.):

{ "mcpServers": { "excel-mcp": { "command": "node", "args": ["/path/to/excel-mcp-server/src/index.js"] } } }

To use a specific Python executable, set theEXCEL_MCP_PYTHONenvironment variable:

{ "mcpServers": { "excel-mcp": { "command": "node", "args": ["/path/to/excel-mcp-server/src/index.js"], "env": { "EXCEL_MCP_PYTHON": "/path/to/python" } } } }
read_cells path="/data/report.xlsx" range="A1:D20" formats=true write_cells path="/data/report.xlsx" range="A1:C3" value=[["Name","Age","City"],["Alice",30,"NYC"],["Bob",25,"LA"]] format_cells path="/data/report.xlsx" range="A1:C1" format={"bold":true,"backgroundColor":"#4472C4","fontColor":"#FFFFFF"}

No Excel installation required. Images, charts, and shapes are preserved.

get_excel_info read_cells workbook="Sales.xlsx" range="B2:F10" write_cells workbook="Sales.xlsx" range="G2" value="=SUM(B2:F2)" execute_vba workbook="Sales.xlsx" code="Range(\"A1:G10\").AutoFilter"

Requires Excel to be running with the workbook open.

Manipulate Excel files (XLSX, XLSM, etc.) without needing Microsoft Excel, featuring an integrated AI assistant.

Read and write data from Microsoft Excel files. Supports text, formulas, sheet creation, and Windows-only live editing.

Parses invoice data, uploads it to Google Sheets, and answers queries by fetching information from the sheet.

AI-native office suite MCP server. Create, read, update docs, spreadsheets, and slides with 23 tools.

Create, read, update docs, spreadsheets, and presentations via AI. Connect your AI assistant to a full office suite.

Create, read, update docs, spreadsheets, and presentations via AI — 23 MCP tools for a full office suite with 74K+ users.

Connect AI assistants to Google Sheets through scoped tools for discovering connections and reading, adding, updating, or deleting rows.

Automated document processing and extraction

Convert files (DOCX, XLSX, PPTX, images), HTML, and Markdown to pixel-perfect PDFs — npx stdio or hosted Streamable HTTP, free API key in one click.

Connect with 10,000+ tools across HRIS, ATS, CRM, Accounting, Calendar, Meeting, Ticketing, and more categories.

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.