excel-mcp-server MCP — Anwendungsfälle, Installieren & Live-Demo

Warum nutzen

Hauptfunktionen

Create/read/update workbooks and worksheets
Formulas, tables, charts (line/bar/pie/scatter), pivot tables
Formatting: fonts, colors, borders, conditional formatting
Transport modes: stdio (local) and streamable-http (remote)
No Excel/Office install required — pure Python

Live-Demo

In der Praxis

excel.replay ▶ bereit

0/0

Installieren

Wählen Sie Ihren Client

~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

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

Öffne Claude Desktop → Settings → Developer → Edit Config. Nach dem Speichern neu starten.

~/.cursor/mcp.json · .cursor/mcp.json

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

Cursor nutzt das gleiche mcpServers-Schema wie Claude Desktop. Projektkonfiguration schlägt die globale.

VS Code → Cline → MCP Servers → Edit

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

Klicken Sie auf das MCP-Servers-Symbol in der Cline-Seitenleiste, dann "Edit Configuration".

~/.codeium/windsurf/mcp_config.json

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

Gleiche Struktur wie Claude Desktop. Windsurf neu starten zum Übernehmen.

~/.continue/config.json

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

Continue nutzt ein Array von Serverobjekten statt einer Map.

~/.config/zed/settings.json

{
  "context_servers": {
    "excel": {
      "command": {
        "path": "uvx",
        "args": [
          "excel-mcp-server"
        ]
      }
    }
  }
}

In context_servers hinzufügen. Zed lädt beim Speichern neu.

claude mcp add excel -- uvx excel-mcp-server

Einzeiler. Prüfen mit claude mcp list. Entfernen mit claude mcp remove.

Anwendungsfälle

Praxisnahe Nutzung: excel-mcp-server

How to generate a monthly Excel report from a prompt

👤 Ops, finance, anyone sending Excel to non-technical stakeholders ⏱ ~20 min intermediate

Wann einsetzen: Every month-end when you refresh 'the spreadsheet everyone asks for'.

Voraussetzungen

