excel-mcp-live
This server lets an AI live-edit workbooks in an already-running Microsoft Excel instance on Windows via COM, without launching or closing Excel.
List open workbooks across Excel windows, inspect workbook/sheet structure, and save workbooks.
Manage worksheets: list, add, delete, rename, and activate sheets.
Read/write cell and range values and formulas; find/replace; clear ranges; insert/delete rows and columns; sort; merge/unmerge cells.
Apply formatting, autofit columns, and manage conditional formatting rules and color scales.
Add, list, and delete cell comments.
Manage named ranges: list, read, write, create, update, and delete.
Add/remove/read dropdown and number data validation.
Add, remove, and list hyperlinks.
Create and manage Excel Tables, including listing, reading data, appending rows, applying styles, and deleting table definitions.
Create and manage charts: create, list, change type, set title, add series, and delete.
Limit registered tools with
EXCEL_MCP_TOOLSETS;list_open_workbooksis always available.It does not cover PivotTables, Power Query, DAX, or VBA, and requires Windows, Excel running with a workbook open, and Python 3.11+.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@excel-mcp-live Add a comment on cell D5 asking about the tax."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
excel-mcp-live
Edit a Microsoft Excel workbook while it's open — the AI attaches to the window you already have, it doesn't start its own.
Live editing · Windows (COM) · 59 tools
Most Excel MCP servers (including this workspace's own mcp-server-excel) work by starting a fresh, invisible Excel process, opening your file in it, and closing it again when done. That's great for scripted automation, but it means the AI is never looking at the same window you are.
excel-mcp-live does the opposite: it attaches to whatever Excel window(s) you already have open
via COM, using the same "find the running application" approach as
word-mcp-live's live editing tools. It never launches Excel and never closes
it — it only touches workbooks you opened yourself.
Requirements
Windows (COM automation is Windows-only — there is no macOS/Linux mode for this project)
Microsoft Excel installed and already running with a workbook open
Python 3.11+
Related MCP server: excel-mcp-server
Installation
git clone <this-repo-url>
cd excel-mcp-live
pip install -e .Or run straight from source with uv — no install step needed:
uv run excel_mcp_server.pyClient setup (.mcp.json)
Point your MCP client at the project directory. For Claude Code, add this to .mcp.json in your
project (or ~/.claude.json for a user-wide config):
{
"mcpServers": {
"excel-live": {
"command": "uv",
"args": [
"--directory",
"G:/Ai/MCP/excel-mcp-live",
"run",
"excel_mcp_server.py"
],
"env": {
"MCP_AUTHOR": "Your Name"
}
}
}
}If you installed it with pip install -e . instead, you can use the console script directly:
{
"mcpServers": {
"excel-live": {
"command": "excel-mcp-live",
"env": {
"MCP_AUTHOR": "Your Name"
}
}
}
}MCP_AUTHOR sets the author name attached to new cell comments (default: "Author").
Limit tool discovery
Set EXCEL_MCP_TOOLSETS in the server's env to a comma-separated list of groups to register
only those tools, e.g. "EXCEL_MCP_TOOLSETS": "ranges,formatting". Groups are combined as a union.
Available groups are workbooks, sheets, ranges (values, formulas, find/replace, clear,
row/column insert/delete, sort, merge), formatting (including conditional formatting),
comments, named_ranges, validation, hyperlinks, tables and charts. Each tool is in
exactly one group. list_open_workbooks is always registered. Unset, empty or all registers
every tool. An unknown group name stops the server at startup. Restart the server after
changing this setting. Filtering only controls which tools are listed and callable. It is not a
security boundary.
Supported functions
Every tool operates on a workbook that's already open in Excel. workbook and sheet arguments
are optional almost everywhere — omit them to target the active workbook / active sheet.
Tool | Description |
Workbook | |
| List every workbook open across all running Excel windows |
| Sheet names, active sheet, and used range per sheet |
| Save in place (Ctrl+S) |
Worksheets | |
| List sheet names in tab order |
| Add a new sheet, optionally named and positioned |
| Delete a sheet |
| Rename a sheet |
| Switch the active tab |
Cells & ranges | |
| Read cell/range values |
| Write a value, a row, or a 2D block of values |
| Read formulas (A1-style) |
| Set a formula or literal on one cell |
| Find and replace text across a sheet or the whole workbook |
| Clear contents, optionally including formatting |
| Insert or delete rows, shifting others up/down |
| Insert or delete columns, shifting others left/right |
| Sort a range by one column, optionally keeping a header row in place |
Formatting | |
| Bold/italic/underline, font, fill color, number format, alignment, wrap |
| Autofit column widths |
Conditional formatting | |
| Highlight cells matching a comparison (greater than, between, etc.) |
| Apply a 2- or 3-color scale across a range |
| List the rules applied to a range |
| Remove all rules from a range |
Named ranges | |
| List user-defined named ranges |
| Read a named range's current value(s) |
| Write a value into a named range's top-left cell |
| Create a new named range |
| Repoint an existing named range to a new address |
| Delete a named range |
Data validation | |
| Restrict a range to a dropdown list of values |
| Restrict a range to numbers matching a comparison |
| Read a cell's validation rule |
| Remove validation from a range |
Merging | |
| Merge a range into one cell, or undo it |
| Check whether a cell is part of a merged range |
Hyperlinks | |
| Add a hyperlink (external URL or internal cell reference) |
| Remove a cell's hyperlink |
| List all hyperlinks on a sheet |
Excel Tables | |
| Create an Excel Table (ListObject) from a range |
| List tables on a sheet |
| Read a table's columns, range, row count, and style |
| Add one or more rows to the end of a table |
| Read a table's data rows as a 2D array |
| Apply a built-in table style |
| Remove a table's definition, keeping the underlying data |
Charts | |
| Create a chart from a range |
| List charts on a sheet |
| Change a chart's type (column, bar, line, pie, area, scatter, doughnut) |
| Set or clear a chart's title |
| Add a data series to a chart |
| Delete a chart |
Comments | |
| Add a cell comment (note) |
| List comments on a sheet |
| Remove a cell's comment |
Not yet covered: PivotTables, Power Query, DAX, VBA — for those, use mcp-server-excel, which starts its own Excel instance and has much broader operation coverage.
Example prompts
"I have this budget open in Excel — read A1:F20 and tell me if any totals look wrong."
"Add a new sheet called 'Summary' before the current one."
"Bold row 1 in the sheet I have open and give it a light gray fill."
"Find every 'Q3' in this workbook and replace it with 'Q4'."
"Set B2 to =SUM(B3:B20) and tell me what it calculates to."
"Add a comment on cell D5 asking whether this figure includes tax."Known limitations
Windows only. Excel COM automation doesn't exist on macOS/Linux.
The workbook must already be open in Excel. This server doesn't create or open files — see mcp-server-excel for that.
No single-undo grouping. Word's COM API can wrap several edits into one Ctrl+Z; Excel's cannot. A tool call that performs multiple writes (e.g. writing several cells) may need several Ctrl+Z's to fully undo.
Multiple Excel windows: if you have more than one workbook open (possibly across separate Excel processes), pass
workbookexplicitly to target the right one — otherwise tools default to the active workbook of whichever Excel instance is found first.
Development
See CLAUDE.md for architecture notes and design constraints — in particular, why this server must never launch or quit Excel itself.
Available Tools
57 toolsactivate_worksheetActivate WorksheetA
Make a worksheet the active tab in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). name: Sheet to activate (required).
Returns: JSON confirmation.
Inputs: name, workbook.
add_color_scaleAdd Color ScaleA
Add a 2-color or 3-color scale to a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:A20". min_color: Hex RGB for the lowest value (default: a red). max_color: Hex RGB for the highest value (default: a green). mid_color: Hex RGB for the midpoint (None = 2-color scale; set this for a 3-color scale, e.g. yellow "FFEB84").
Returns: JSON confirmation.
Inputs: sheet, workbook, max_color, mid_color, +2 more.
add_commentAdd CommentA
Add a comment (note) to a cell in an open workbook.
Replaces any existing comment on the cell.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style single-cell reference, e.g. "B2". text: Comment text (required). author: Comment author (default: MCP_AUTHOR env var, or "Author").
Returns: JSON confirmation.
Inputs: cell, text, sheet, author, +1 more.
add_conditional_format_ruleAdd Conditional Formatting RuleA
Add a cell-value conditional formatting rule to a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:A20". condition: One of "greater_than", "less_than", "greater_equal", "less_equal", "equal_to", "not_equal", "between", "not_between". value1: Comparison value (required). Numbers or text. value2: Second comparison value, required only for "between"/ "not_between". fill_color: Hex RGB cell fill to apply when the rule matches. font_color: Hex RGB font color to apply when the rule matches. bold: Bold the font when the rule matches.
Returns: JSON with the new rule's index (rules apply in index order).
Inputs: bold, sheet, value1, value2, +5 more.
add_dropdown_validationAdd Dropdown ValidationA
Restrict a range to a dropdown list of allowed values.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "B2:B20". values: List of allowed string values (required), e.g. ["Yes", "No"].
Returns: JSON confirmation.
Inputs: sheet, values, workbook, range_address.
add_hyperlinkAdd HyperlinkA
Add a hyperlink to a cell.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style single-cell reference, e.g. "B2". address: Target URL (e.g. "https://example.com"), or an internal reference prefixed with '#' (e.g. "#Sheet2!A1"). text_to_display: Text shown in the cell (None = the address itself). screen_tip: Tooltip text shown on hover.
Returns: JSON confirmation.
Inputs: cell, sheet, address, workbook, +2 more.
add_number_validationAdd Number ValidationA
Restrict a range to numbers matching a comparison.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "B2:B20". condition: One of "greater_than", "less_than", "greater_equal", "less_equal", "equal_to", "not_equal", "between", "not_between". value1: Comparison value (required). value2: Second comparison value, required only for "between"/ "not_between". decimal: Allow decimals (False = whole numbers only).
Returns: JSON confirmation.
Inputs: sheet, value1, value2, decimal, +3 more.
add_seriesAdd Chart SeriesB
Add a data series to a chart.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). chart_name: Chart to add the series to (required). series_range: A1-style address of the series' values, e.g. "D2:D10" (required). series_name: Legend label for the series (None = Excel's default).
Returns: JSON confirmation.
Inputs: sheet, workbook, chart_name, series_name, +1 more.
add_worksheetAdd WorksheetA
Add a new worksheet to an open workbook.
Args: workbook: Workbook name or path (None = active workbook). name: Name for the new sheet (None = Excel's default, e.g. "Sheet4"). index: 1-based tab position to insert before (None = before the active sheet).
Returns: JSON with the new sheet's name and position.
Inputs: name, index, workbook.
append_table_rowsAppend Table RowsA
Append one or more rows to the end of a table.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to append to (required). rows: A list of rows, each a list of values matching the table's column count (required), e.g. [["Widget", 12, 4.5]].
Returns: JSON with the table's resulting row count.
Inputs: rows, sheet, workbook, table_name.
apply_table_styleApply Table StyleA
Apply a built-in table style.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to style (required). style_name: Built-in style name, e.g. "TableStyleMedium2", "TableStyleLight9", "TableStyleDark3".
Returns: JSON confirmation.
Inputs: sheet, workbook, style_name, table_name.
autofit_columnsAutofit ColumnsA
Autofit column widths for a range, or the sheet's used range if none given.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address (None = the sheet's used range).
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address.
clear_conditional_format_rulesClear Conditional Formatting RulesADestructive
Remove all conditional formatting rules from a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:A20".
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address.
clear_rangeClear RangeADestructive
Clear cell contents from a range, optionally including formatting.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:C10". clear_formatting: Also reset fonts, fills, and number formats (Range.Clear instead of Range.ClearContents).
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address, clear_formatting.
create_chartCreate ChartA
Create a chart from a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: Source data range, e.g. "A1:C10". chart_type: One of "column_clustered", "bar_clustered", "line", "pie", "area", "scatter", "doughnut". title: Chart title (None = no title). chart_name: Name for the new chart (None = Excel's default, e.g. "Chart 1"). left, top, width, height: Position and size in points.
Returns: JSON with the new chart's name.
Inputs: top, left, sheet, title, +6 more.
create_named_rangeCreate Named RangeA
Create a new named range.
Args: workbook: Workbook name or path (None = active workbook). name: Name to create (required). Must start with a letter or underscore and contain no spaces. range_address: A1-style address the name refers to, e.g. "A1:C10". sheet: Worksheet the range is on (None = active sheet).
Returns: JSON confirmation with the resolved absolute reference.
Inputs: name, sheet, workbook, range_address.
create_tableCreate TableA
Create an Excel Table from a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address the table will cover, e.g. "A1:C10". table_name: Name for the new table (None = Excel's default, e.g. "Table1"). has_headers: Whether the range's first row is a header row.
Returns: JSON with the new table's name and range.
Inputs: sheet, workbook, table_name, has_headers, +1 more.
delete_chartDelete ChartADestructive
Delete a chart.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). chart_name: Chart to delete (required).
Returns: JSON confirmation.
Inputs: sheet, workbook, chart_name.
delete_columnsDelete ColumnsADestructive
Delete one or more columns, shifting columns to their right left.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). column: Column letter(s) to start deleting from, e.g. "B" (required). count: How many columns to delete.
Returns: JSON confirmation.
Inputs: count, sheet, column, workbook.
delete_commentDelete CommentADestructive
Delete the comment on a specific cell, if any.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style single-cell reference, e.g. "B2".
Returns: JSON confirmation.
Inputs: cell, sheet, workbook.
delete_named_rangeDelete Named RangeBDestructive
Delete a named range.
Args: workbook: Workbook name or path (None = active workbook). name: Named range to delete (required).
Returns: JSON confirmation.
Inputs: name, workbook.
delete_rowsDelete RowsADestructive
Delete one or more rows, shifting rows below them up.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). row_index: 1-based row number to start deleting from (required). count: How many rows to delete.
Returns: JSON confirmation.
Inputs: count, sheet, workbook, row_index.
delete_tableDelete TableADestructive
Remove a table's definition, keeping the underlying cell data.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to remove (required).
Returns: JSON confirmation.
Inputs: sheet, workbook, table_name.
delete_worksheetDelete WorksheetADestructive
Delete a worksheet from an open workbook.
Args: workbook: Workbook name or path (None = active workbook). name: Sheet to delete (required).
Returns: JSON confirmation. Excel will refuse to delete a workbook's only remaining visible sheet.
Inputs: name, workbook.
find_replaceFind and ReplaceADestructive
Find and replace text in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = every sheet in the workbook). find_text: Text to search for (required). replace_text: Replacement text. match_case: Case-sensitive match. whole_cell: Match the entire cell contents rather than a substring.
Returns: JSON with which sheets had at least one replacement.
Inputs: sheet, workbook, find_text, match_case, +2 more.
format_rangeFormat RangeA
Apply font, fill, number-format, and alignment to a cell or range.
Only arguments that are explicitly set are changed; everything else is left as-is.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:C1". bold, italic, underline: Font style toggles. font_name: e.g. "Calibri". font_size: Point size. font_color: Hex RGB, e.g. "FF0000" (with or without leading '#'). fill_color: Hex RGB cell background color. number_format: Excel number format code, e.g. "$#,##0.00" or "0.0%". horizontal_align: One of "left", "center", "right", "general". wrap_text: Whether to wrap text within the cell.
Returns: JSON confirmation of the range formatted.
Inputs: bold, sheet, italic, workbook, +9 more.
get_commentsGet CommentsARead-only
List all comments on a worksheet.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet).
Returns: JSON with each comment's cell address and text.
Inputs: sheet, workbook.
get_merge_infoGet Merge InfoARead-only
Check whether a cell is part of a merged range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style cell reference, e.g. "B2".
Returns: JSON with is_merged and, if true, the full merged area's address.
Inputs: cell, sheet, workbook.
get_range_formulasGet Range FormulasARead-only
Read formulas from a cell or range.
Formulas are returned A1-style (e.g. "=SUM(A1:A10)"). Cells without a formula return their literal value instead.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1" or "A1:C10".
Returns: JSON with the formulas/values as a 2D array.
Inputs: sheet, workbook, range_address.
get_range_valuesGet Range ValuesARead-only
Read values from a cell or range in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1" or "A1:C10".
Returns: JSON with the values as a 2D array (even for a single cell).
Inputs: sheet, workbook, range_address.
get_table_dataGet Table DataARead-only
Read a table's data rows (excluding the header) as a 2D array.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to read (required).
Returns: JSON with the column names and data rows.
Inputs: sheet, workbook, table_name.
get_table_infoGet Table InfoARead-only
Get a table's structure: columns, range, and style.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to inspect (required).
Returns: JSON with column names, range, row count, and style.
Inputs: sheet, workbook, table_name.
get_validationGet ValidationARead-only
Read the data validation rule applied to a cell, if any.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style cell reference, e.g. "B2".
Returns: JSON with the validation type/operator/formulas, or has_validation: false if none is set.
Inputs: cell, sheet, workbook.
get_workbook_infoGet Workbook InfoARead-only
Get worksheet names, the active sheet, and each sheet's used range.
Args: workbook: Workbook name or path (None = the active workbook of the first Excel instance found).
Returns: JSON with sheet names, the active sheet, and each sheet's used range and visibility.
Inputs: workbook.
insert_columnsInsert ColumnsA
Insert one or more blank columns, shifting existing columns right.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). column: Column letter(s) the new columns are inserted before, e.g. "B" (required). count: How many columns to insert.
Returns: JSON confirmation.
Inputs: count, sheet, column, workbook.
insert_rowsInsert RowsA
Insert one or more blank rows, shifting existing rows down.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). row_index: 1-based row number the new rows are inserted before (required). count: How many rows to insert.
Returns: JSON confirmation.
Inputs: count, sheet, workbook, row_index.
list_chartsList ChartsARead-only
List charts on a worksheet.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet).
Returns: JSON with each chart's name and position/size.
Inputs: sheet, workbook.
list_conditional_format_rulesList Conditional Formatting RulesARead-only
List conditional formatting rules applied to a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:A20".
Returns: JSON with each rule's index, COM Type/Operator codes, and formulas (cell-value rules only report formulas; color scales report just the type).
Inputs: sheet, workbook, range_address.
list_hyperlinksList HyperlinksARead-only
List all hyperlinks on a worksheet.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet).
Returns: JSON with each hyperlink's cell, address, and display text.
Inputs: sheet, workbook.
list_named_rangesList Named RangesARead-only
List user-defined named ranges in a workbook.
Hidden/internal names (e.g. Excel's own Print_Area, filter ranges) are omitted.
Args: workbook: Workbook name or path (None = active workbook).
Returns: JSON with each name and what it refers to.
Inputs: workbook.
list_open_workbooksList Open WorkbooksARead-only
List all workbooks currently open, across every running Excel instance.
Returns: JSON with each workbook's name, full path, save state, and which Excel window (by Hwnd) it belongs to.
Inputs: no named parameters.
list_tablesList TablesARead-only
List Excel Tables on a worksheet.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet).
Returns: JSON with each table's name and range.
Inputs: sheet, workbook.
list_worksheetsList WorksheetsARead-only
List worksheet names, in tab order, for an open workbook.
Args: workbook: Workbook name or path (None = active workbook).
Returns: JSON with sheet names and which one is active.
Inputs: workbook.
merge_cellsMerge CellsA
Merge a range into a single cell.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:C1".
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address.
read_named_rangeRead Named RangeARead-only
Read the current value(s) of a named range.
Args: workbook: Workbook name or path (None = active workbook). name: Named range to read (required).
Returns: JSON with the value(s) as a 2D array.
Inputs: name, workbook.
remove_hyperlinkRemove HyperlinkADestructive
Remove the hyperlink from a cell, if any.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style single-cell reference, e.g. "B2".
Returns: JSON confirmation.
Inputs: cell, sheet, workbook.
remove_validationRemove ValidationADestructive
Remove data validation from a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "B2:B20".
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address.
rename_worksheetRename WorksheetA
Rename a worksheet in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). name: Current sheet name (None = active sheet). new_name: New sheet name (required).
Returns: JSON with the old and new names.
Inputs: name, new_name, workbook.
save_workbookSave WorkbookA
Save an open workbook in place (equivalent to pressing Ctrl+S).
Args: workbook: Workbook name or path (None = the active workbook of the first Excel instance found).
Returns: JSON confirmation.
Inputs: workbook.
set_cell_formulaSet Cell FormulaA
Set a formula (or literal value) on a single cell.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). cell: A1-style cell reference, e.g. "B2". formula: Formula string starting with '=' (e.g. "=SUM(A1:A10)"), or a literal value.
Returns: JSON with the cell's resulting calculated value.
Inputs: cell, sheet, formula, workbook.
set_chart_titleSet Chart TitleA
Set or clear a chart's title.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). chart_name: Chart to update (required). title: New title text. Empty string or None removes the title.
Returns: JSON confirmation.
Inputs: sheet, title, workbook, chart_name.
set_chart_typeSet Chart TypeA
Change a chart's type.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). chart_name: Chart to change (required). chart_type: One of "column_clustered", "bar_clustered", "line", "pie", "area", "scatter", "doughnut".
Returns: JSON confirmation.
Inputs: sheet, workbook, chart_name, chart_type.
set_range_valuesSet Range ValuesA
Write values into a cell or range in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: The top-left cell to write into, e.g. "A1" or "B2". values: A single value, a flat list (written as one row), or a list of lists (2D block) anchored at range_address's top-left cell.
Returns: JSON with the range actually written to.
Inputs: sheet, values, workbook, range_address.
sort_rangeSort RangeADestructive
Sort a range by one column.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: The range to sort, e.g. "A1:C10". key_column: 1-based column offset within range_address to sort by (1 = the range's leftmost column). ascending: Sort direction. has_header: Whether the range's first row is a header (excluded from sorting, kept in place).
Returns: JSON confirmation.
Inputs: sheet, workbook, ascending, has_header, +2 more.
unmerge_cellsUnmerge CellsA
Undo a cell merge.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address covering the merged area, e.g. "A1:C1".
Returns: JSON confirmation.
Inputs: sheet, workbook, range_address.
update_named_rangeUpdate Named RangeA
Change what an existing named range refers to.
Args: workbook: Workbook name or path (None = active workbook). name: Existing named range to update (required). range_address: New A1-style address, e.g. "A1:C10". sheet: Worksheet the new range is on (None = active sheet).
Returns: JSON confirmation with the resolved absolute reference.
Inputs: name, sheet, workbook, range_address.
write_named_rangeWrite Named RangeA
Write a single value into a named range's top-left cell.
For multi-cell named ranges, only the top-left cell is set — use set_range_values with the range's address for block writes.
Args: workbook: Workbook name or path (None = active workbook). name: Named range to write to (required). value: New value (required).
Returns: JSON confirmation.
Inputs: name, value, workbook.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 57 tools
Each tool targets a distinct Excel object and action (e.g., get_range_values vs get_range_formulas, set_range_values vs set_cell_formula, merge_cells vs unmerge_cells). The operations are clearly separated across workbooks, worksheets, ranges, tables, charts, hyperlinks, validations, comments, and named ranges, with no ambiguous overlaps.
All tool names follow a consistent verb_noun snake_case pattern (e.g., list_workbooks, create_chart, delete_columns, read_named_range). Verbs are precise and predictable, and there is no mixing of conventions or vague verbs like 'process' or 'do_thing'.
With 57 tools, this server far exceeds any reasonable count for coherence. Even a comprehensive Excel MCP does not justify this many endpoints—many operations could be consolidated (e.g., unified validation or formatting tools). This extreme number creates cognitive load and increases the chance of misselection.
The tool surface covers the full lifecycle of Excel objects: workbooks (list, get info, save), worksheets (add, delete, rename, activate), ranges (values, formulas, clear, sort, insert/delete), tables (create, list, get info, append, get data, style, delete), charts (create, list, set type/title, add series, delete), hyperlinks, validation, comments, named ranges, conditional formatting, and formatting. There are no obvious dead ends for core Excel workflows.
Maintenance
Related MCP Connectors
Excel analytics: inspect, query (JSON rows), charts, and JSON-to-xlsx workbook writing.
The Excel engine for AI agents: read, check and edit Excel models over MCP.
Formula-backed WorkPaper tools for workbook readback, input edits, and JSON persistence.
Control your authorized Windows computers via OAuth: files, shell, apps, and task status.
Related MCP Servers
- AlicenseAqualityDmaintenanceEnables Excel automation via xlwings COM, supporting DRM-protected files and live Excel sessions with tools to read, write, format, run macros, and more.11131 PyPI1MIT
- AlicenseNot gradedqualityDmaintenanceEnables adding, editing, and running VBA modules on running Excel instances in Windows.71 npm5MIT
- AlicenseNot gradedqualityDmaintenanceProvides full read and write access to Excel workbooks (sheets, cell ranges, tables, formulas, formatting, and cross-workbook references) via MCP, running locally or as an HTTP/SSE service.17 npmMIT
- AlicenseNot gradedqualityCmaintenanceEnables reading and writing MS Excel files, including cell values, formulas, sheet creation, copying, formatting, and on Windows, live editing and screen captures.MIT