Happy slice of mcp pizzaMCP.pizza
excel-mcp-server

excel-mcp-server

MCP.Pizza Chef: haris-musa

Spreadsheet work moves into the chat window: create workbooks from scratch, pull numbers out of files someone sent you, add formulas and conditional formatting, build charts and pivot tables, and rename or copy sheets. Microsoft Excel does not need to be on your computer, because the .xlsx files are read and written directly. Nothing costs money and no account or key is required, and it runs on your own machine so your files stay local.

Data
Spreadsheets

Use This MCP server To

Build a budget spreadsheet from numbers I paste into chat Summarize what's in a messy spreadsheet a coworker sent me Add a pivot table that totals sales by region Chart three months of expenses without opening Excel Clean up formatting and colors across a whole worksheet Add formulas that calculate totals down a column

README

Excel MCP Server Logo

PyPI version Total Downloads License: MIT smithery badge Install MCP Server

A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent.

Features

  • 📊 Excel Operations: Create, read, update workbooks and worksheets
  • 📈 Data Manipulation: Formulas, formatting, charts, pivot tables, and Excel tables
  • 🔍 Data Validation: Built-in validation for ranges, formulas, and data integrity
  • 🎨 Formatting: Font styling, colors, borders, alignment, and conditional formatting
  • 📋 Table Operations: Create and manage Excel tables with custom styling
  • 📊 Chart Creation: Generate various chart types (line, bar, pie, scatter, etc.)
  • 🔄 Pivot Tables: Create dynamic pivot tables for data analysis
  • 🔧 Sheet Management: Copy, rename, delete worksheets with ease
  • 🔌 Triple transport support: stdio, SSE (deprecated), and streamable HTTP
  • 🌐 Remote & Local: Works both locally and as a remote service

Usage

The server supports three transport methods:

1. Stdio Transport (for local use)

uvx excel-mcp-server stdio
{
   "mcpServers": {
      "excel": {
         "command": "uvx",
         "args": ["excel-mcp-server", "stdio"]
      }
   }
}

excel-mcp-server FAQ

Do I need Microsoft Excel installed?
No — the files are created and edited directly, so it works even on a computer without Excel.
Can I use this to build a monthly budget spreadsheet?
Yes — describe the categories and it will create the workbook, the formulas, and the totals for you.
Does it need a paid account or key?
No. It is free and open source, and it runs locally on your own machine.
Which apps does it work in?
Any assistant that supports MCP, including Cursor, which has a one-click install button.
How hard is setup?
You paste a short snippet into your assistant's settings file; there is nothing to build or compile.
Can it make charts and pivot tables?
Yes — line, bar, pie and scatter charts, Excel tables, and pivot tables are all covered.