Excel MCP Server

MCP server for reading and writing Excel workbooks without needing Microsoft Excel installed. Lets AI agents create workbooks and worksheets, read and write cell ranges, apply formulas and formatting, and build charts and pivot tables programmatically. Useful for automating spreadsheet generation, reporting, and data entry from an assistant.

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

{
  "type": "object",
  "required": [
    "filepath",
    "sheet_name"
  ],
  "properties": {
    "filepath": {
      "type": "string",
      "description": "Path to the Excel workbook"
    },
    "cell_range": {
      "type": "string",
      "description": "Range to read (e.g. A1:D20)"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    }
  }
}

{
  "type": "object",
  "required": [
    "filepath",
    "sheet_name",
    "data"
  ],
  "properties": {
    "data": {
      "type": "array",
      "items": {
        "type": "array"
      },
      "description": "Two-dimensional array of values to write"
    },
    "filepath": {
      "type": "string",
      "description": "Path to the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    }
  }
}

{
  "type": "object",
  "required": [
    "filepath",
    "sheet_name",
    "cell",
    "formula"
  ],
  "properties": {
    "cell": {
      "type": "string",
      "description": "Target cell (e.g. E2)"
    },
    "formula": {
      "type": "string",
      "description": "Excel formula to apply (e.g. =SUM(A2:D2))"
    },
    "filepath": {
      "type": "string",
      "description": "Path to the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    }
  }
}