Server Spreadsheet MCP Server

Sheet

6 tools - e.g. Add a new sheet (optional name and position); Rename an existing sheet; Delete a sheet by name

add_sheet · rename_sheet · delete_sheet · read_sheet · get_sheet_dimensions · search_sheet

read & search

3 tools - e.g. List all spreadsheet files in a directory (non-recursive); List all sheet names in a workbook; Inspect column names, inferred types, row count, and sample values

list_workbooks · list_sheets · describe_table

Copy

3 tools - e.g. Copy an existing file to a new path; Duplicate a sheet within a workbook (optional new name and position); Copy a block of cells to another location (optionally to a different sheet)

copy_workbook · copy_sheet · copy_range

Range

3 tools - e.g. Read a rectangular range, e.g. A1:D10; Write a 2D array starting at a given cell; Clear values in a range without removing rows/columns

read_range · write_range · clear_range

Rows

3 tools - e.g. Append rows after the last used row; Insert blank or pre-filled rows at a position (shifts rows down); Delete rows by index (shifts rows up)

append_rows · insert_rows · delete_rows

Cell

2 tools - e.g. Read a single cell value, e.g. B3; Write a value to a single cell

read_cell · write_cell

Columns

2 tools - e.g. Insert blank columns at a position; Delete columns by index

insert_columns · delete_columns

Sql

2 tools - e.g. Execute a read-only SQL SELECT (supports JOINs across sheets, GROUP BY, aggregates, subqueries); Execute INSERT INTO, UPDATE, or DELETE FROM - writes changes back to the file

sql_query · sql_execute