Community · by haris-musa

Excel MCP server

The Excel MCP server lets an AI assistant create, read, edit and analyse Excel workbooks, charts and pivot tables.

  • Hosted (remote) · Runs locally
  • MIT licence
  • ★ 4,247 on GitHub
  • Verified against its source 19 Oct 2026

What the Excel MCP server does

An assistant can create, describe, import and export workbooks, read and write cell ranges, sort, find and replace cells, and add charts, sparklines and pivot tables. It can also trace formulas, run Goal Seek to change an input until a formula reaches a chosen value, and read VBA macros, though writing VBA modules is only available when the server is started with --allow-vba-write. It can run locally over stdio using uvx excel-mcp-server stdio, or as a streamable-http server that clients connect to at http://127.0.0.1:8017/mcp.

Tools it gives your assistant

9 tools or toolsets, as its documentation lists them.

  • create_workbook Creates a new workbook
  • describe_workbook Describes a workbook
  • read_range Reads cell values from a range
  • write_range Writes values to a range
  • create_chart Creates charts
  • create_pivot_table Creates PivotTables
  • trace_formula Traces formula precedents and dependents
  • goal_seek Changes an input until a formula reaches a target value
  • read_vba Reads VBA code in .xlsm files

How to install it

Hosted server

Add this address to your assistant's MCP settings:

http://127.0.0.1:8017/mcp

Run it locally

With uv (uvx)

uvx excel-mcp-server stdio

With uv (uvx)

uvx excel-mcp-server streamable-http --allow-dir /srv/workbooks

What you need

In the documentation's own words:

  • “Clients then send Authorization: Bearer change-me. Put a TLS-terminating reverse proxy in”
  • “You need uv (https://docs.astral.sh/uv/getting-started/installation/)”
  • “The server listens on localhost only. To accept other machines, set a token and a host”

Commands and settings change between versions. Check the official instructions before you install.