excel-mcp-server
excel-mcp-server is hosted online, so all tools can be tested directly either in theInspector tabor in theOnline Client.
If you are the rightful owner of excel-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed.
apply_formula
Apply Excel formula to cell. Excel formula will write to cell with verification.
Try it
Result:
validate_formula_syntax
Validate Excel formula syntax without applying it.
Try it
Result:
format_range
Apply formatting to a range of cells.
Try it
Result:
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).
Try it
Result:
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"
Try it
Result:
create_workbook
Create new Excel workbook.
Try it
Result:
create_worksheet
Create new worksheet in workbook.
Try it
Result:
create_chart
Create chart in worksheet.
Try it
Result:
create_pivot_table
Create pivot table in worksheet.
Try it
Result:
create_table
Creates a native Excel table from a specified range of data.
Try it
Result:
copy_worksheet
Copy worksheet within workbook.
Try it
Result:
delete_worksheet
Delete worksheet from workbook.
Try it
Result:
rename_worksheet
Rename worksheet in workbook.
Try it
Result:
get_workbook_metadata
Get metadata about workbook including sheets, ranges, etc.
Try it
Result:
merge_cells
Merge a range of cells.
Try it
Result:
unmerge_cells
Unmerge a range of cells.
Try it
Result:
copy_range
Copy a range of cells to another location.
Try it
Result:
delete_range
Delete a range of cells and shift remaining cells.
Try it
Result:
validate_excel_range
Validate if a range exists and is properly formatted.
Try it
Result:
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
