Excel MCP Server

Workbook Operations

create_workbook

Creates a new Excel workbook

get_workbook_metadata

Get metadata about workbook including sheets and ranges

Data Operations

write_data_to_excel

Write data to Excel worksheet with intelligent header handling

read_data_from_excel

Read data from Excel worksheet with optional preview mode

Formatting Operations

format_range

Apply comprehensive formatting to cell ranges including fonts, colors, borders, alignment, and conditional formatting

merge_cells

Merge a range of cells

unmerge_cells

Unmerge a previously merged range of cells

Formula Operations

apply_formula

Apply Excel formula to cell

validate_formula_syntax

Validate Excel formula syntax without applying it

Chart Operations

create_chart

Create charts in worksheet supporting line, bar, pie, scatter, and area chart types

Pivot Table Operations

create_pivot_table

Create pivot table in worksheet with multiple aggregation functions (sum, count, average, max, min)

Worksheet Operations

create_worksheet

Creates a new worksheet in an existing workbook

copy_worksheet

Copy worksheet within workbook

delete_worksheet

Delete worksheet from workbook

rename_worksheet

Rename worksheet in workbook

Range Operations

copy_range

Copy a range of cells to another location

delete_range

Delete a range of cells and shift remaining cells

validate_excel_range

Validate if a range exists and is properly formatted

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