sbraind/excel-mcp-server
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 dayong@mcphub.com.
A powerful Model Context Protocol (MCP) server that enables AI assistants like Claude to work seamlessly with Excel files.
Tools
Functions exposed to the LLM to take actions
excel_read_workbook
List all sheets and metadata of an Excel workbook.
excel_read_sheet
Read complete data from a sheet with optional range.
excel_read_range
Read a specific range of cells.
excel_get_cell
Read value from a specific cell.
excel_get_formula
Read the formula from a specific cell.
excel_write_workbook
Create a new Excel file with data.
excel_update_cell
Update value of a specific cell.
excel_write_range
Write multiple cells simultaneously.
excel_add_row
Add a row at the end of the sheet.
excel_set_formula
Set or modify a formula in a cell.
excel_format_cell
Change cell formatting (color, font, borders, alignment).
excel_set_column_width
Adjust width of a column.
excel_set_row_height
Adjust height of a row.
excel_merge_cells
Merge cells in a range.
excel_create_sheet
Create a new sheet in the workbook.
excel_delete_sheet
Delete a sheet from the workbook.
excel_rename_sheet
Rename a sheet.
excel_duplicate_sheet
Duplicate a complete sheet.
excel_delete_rows
Delete specific rows.
excel_delete_columns
Delete specific columns.
excel_copy_range
Copy range to another location.
excel_search_value
Search for a value in sheet/range.
excel_filter_rows
Filter rows by condition.
excel_create_chart
Create charts from data ranges.
excel_create_pivot_table
Create pivot tables for data analysis.
excel_create_table
Convert ranges to formatted Excel tables.
excel_validate_formula_syntax
Validate formula syntax without applying it.
excel_validate_range
Validate if a range string is valid.
excel_get_data_validation_info
Get data validation rules for a cell.
excel_insert_rows
Insert rows at a specific position.
excel_insert_columns
Insert columns at a specific position.
excel_unmerge_cells
Unmerge previously merged cells.
excel_get_merged_cells
List all merged cell ranges in a sheet.
excel_apply_conditional_format
Apply conditional formatting to ranges.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client