Install Excel MCP Server

Pick your client, copy the command, done.

Manual setup required. The maintainer's config contains paths only you know - edit the placeholders below before adding it to Claude Code.

Run this once before adding it to Claude Code.

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

claude mcp add excel-mcp -- node /path/to/excel-mcp-server/src/index.js

Replace any placeholder paths in the command with the real path on your machine.

Environment Variables

Set these before running Excel MCP Server.

VariableDescriptionRequired

EXCEL_MCP_PYTHONPath to the specific Python executable to use.No

Once configured, Excel MCP Server gives your AI agent access to:

get_excel_infoRetrieves information about the current Excel environment.

read_cellsReads data from a specified range in an Excel file or workbook.

range

write_cellsWrites values to a specified range in an Excel file or workbook.

rangevalue

format_cellsApplies formatting to a specified range of cells.

rangeformat

execute_vbaExecutes VBA code within an open Excel workbook.

workbookcode

After setup, try these prompts with your AI agent:

→Read the data from range A1:D20 in the file /data/report.xlsx.

→Write the following data to the open workbook Sales.xlsx starting at cell G2: [['Name', 'Age'], ['Alice', 30]].

→Format the range A1:C1 in /data/report.xlsx to have a bold font and a blue background.

→Execute a VBA macro in Sales.xlsx to apply an AutoFilter to the range A1:G10.

Prerequisites & system requirements

An MCP-compatible client (Claude Code, Cursor, Windsurf, Claude Desktop, or Codex)
Node.js 18+ with npm/npx installed
Python 3.8+ with pip installed

Save the docs, env vars, and workflow around Excel MCP Server in Conare so Claude Code, Codex, and Cursor remember it next time.