Excel MCP Server for VS Code: Setup & Config

What you can do with Excel in VS Code

Pick it for workbook editing, charts, and pivot tables without installing Microsoft Excel.

• Create workbooks and manage worksheet names or copies.
• Build charts and pivot tables for data analysis.

Before you start: Excel in VS Code

• uvx
• An MCP-compatible client

Stdio accepts a path in each tool call. For remote operation use the documented streamable-http mode, configure EXCEL_FILES_PATH, and keep tool paths relative to that directory. SSE is deprecated.

Excel VS Code configuration

1. Choose VS Code configuration scope

   For Excel MCP Server, open Workspace: .vscode/mcp.json. Merge into servers; preserve existing inputs.

2. Add Excel MCP Server to VS Code

   Use the excel-mcp-server entry below in servers. Keep Excel MCP Server's documented stdio connection fields and your other VS Code entries.

3. Check Excel MCP Server in VS Code

   Excel MCP Server: Start in VS Code’s MCP controls; inspect output and trust prompts.

{
  "servers": {
    "excel-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "excel-mcp-server",
        "stdio"
      ],
      "env": {}
    }
  }
}

Troubleshooting Excel in VS Code

• Make uvx excel-mcp-server (from uv, for Python tools) available in the workspace, container, or remote environment hosting Excel MCP Server. Start through VS Code's MCP controls; inspect output and trust prompts.
• Excel MCP Server uses stdio here: VS Code must keep the configured process running; protocol output belongs on stdout and diagnostics on stderr.
• Known limitation: SSE is deprecated.
• Known limitation: The supplied README delegates individual tool details to a separate document.
• Known limitation: Example connection ports differ from the stated default port.
• General VS Code troubleshooting lives in the /clients/vscode guide.

Frequently asked questions