Skip to main content
Glama

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.py

Client 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_open_workbooks

List every workbook open across all running Excel windows

get_workbook_info

Sheet names, active sheet, and used range per sheet

save_workbook

Save in place (Ctrl+S)

Worksheets

list_worksheets

List sheet names in tab order

add_worksheet

Add a new sheet, optionally named and positioned

delete_worksheet

Delete a sheet

rename_worksheet

Rename a sheet

activate_worksheet

Switch the active tab

Cells & ranges

get_range_values

Read cell/range values

set_range_values

Write a value, a row, or a 2D block of values

get_range_formulas

Read formulas (A1-style)

set_cell_formula

Set a formula or literal on one cell

find_replace

Find and replace text across a sheet or the whole workbook

clear_range

Clear contents, optionally including formatting

insert_rows / delete_rows

Insert or delete rows, shifting others up/down

insert_columns / delete_columns

Insert or delete columns, shifting others left/right

sort_range

Sort a range by one column, optionally keeping a header row in place

Formatting

format_range

Bold/italic/underline, font, fill color, number format, alignment, wrap

autofit_columns

Autofit column widths

Conditional formatting

add_conditional_format_rule

Highlight cells matching a comparison (greater than, between, etc.)

add_color_scale

Apply a 2- or 3-color scale across a range

list_conditional_format_rules

List the rules applied to a range

clear_conditional_format_rules

Remove all rules from a range

Named ranges

list_named_ranges

List user-defined named ranges

read_named_range

Read a named range's current value(s)

write_named_range

Write a value into a named range's top-left cell

create_named_range

Create a new named range

update_named_range

Repoint an existing named range to a new address

delete_named_range

Delete a named range

Data validation

add_dropdown_validation

Restrict a range to a dropdown list of values

add_number_validation

Restrict a range to numbers matching a comparison

get_validation

Read a cell's validation rule

remove_validation

Remove validation from a range

Merging

merge_cells / unmerge_cells

Merge a range into one cell, or undo it

get_merge_info

Check whether a cell is part of a merged range

Hyperlinks

add_hyperlink

Add a hyperlink (external URL or internal cell reference)

remove_hyperlink

Remove a cell's hyperlink

list_hyperlinks

List all hyperlinks on a sheet

Excel Tables

create_table

Create an Excel Table (ListObject) from a range

list_tables

List tables on a sheet

get_table_info

Read a table's columns, range, row count, and style

append_table_rows

Add one or more rows to the end of a table

get_table_data

Read a table's data rows as a 2D array

apply_table_style

Apply a built-in table style

delete_table

Remove a table's definition, keeping the underlying data

Charts

create_chart

Create a chart from a range

list_charts

List charts on a sheet

set_chart_type

Change a chart's type (column, bar, line, pie, area, scatter, doughnut)

set_chart_title

Set or clear a chart's title

add_series

Add a data series to a chart

delete_chart

Delete a chart

Comments

add_comment

Add a cell comment (note)

get_comments

List comments on a sheet

delete_comment

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 workbook explicitly 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 tools
activate_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_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 RulesA
Destructive

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 RangeA
Destructive

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 ChartA
Destructive

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 ColumnsA
Destructive

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 CommentA
Destructive

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 RangeB
Destructive

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 RowsA
Destructive

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 TableA
Destructive

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 WorksheetA
Destructive

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 ReplaceA
Destructive

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 CommentsA
Read-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 InfoA
Read-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 FormulasA
Read-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 ValuesA
Read-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 DataA
Read-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 InfoA
Read-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 ValidationA
Read-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 InfoA
Read-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 ChartsA
Read-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 RulesA
Read-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_named_rangesList Named RangesA
Read-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 WorkbooksA
Read-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 TablesA
Read-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 WorksheetsA
Read-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 RangeA
Read-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_validationRemove ValidationA
Destructive

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 RangeA
Destructive

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

    A3.8/5.0

    Scored across 57 tools

    Disambiguation5/5

    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.

    Naming Consistency5/5

    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'.

    Tool Count1/5

    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.

    Completeness5/5

    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

    ActivityMaintained
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides 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 npm
      MIT