excel-mcp-server

MCP.Pizza Chef: negokaz

Point it at a spreadsheet file on your own computer and your assistant can list the sheets, read a range of cells, write text or formulas back, copy a sheet, turn a block of cells into a table, and change fonts, colours and number formats. It handles .xlsx, .xlsm and Excel template files. On Windows it can also edit a workbook while it is open and take a picture of a sheet. Node.js 20 or newer is required, but no account or sign-in is needed.

Unmaintained · No commits in 13 months.

Data

Files/PDF

Spreadsheets

Use This MCP server To

Summarize what sits in each tab of a workbook Fill a column with a formula across hundreds of rows Copy a sheet and rework it as a new version Format a range with bold headers and currency Read a range of numbers and explain the trend Turn a plain block of cells into a proper table

README

Excel MCP Server

A Model Context Protocol (MCP) server that reads and writes MS Excel data.

Features

Read/Write text values
Read/Write formulas
Create new sheets

🪟Windows only:

Live editing
Capture screen image from a sheet

For more details, see the tools section.

Requirements

Node.js 20.x or later

Supported file formats

xlsx (Excel book)
xlsm (Excel macro-enabled book)
xltx (Excel template)
xltm (Excel macro-enabled template)

Installation

Installing via NPM

excel-mcp-server is automatically installed by adding the following configuration to the MCP servers configuration.

For Windows:

excel-mcp-server FAQ

Does it need a paid account?

No. It works on files already on your computer and asks for no sign-in of any kind.

Which file types work?

Excel workbooks and templates: .xlsx, .xlsm, .xltx and .xltm.

Can I use this to update a budget spreadsheet just by asking?

Yes — it writes values and formulas into whichever cells you name.

Does it work on a Mac?

Yes for reading and writing. Live editing and sheet screenshots are Windows only.

How hard is setup?

You paste a short settings block into Claude Desktop, with Node.js 20 or newer installed first.

Will it work on Google Sheets?

No. It opens Excel files stored on your own machine, not documents living in Google Drive.