transform_batch

MCP tool from Spreadsheet MCP by PSU3D0

How to use it

transform_batch is exposed by the Spreadsheet MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the transform_batch tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Spreadsheet MCP

$docker run -v /path/to/workbooks:/data -p 8079:8079 ghcr.io/psu3d0/spreadsheet-mcp:latest

FULL SPREADSHEET MCP LISTING

Other tools in Spreadsheet MCP (39)

apply_formula_pattern

close_workbook

evict a workbook from cache

column_size_batch

define_name

/ updatename / deletename — manage named ranges in a fork

describe_workbook

edit_batch

execute_manifest

execute a SheetPort manifest with JSON inputs

list all edits applied to a fork

get_manifest_stub

grid_export

export a range as a rich grid payload with per-cell values, formulas, number formats, styles, column sizes, and merges

grid_import

import a rich grid payload (values, formulas, styles, formats, column sizes, merges)

inspect_cells

detail-view for up to 25 individual cells with full metadata (value, formula, style, number format)

layout_page

render a sheet range with layout semantics (column widths, borders, merges) as JSON and optionally an ASCII grid

find and replace text in formula bodies only, plain text or regex, preview or apply

compare baseline/current workbook or fork ids and report target proof plus new/resolved/preexisting errors; the summary-first proof step after recalculate

workbook_style_summary

workbook_summary