excel-mcp-server

What it does

Provides Excel file manipulation without requiring Microsoft Excel. Enables creation, reading, and modification of workbooks and worksheets through Claude without a local Excel installation. Supports data operations including formulas, conditional formatting, charts, pivot tables, and Excel tables. Includes data validation and built-in error handling for ranges and formulas. Offers three transport options: stdio for local use, SSE (deprecated), and streamable HTTP for remote connections.

Who it's for

Data analysts, financial professionals, and automation engineers who need to programmatically generate or modify Excel workbooks. Useful for anyone building Claude-powered workflows that create reports, dashboards, or data-driven documents without requiring Excel licenses.

Common use cases

• Automate generation of financial reports and data summaries as Excel files
• Transform raw data into formatted workbooks with custom styling and validation
• Build dynamic pivot tables and charts for data analysis workflows
• Create Excel templates for structured data entry and processing
• Extract, modify, and redistribute Excel data as part of automation pipelines

Setup pitfalls

• EXCEL_FILES_PATH environment variable required for SSE and streamable HTTP transports; defaults to ./excel_files if unset
• File paths with remote transports must be relative paths — absolute paths and directory traversal are blocked
• Stdio transport requires no EXCEL_FILES_PATH configuration; paths are provided per request
• Streamable HTTP port controlled via FASTMCP_PORT env var (default 8017)