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.
The Excel MCP Server is a versatile tool designed to facilitate the manipulation of Excel files without the need for Microsoft Excel. It allows users to create, read, and modify Excel workbooks using an AI agent. The server supports dual transport modes: stdio for local file manipulation and SSE for remote file handling. This flexibility makes it suitable for both local development and remote connections. The server is built to work with Python 3.10 or higher and offers a range of features including data reading and writing, formatting, chart creation, and pivot table generation. It is particularly useful for integrating with AI tools, providing a seamless way to manage Excel files programmatically.
Features
- Create and modify Excel workbooks
- Read and write data
- Apply formatting and styles
- Create charts and visualizations
- Generate pivot tables
Tools
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.
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
