Excel MCP Server

Excel manipulation including data reading/writing, worksheet management, formatting, charts, and pivot table

Local serverstdio

What is the Excel MCP Server?

Excel mcp server lets Claude, Cursor and other MCP clients work with Excel directly. Excel manipulation including data reading/writing, worksheet management, formatting, charts, and pivot table.

What Excel does

A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent.

Key capabilities

  • 📊 Excel Operations: Create, read, update workbooks and worksheets
  • 📈 Data Manipulation: Formulas, formatting, charts, pivot tables, and Excel tables
  • 🔍 Data Validation: Built-in validation for ranges, formulas, and data integrity
  • 🎨 Formatting: Font styling, colors, borders, alignment, and conditional formatting
  • 📋 Table Operations: Create and manage Excel tables with custom styling
  • 📊 Chart Creation: Generate various chart types (line, bar, pie, scatter, etc.)
  • 🔄 Pivot Tables: Create dynamic pivot tables for data analysis
  • 🔧 Sheet Management: Copy, rename, delete worksheets with ease

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
AreaTools
Workbookscreate_workbook, describe_workbook, list_workbooks, export_workbook, import_workbook
Sheetsdescribe_sheet, create_sheet, rename_sheet, copy_sheet, delete_sheet, insert_rows_or_columns, delete_rows_or_columns
Cellsread_range, write_range, clear_range, copy_range, find_cells
Formattingformat_range, merge_cells, set_sheet_layout, add_conditional_format, add_data_validation
Objectscreate_table, create_chart, create_summary_table
Macrosread_vba

How to install the Excel MCP Server

{
  "mcpServers": {
    "excel": {
      "command": "uvx",
      "args": [
        "excel-mcp-server",
        "stdio",
        "--allow-dir",
        "/path/to/workbooks"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Frequently asked questions

Excel manipulation including data reading/writing, worksheet management, formatting, charts, and pivot table Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.