Skip to content
Sam Despo

Free AI newsletter

The best new AI tools and how to actually use them. Free, straight to your inbox.

No spam. Unsubscribe any time.

Databases & Data

Excel MCP

Lets Claude build and edit real Excel workbooks: formulas, charts, pivots and all.

Open sourceBy Haris Musa (community)
View on the web

What is it?

Claude is good at numbers but normally hands you a CSV. This server lets it produce a proper Excel file: formatted sheets, working formulas, charts, PivotTables and conditional formatting. Think a cleaned-up sales report or a budget model you can send straight to a client.

It writes the .xlsx file directly, so you don't need Excel installed, and it works on Mac, Windows and Linux. It even calculates around 260 Excel functions itself, so Claude can check its formulas give the right answer. It needs uv. In Claude Desktop you can use the one-click .mcpb bundle instead.

Keep the --allow-dir flag: it limits Claude to one folder of workbooks. Add --read-only if you only want analysis. It never runs macros.

What Claude can do once it's connected

  • Create and edit .xlsx workbooks, sheets and cells
  • Write formulas and check the calculated results
  • Build charts, PivotTables and sparklines
  • Apply formatting, conditional formatting and data validation
  • Sort, filter, remove duplicates and import or export CSV

Install in Claude Code

Open your terminal in the project folder and run:

Command
claude mcp add excel --scope user -- uvx excel-mcp-server stdio --allow-dir ~/Documents/Spreadsheets

Who it's for

Marketers, founders and analysts who live in spreadsheets.

Best for

  • Client and sales reports
  • Budget and finance models
  • Cleaning messy data
  • Charts for decks

Why it made the list

It's the most popular spreadsheet MCP, it's actively maintained and the output is a real file your team can open.

More MCPs like this

  • Google Workspace MCP

    Productivity & Comms

    Gives Claude your Gmail, Calendar, Drive, Docs and Sheets so it can draft and organise.

    Open source

  • DBHub (Postgres & SQL)

    Databases & Data

    Lets Claude explore and query your Postgres, MySQL, SQL Server or SQLite database.

    Open source

  • Filesystem MCP

    Productivity & Comms

    Lets Claude Desktop read, write and organise files in folders you choose.

    Open source

  • Airtable MCP

    Databases & Data

    Lets Claude read, search and update records in your Airtable bases.

    Open source