Excel MCP Server for Claude Desktop: Setup & Config

What you can do with Excel in Claude Desktop

Inspect and change workbook ranges with formulas, tables, and per-cell styles in the same integration.

• Find workbook sheets, then inspect a bounded range before making changes.
• Review formulas or style metadata instead of reading only displayed values.
• Populate a new sheet and give its data a named table range.

Before you start: Excel in Claude Desktop

• Node.js version 20.x or above
• MCP client able to launch the npm package

The command and flags match the README configuration for other platforms. Its Windows configuration instead launches cmd with /c, then npx and the same package flags. Tool calls use an absolute workbook path. The paging environment key is documented with a default value of 4000.

Excel Claude Desktop configuration

1. Choose Claude Desktop configuration scope

   For Excel MCP Server, open macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json. Merge under mcpServers via Settings → Developer → Edit Config when available.

2. Add Excel MCP Server to Claude Desktop

   Use the excel-mcp-server-negokaz entry below in mcpServers. Keep Excel MCP Server's documented stdio connection fields and your other Claude Desktop entries.

3. Check Excel MCP Server in Claude Desktop

   Excel MCP Server: Fully quit and reopen Claude Desktop; check developer diagnostics.

{
  "mcpServers": {
    "excel-mcp-server-negokaz": {
      "command": "npx",
      "args": [
        "--yes",
        "@negokaz/excel-mcp-server"
      ],
      "env": {
        "EXCEL_MCP_PAGING_CELLS_LIMIT": "<optional page-size ceiling in cells; documented default is 4000>"
      }
    }
  }
}

Excel tools available to Claude Desktop

Excel's stored tool list documents 7 tools; compare it with Claude Desktop's connected tool list, because the stored list is not a live check.

excel_describe_sheets

When Claude Desktop requests excel_describe_sheets from Excel, review the action before approving it.

Discover the sheet information associated with a workbook file.

excel_read_sheet

When Claude Desktop requests excel_read_sheet from Excel, review the action before approving it.

Inspect a paginated cell range, choosing whether formulas or styling details are included.

excel_copy_sheet

When Claude Desktop requests excel_copy_sheet from Excel, review the action before approving it.

Create a new worksheet by copying a specified source sheet.

excel_write_to_sheet

When Claude Desktop requests excel_write_to_sheet from Excel, review the action before approving it.

Populate a range with values or formulas, with an option to create the destination sheet.

excel_create_table

When Claude Desktop requests excel_create_table from Excel, review the action before approving it.

excel_format_range

When Claude Desktop requests excel_format_range from Excel, review the action before approving it.

excel_screen_capture

When Claude Desktop requests excel_screen_capture from Excel, review the action before approving it.

Excel: full stored tool descriptions

Troubleshooting Excel in Claude Desktop

• Fully quit and reopen Claude Desktop for Excel MCP Server. If npx @negokaz/excel-mcp-server (Node.js/npm) is missing, check the desktop process's PATH, which may differ from your terminal.
• In Claude Desktop's Excel MCP Server entry, check EXCEL_MCP_PAGING_CELLS_LIMIT. Keep secrets out of shared screenshots and repositories.
• Excel MCP Server uses stdio here: Claude Desktop must keep the configured process running; protocol output belongs on stdout and diagnostics on stderr.
• Known limitation: Screenshot capture and live editing are not documented for non-Windows platforms.
• Known limitation: The npm launch requires Node.js 20.x or a newer release.
• General Claude Desktop troubleshooting lives in the /clients/claude-desktop guide.

Frequently asked questions