file-spreadsheet

Excel MCP Server

MCP server for Excel file manipulation

excelspreadsheetofficedata

About

## Excel MCP Server: Spreadsheet Operations The **Excel MCP Server** integrates Microsoft Excel capabilities into Google Antigravity, enabling developers to read, write, and manipulate Excel spreadsheets through AI-assisted data operations. ### Why Excel MCP? - **Full Compatibility**: Work with .xlsx, .xls, and .csv files - **Formula Support**: Read and write Excel formulas - **Formatting**: Preserve and modify cell formatting - **Charts**: Create and modify Excel charts - **Large Files**: Handle large spreadsheets efficiently ### Key Features #### 1. Reading and Writing Data ```python # Read spreadsheet data data = await excel.readSheet({ "filePath": "/path/to/workbook.xlsx", "sheet": "Sales Data", "range": "A1:Z100", "headers": True }) for row in data.rows: print(f"Product: {row.Product}, Revenue: {row.Revenue}") # Write data to spreadsheet await excel.writeSheet({ "filePath": "/path/to/workbook.xlsx", "sheet": "Summary", "startCell": "A1", "data": [ ["Month", "Revenue", "Expenses", "Profit"], ["January", 50000, 30000, "=B2-C2"], ["February", 55000, 32000, "=B3-C3"] ] }) ``` #### 2. Formatting and Charts ```python # Apply formatting await excel.formatCells({ "filePath": "/path/to/workbook.xlsx", "sheet": "Summary", "range": "A1:D1", "format": { "bold": True, "backgroundColor": "#4472C4", "fontColor": "#FFFFFF" } }) # Create chart await excel.createChart({ "filePath": "/path/to/workbook.xlsx", "sheet": "Summary", "type": "column", "dataRange": "A1:D4", "title": "Monthly Financial Summary", "position": "F2" }) # Add formula await excel.setFormula({ "filePath": "/path/to/workbook.xlsx", "sheet": "Summary", "cell": "D5", "formula": "=SUM(D2:D4)" }) ``` ### Configuration ```json { "mcpServers": { "excel": { "command": "npx", "args": ["-y", "@anthropic/mcp-excel"], "env": { "EXCEL_TEMP_DIR": "/tmp/excel-processing" } } } } ``` ### Use Cases **Report Generation**: Create formatted Excel reports from application data. **Data Import**: Read data from Excel files for processing and analysis. **Template Population**: Fill Excel templates with dynamic data. The Excel MCP Server brings powerful spreadsheet capabilities to your development workflow.

Installation

Configuration

{
  "mcpServers": {
    "excel": {
      "mcpServers": {
        "excel": {
          "args": [
            "-y",
            "excel-mcp-server"
          ],
          "command": "npx"
        }
      }
    }
  }
}