Schema | Excel MCP Server

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

Name	Description
apply_formula	Apply Excel formula to cell. Excel formula will write to cell with verification.
validate_formula_syntax	Validate Excel formula syntax without applying it.
format_range	Apply formatting to a range of cells.
read_data_from_excel	`Read data from Excel worksheet with cell metadata including validation rules. Args: filepath: Path to Excel file sheet_name: Name of worksheet start_cell: Starting cell (default A1) end_cell: Ending cell (optional, auto-expands if not provided) preview_only: Whether to return preview only Returns: JSON string containing structured cell data with validation metadata. Each cell includes: address, value, row, column, and validation info (if any).`
write_data_to_excel	`Write data to Excel worksheet. Excel formula will write to cell without any verification. PARAMETERS: filepath: Path to Excel file sheet_name: Name of worksheet to write to data: List of lists containing data to write to the worksheet, sublists are assumed to be rows start_cell: Cell to start writing to, default is "A1"`
create_workbook	Create new Excel workbook.
create_worksheet	Create new worksheet in workbook.
create_chart	Create chart in worksheet.
create_pivot_table	Create pivot table in worksheet.
create_table	Creates a native Excel table from a specified range of data.
copy_worksheet	Copy worksheet within workbook.
delete_worksheet	Delete worksheet from workbook.
rename_worksheet	Rename worksheet in workbook.
get_workbook_metadata	Get metadata about workbook including sheets, ranges, etc.
merge_cells	Merge a range of cells.
unmerge_cells	Unmerge a range of cells.
get_merged_cells	Get merged cells in a worksheet.
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.
get_data_validation_info	`Get all data validation rules in a worksheet. This tool helps identify which cell ranges have validation rules and what types of validation are applied. Args: filepath: Path to Excel file sheet_name: Name of worksheet Returns: JSON string containing all validation rules in the worksheet`
insert_rows	Insert one or more rows starting at the specified row.
insert_columns	Insert one or more columns starting at the specified column.
delete_sheet_rows	Delete one or more rows starting at the specified row.
delete_sheet_columns	Delete one or more columns starting at the specified column.

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Excel MCP Server

Server Configuration

Capabilities

Tools

Prompts

Resources

Latest Blog Posts

MCP directory API