replace_in_formulas

MCP tool from Spreadsheet MCP by PSU3D0

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

How to use it

replace_in_formulas is exposed by the Spreadsheet MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the replace_in_formulas 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

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