How do I install the mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

SSyncDev

Start a project

MCP Server — geniuskey/mcp-server-xlwings

Excel automation via xlwings COM. DRM-protected files, live sessions, VBA macros. Windows only.

Local serverstdioPython

What is the MCP Server?

Excel automation via xlwings COM. DRM-protected files, live sessions, VBA macros. Windows only.

What the server does

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

Credentials and setup notes

Windows (Excel COM automation is Windows-only) - Microsoft Excel installed - Python 3.10+

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
get_active_workbook	Get active workbook info, sheets, and current selection with data
manage_workbooks	List, open, save, close, or recalculate workbooks
read_data	Read a range with merge_info, header_row, sheet="*" batch read, and detail mode
write_data	Write a 2D array (data) or a single-cell formula (formula)
manage_sheets	List, add, delete, rename, copy, activate sheets. Insert/delete rows and columns
find_replace	Search for text, optionally replace it
format_range	Apply formatting (bold, italic, color, borders, alignment, number format, etc.)
run_macro	Execute a VBA macro and get its return value
get_formulas	Get all formulas in a range with optional calculated values
get_cell_styles	Get formatting/style info (bold, colors, borders, etc.) for cells in a range
get_objects	List charts, images, and shapes on a sheet

How to install the MCP Server

{
  "mcpServers": {
    "xlwings": {
      "command": "uvx",
      "args": ["mcp-server-xlwings"]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

Windows (Excel COM automation is Windows-only) - Microsoft Excel installed - Python 3.10+

Example prompts to try

“Use MCP to get active workbook.”
“Use MCP to manage workbooks.”
“Use MCP to read data.”

Frequently asked questions

Excel automation via xlwings COM. DRM-protected files, live sessions, VBA macros. Windows only. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.