apply_formula
Apply Excel formula to cell. Excel formula will write to cell with verification.
LABSCO SUMMARY
A spreadsheet deliverable gets produced rather than described.
validate_formula_syntax before apply_formula means a formula is checked before it lands in a cell, and read_data_from_excel returns validation rules alongside the values, so an agent editing somebody else's model can see what that model expects. The file on disk is the artifact — there is no import or export step around it.
What it is
Workbook editing over a file path: worksheets created, copied, renamed and deleted; ranges read, written, merged, copied and deleted; formulas validated and then applied; and charts, native tables and pivot tables created in place.
What you get
- A workbook created, its metadata read — sheets and ranges — and worksheets added, copied, renamed or removed
- Data read from a range with cell metadata including validation rules, and written from a starting cell as rows
- Formula syntax validated first, then applied to a cell and verified on write
- Formatting across a range: bold, font and background colour, alignment, borders and conditional formatting
- Charts created from a data range with a title and axis labels, native Excel tables with a style, and pivot tables with rows, columns, values and an aggregation function
- Structural edits: rows and columns inserted or deleted, cells merged and unmerged, ranges copied between sheets, and a range validated before you act on it
Requirements
uvx on your PATH and the path to the workbook — every call takes the file path, and the sheet name wherever the sheet matters.
Setup effort
One command — uvx excel-mcp-server stdio
USE CASES
01
Producing a report someone will open in Excel
Create the workbook, write the data in, format the range so it reads, and add the chart. What you hand over is the file, not a description of it.
02
Editing a workbook a colleague sent you
Read the sheet list and the ranges first, then read the data with its validation rules so the edit respects the constraints already in the file.
03
Turning raw rows into something summarised
Make the range a native table, then build a pivot on it with the rows, values and aggregation you want — in the file rather than in a chat message.
04
Checking a formula before it goes in
Validate the syntax, then apply it and let the write verify itself — the order that keeps a broken formula out of a model people rely on.
05
Reshaping a sheet that arrived in the wrong shape
Insert or delete rows and columns, copy ranges between sheets, and merge the cells that need to span — structural work that would otherwise be manual.
25 tools
Counted once with only startup setup. Other versions, modes or optional credentials may expose a different list.
copy_range
Copy a range of cells to another location.
copy_worksheet
Copy worksheet within 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.
create_workbook
Create new Excel workbook.
create_worksheet
Create new worksheet in workbook.
delete_range
Delete a range of cells and shift remaining cells.
delete_sheet_columns
Delete one or more columns starting at the specified column.
delete_sheet_rows
Delete one or more rows starting at the specified row.
delete_worksheet
Delete worksheet from workbook.
format_range
Apply formatting to a range of cells.
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
get_merged_cells
Get merged cells in a worksheet.
get_workbook_metadata
Get metadata about workbook including sheets, ranges, etc.
insert_columns
Insert one or more columns starting at the specified column.
insert_rows
Insert one or more rows starting at the specified row.
merge_cells
Merge 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).
rename_worksheet
Rename worksheet in workbook.
unmerge_cells
Unmerge a range of cells.
validate_excel_range
Validate if a range exists and is properly formatted.
validate_formula_syntax
Validate Excel formula syntax without applying it.
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"
BEFORE YOU INSTALL
What to know first
Tools you get
25 tools when we connected.
Requires
uvx on PATH
CONTEXT COST
Moderate Standing cost
Rated by the size of the 25 tool definitions that ride along on every turn, not by how many there are
INSTALLATION
Connect your client
Add the block to your client, or run the command directly.
Server setup
Configuration file
JSON
{
"mcpServers": {
"excel-mcp-server": {
"command": "uvx",
"args": [
"excel-mcp-server",
"stdio"
]
}
}
}uvx
TERMINAL
uvx excel-mcp-server stdio
