SimpleSpread · MCP server

An Excel MCP server you can watch work.

SimpleSpread has a built-in MCP server. Claude Code and other AI agents read and edit the Excel spreadsheets open on your Mac, and you see every value, formula and format land in the window as they work. Each change is one step you can undo.

Download for Mac Set it up

Free and open source. Needs SimpleSpread 2.2.1 or later for Mac (2.3.0 for charts and pivot tables), from GitHub or the Mac App Store.

What an agent can do

Spreadsheet work, through MCP tools.

The Model Context Protocol lets an AI agent use tools in other apps. SimpleSpread’s tools act on the real, open document through the same code as your own edits, so formulas recalculate and the grid redraws as each change lands.

  • Read the whole table

    List the open workbooks and their sheets, then read any range as JSON (values, formulas and the formatted text) or as compact CSV, up to 100,000 cells at a time. Dates come back as dates, not serial numbers.

  • Write values and formulas

    Text is read just as if you had typed it: =SUMIFS(…) is a formula, 12% and $4.50 are numbers with that format, and 2026-01-15 is a date. The agent gets the recalculated results back.

  • Format

    Bold, italic, fonts, colours, fills, alignment, wrapping and number formats, from presets like currency and percent to any Excel format code.

  • Charts, pivot tables and sheets

    Insert and restyle charts, build pivot tables with filters and dates grouped by month, and add rows, columns and sheets with formulas adjusting as in Excel.

  • See what you see

    A screenshot tool gives the agent a picture of the window, with charts and formatting, so it can check its work. It can also select cells to point something out to you.

  • Save and close, safely

    The agent can save to the document’s own .xlsx file and close windows, but only when nothing would be lost. Anything that needs a decision is left to you.

Set up

Two minutes to connect an agent.

  1. Install SimpleSpread for Mac (macOS 14 or later).
  2. Open SimpleSpread ▸ Settings ▸ Agents and turn on Allow AI agents to read and edit open spreadsheets.
  3. Copy the setup for your agent. For Claude Code it is one command to run in Terminal:
$ claude mcp add --transport http simplespread http://127.0.0.1:52700/mcp --header "Authorization: Bearer <your token>"

For Cursor, VS Code and other MCP clients, Settings shows the same server as JSON to paste into their configuration. Clients that only start local command-line servers can connect through a bridge such as mcp-remote.

Then open a spreadsheet and ask: “Summarise the sales by region on a new sheet and chart it”, “Fix the #REF! errors in column F”, or “Format my selection as currency”. An agent with a shell can open a file itself with open -a SimpleSpread budget.xlsx.

The full tool list and details are in the MCP server documentation.

Security and privacy

Off until you turn it on, and only on your Mac.

  • Local only. The server listens on 127.0.0.1, so other computers can’t reach it.
  • Token required. Every request needs the token from Settings. Reset it and every agent set up with the old one is shut out.
  • No web pages. Requests from a browser, or naming another website, are refused, so a site you visit can’t reach it.
  • Your edits are protected. Every change is undoable, pivot tables can’t be broken, and the agent never discards unsaved work.
  • Nothing sent by SimpleSpread. SimpleSpread has no account and no analytics. The agent you connect is another matter: what it reads, it may send to its AI provider, as with anything else you show it.

Questions

Excel, MCP and AI agents.

Is there an MCP server for Excel spreadsheets?

Yes. SimpleSpread, a native spreadsheet for the Mac, has one built in. AI agents such as Claude Code can read, write, format, chart, pivot and save the Excel (.xlsx) workbooks open in SimpleSpread, and you watch each change happen in the window.

Does Excel have a built-in MCP server?

No. Microsoft Excel doesn’t include one, so connecting an AI agent to Excel means installing a separate, third-party MCP server. SimpleSpread’s is built in: turn it on in Settings and it runs on your Mac, with nothing else to install.

Does it control Microsoft Excel?

No. It works with Excel files, not with the Excel app: open the .xlsx file in SimpleSpread and the agent edits it there. SimpleSpread saves standard .xlsx files that Excel, Numbers and Google Sheets open, so you can carry on in whichever you like.

Why edit a live document instead of the file?

Tools that rewrite an .xlsx file on disk work blind: you see the result only afterwards, formulas aren’t recalculated until something opens the file, and a mistake overwrites your copy. Here the agent edits the open document, you see it happen, values recalculate at once, and ⌘Z takes back anything you don’t like.

Which AI agents work with it?

Any MCP client that supports the Streamable HTTP transport with a header, such as Claude Code, Cursor and VS Code. SimpleSpread shows the command for Claude Code and a JSON configuration for the others.

Do my spreadsheets leave my Mac?

SimpleSpread sends nothing anywhere. Its MCP server only accepts connections from your own Mac, with your token. The agent you connect may send what it reads to its AI provider.

Is it on Windows or the iPad?

No. The MCP server is in SimpleSpread for Mac, where AI agents like Claude Code run.

What does it cost?

Nothing extra. It’s part of SimpleSpread, which is free and open source under the MIT licence as a download from GitHub, and on the App Store, free to try for 14 days.

Microsoft Excel is a trademark of Microsoft Corporation. SimpleSpread works with Excel files and is not affiliated with or endorsed by Microsoft.

Get SimpleSpread

Try it with your own spreadsheets.

A free download for the Mac that updates itself. More about SimpleSpread.

Download for Mac