uv installed — curl -LsSf https://astral.sh/uv/install.sh | sh
A source of truth (CSV, DB query, or prior month's file) — Export to CSV, or pair with postgres MCP

Ablauf

Create the workbook

Create /reports/2026-04.xlsx with tabs 'Summary', 'Revenue', 'Costs', 'Charts'.✓ Kopiert

→ File created, sheets exist
Populate data

Fill 'Revenue' from /data/apr-revenue.csv; add a total row with SUM formulas.✓ Kopiert

→ Rows + totals present
Add charts

On 'Charts' tab add a line chart of daily revenue from 'Revenue' A2:B31 titled 'April Revenue'.✓ Kopiert

→ Chart visible on open in Excel
Format

On 'Summary', bold headers, apply thousands separators to currency, and conditional-format any red (negative) values.✓ Kopiert

→ Professionally formatted file

Ergebnis: A reviewer-ready .xlsx with live formulas and charts.

Fallstricke

Pasting 100k rows via prompt blows the context window — Have the MCP read the CSV directly from disk rather than pasting values
Pivot tables written by openpyxl don't auto-refresh on open in some Excel versions — Instruct users to right-click Refresh; or use a formula-based summary instead

Kombinieren mit: postgres · filesystem

How to extract tables from an Excel deck into markdown

👤 Engineers turning finance spreadsheets into docs ⏱ ~10 min beginner

Wann einsetzen: A stakeholder sends you a workbook and you need it in a wiki.

Ablauf

Enumerate sheets

Open /inbox/Q1-plan.xlsx and list sheets + dimensions.✓ Kopiert

→ Sheet index
Extract each as markdown

For each sheet, read the used range and render as a markdown table.✓ Kopiert

→ Markdown blob ready to paste

Ergebnis: Wiki-ready tables.

Fallstricke

Merged cells mangle markdown rendering — Unmerge before export, or handle merged regions explicitly

Kombinieren mit: markdownify · notion

How to clean a messy Excel file in one pass

👤 Data wranglers ⏱ ~15 min intermediate

Wann einsetzen: A partner sends a sheet with inconsistent dates, trailing whitespace, and duplicated headers.

Ablauf

Profile the problems

Audit /inbox/vendors.xlsx — columns with mixed types, whitespace, duplicate rows.✓ Kopiert

→ Issue report
Apply fixes

Trim whitespace, parse column E as dates in ISO, remove full-duplicate rows. Save to /cleaned/vendors.xlsx.✓ Kopiert

→ Clean file saved

Ergebnis: A clean workbook ready for ingestion.

Fallstricke

'Fixing' dates that were intentionally text loses meaning — Confirm with the owner before aggressive coercions

Kombinieren mit: postgres

Kombinationen

Mit anderen MCPs für 10-fache Wirkung

excel + postgres

Query the DB and write the result to Excel for stakeholders

Run SELECT * FROM monthly_revenue WHERE month = '2026-04' and write the result to /reports/apr.xlsx with a chart.✓ Kopiert

excel + filesystem

Batch-process every xlsx in a folder

For every file in /inbox/vendors/, unify the headers to {vendor,sku,qty,price} and write to /cleaned/.✓ Kopiert

excel + markdownify

Convert xlsx tables to markdown docs

Extract each sheet of /inbox/plan.xlsx to markdown sections and write /docs/plan.md.✓ Kopiert

Werkzeuge

Was dieses MCP bereitstellt

Werkzeug	Eingaben	Wann aufrufen	Kosten
create_workbook	path: str	Start a new .xlsx	free
create_worksheet	path, name	Add a tab	free
write_data_to_excel	path, sheet, start_cell, data: 2d array	Populate a range	free
read_data_from_excel	path, sheet, range	Extract values	free
apply_formula	path, sheet, cell, formula	Add a formula	free
create_chart	path, sheet, chart_type, range, title	Insert a chart	free
create_pivot_table	path, source, rows, cols, values	Summarize data	free
format_range	path, sheet, range, styles	Styling	free
apply_conditional_formatting	path, sheet, range, rule	Color-code cells	free

Kosten & Limits

Was der Betrieb kostet

API-Kontingent: None — all local
Tokens pro Aufruf: Depends on how much data flows through the prompt; prefer file-path operations
Kosten in €: Free (MIT)
Tipp: Read ranges, not whole sheets, when a file has 100k+ rows.

Sicherheit

Rechte, Secrets, Reichweite

Minimale Scopes: Filesystem read/write to the folder containing the workbooks

Credential-Speicherung: None

Datenabfluss: Local file I/O only; data only leaves your machine via your LLM provider

Niemals gewähren: Write access outside a sandboxed folder when running untrusted prompts

openpyxl doesn't run macros or VBA — .xlsm macro logic is ignored.
Very large files (>50 MB) can OOM on small machines.

Fehlerbehebung

Häufige Fehler und Lösungen

Permission denied writing file

Another program has the file open (often Excel itself). Close it and retry.

Prüfen: lsof path/to/file.xlsx

Formula stored as text

Prefix strings starting with '=' via apply_formula, not write_data_to_excel.

Chart doesn't render in Excel

Check the data range covers the source columns with headers; Excel needs 2+ rows.

File saved but Excel says 'corrupted'

Usually mixing write_data and formulas in the same cell. Recreate the file, build bottom-up.

Alternativen

excel-mcp-server vs. andere

Alternative	Wann stattdessen	Kompromiss
Google Sheets via google-workspace MCP	You want collaborative cloud sheets, not local .xlsx	Needs OAuth; not a replacement for offline xlsx
LibreOffice headless MCP	You need macro execution or conversion to PDF	Heavy install; slower

Mehr

Ressourcen

📖 Offizielle README auf GitHub lesen

🐙 Offene Issues ansehen

🔍 Alle 400+ MCP-Server und Skills durchsuchen