Xlwings MCP server
io.github.geniuskey/mcp-server-xlwings·v0.4.1·1 starsExcel automation via xlwings COM. DRM-protected files, live sessions, VBA macros. Windows only.
1 stars26 downloads/wk
Reviews
Write oneNobody has reviewed Xlwings yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Xlwings tools (11, 2 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
find_replaceSearch for text in a sheet, optionally replacing it.
format_rangeApply formatting to a cell range.
get_active_workbookGet the currently active workbook info including sheets, active sheet, and current selection address with its data.
get_cell_stylesGet formatting/style info for cells in a range. Returns only cells with non-default styles. Useful for identifying headers, subtotals, and data roles by visual formatting.
get_formulasGet all formulas in a range. Returns only cells that contain formulas.
get_objectsList charts, images, and shapes on a sheet.
manage_sheetsManage sheets and structure.
manage_workbooksManage Excel workbooks: list, open, save, close, or recalculate.
read_dataRead data from an Excel range. When cell_range is omitted, returns a sheet summary (used range address, total rows/columns, headers) WITHOUT reading all data -- call again with a specific cell_range to fetch the actual data. Set detail=True on a single cell to get formula, type, and formatting info. Use sheet="*" to batch-read all sheets in one call.
run_macrowrite actionRun a VBA macro in Excel and return its result.
write_datawrite actionWrite data or a formula to Excel cells. Provide 'data' for a 2D array, or 'formula' for a single-cell formula.
Public scan report
scanner v0.1.10 · 2026-09-28 · same rubric, same numbers if you re-run it
- Code scan8 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitylocal package, no credentials required12/15
- Maintenancelast push 211 days ago4/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
How Xlwings compares
Against every graded MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 75/100
- higher than 45% of 48,255 servers
- Tools
- 11
- the typical server has 7
- Tools that change things
- 18%
- typical: 0%. Fewer write tools means less an agent can break
- GitHub stars
- 1
- more than 65% of 28,688 servers
- Downloads a week
- 26
- more than 13% of 12,191 servers with a package
What its tools let an agent do: 9 read · 1 create · 1 run or deploy
Install Xlwings in Claude Code, Cursor or VS Code
claude mcp add mcp-server-xlwings -- uvx mcp-server-xlwings
What the publisher says
From the Xlwings repository's README, as published. We do not edit it. Read it on GitHub
mcp-server-xlwings
MCP server for Excel automation via xlwings COM. Works with DRM-protected files.
Why xlwings?
Libraries like openpyxl or pandas read .xlsx files directly from disk. This fails when:
- DRM / file-level encryption is applied (common in enterprise environments)
- You need to interact with a live Excel session (formulas, macros, add-ins)
- Files are locked by another process
mcp-server-xlwings uses COM automation to talk to the running Excel process, so it can read and write any file that Excel itself can open -- including DRM-protected documents.
xlwings-exclusive capabilities
These features are impossible with file-based libraries like openpyxl:
- Read the user's current selection -- see exactly what the user is looking at
- Get the active workbook -- no need to specify a file path
- Run VBA macros -- execute existing macros and get their return values
- Live formula results -- set a formula and get the calculated value immediately
- Force recalculation -- trigger Excel to recalculate all formulas
Installation
With uvx (recommended)
uvx mcp-server-xlwingsWith pip
pip install mcp-server-xlwingsConfiguration
Claude Desktop
Add to %APPDATA%\Claude\claudedesktopconfig.json:
{
"mcpServers": {
"xlwings": {
"command": "uvx",
"args": ["mcp-server-xlwings"]
}
}
}Claude Code
claude mcp add xlwings -- uvx mcp-server-xlwingsRoo Code (VS Code)
Add to Roo Code MCP settings or create /.roo/mcp.json:
{
"mcpServers": {
"xlwings": {
"command": "uvx",
"args": ["mcp-server-xlwings"]
}
}
}Cursor
Add to %USERPROFILE%\.cursor\mcp.json:
{
"mcpServers": {
"xlwings": {
"command": "uvx",
"args": ["mcp-server-xlwings"]
}
}
}Windsurf
Add to %USERPROFILE%\.codeium\windsurf\mcp_config.json:
{
"mcpServers": {
"xlwings": {
"command": "uvx",
"args": ["mcp-server-xlwings"]
}
}
}Continue (VS Code)
Add to ~/.continue/config.yaml:
mcpServers:
- name: xlwings
command: uvx
args:
- mcp-server-xlwingsAvailable Tools (11)
All tools default to the active workbook when workbook is omitted.
Examples
See what the user is working on
"What's in the spreadsheet I have open?"
The agent calls getactiveworkbook() to get the workbook name, sheets, and selection data, then read_data() to fetch the full sheet.
Summarize selected data
"Summarize the data I've selected"
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
Xlwings: common questions
- Is Xlwings MCP server safe?
- Mostly: it is graded B (75/100). Read the Xlwings safety report
- How do I install Xlwings?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Xlwings need an API key?
- Not as far as the registry entry and our scan can tell: no credentials are declared or required.
- Is Xlwings maintained?
- The last commit was 248 days ago (2026-03-01). The latest release is v0.4.1.
- What can I use instead of Xlwings?
- Servers from other publishers that do the same job: e2e MCP server, Excel MCP Server and Token Optimizer MCP server.
- How does Xlwings compare with other MCP servers?
- safety score 75/100 (higher than 45% of 48,255 servers); tools 11 (the typical server has 7); tools that change things 18% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to Xlwings
Same job from other publishers: the closest match first, then the best rated.
- e2eOpen live web and mobile app sessions from an e2e project to inspect the app and try locators.not reviewedWidely usedA
- Excel MCP ServerCreate and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.not reviewedWidely usedA
- Token OptimizerContext-window optimization: caching, compression & smart file tools that cut tokens 60-90%.not reviewedEstablishedC