What it does
Excel MCP Server lets you manipulate Excel files through Claude or other AI agents without requiring Microsoft Excel or a local installation. It supports creation, reading, and modification of workbooks and worksheets, with capabilities for formulas, data formatting, conditional formatting, charts, pivot tables, and data validation. The server offers three transport options: stdio for local integration, SSE (deprecated), and streamable HTTP for remote connections.
Who it's for
Data analysts automating spreadsheet generation, backend engineers integrating Excel workflows into applications, and developers building AI-powered data processing pipelines that need to create or modify Excel reports without external dependencies.
Common use cases
- Generate Excel reports and dashboards from data sources
- Create and manage pivot tables for data analysis
- Apply formatting, validation, and conditional rules to spreadsheets
- Generate charts and tables dynamically
- Automate repetitive Excel workflows through AI agents
Setup pitfalls
- For HTTP and SSE transports, set the
EXCEL_FILES_PATHenvironment variable (defaults to./excel_files); file paths must be relative to this directory, and absolute paths or directory traversal are rejected - Configure the listening port with
FASTMCP_PORT(defaults to 8017 for HTTP transports) - SSE transport is deprecated; use streamable HTTP for new remote deployments
- Stdio transport requires no environment setup and paths are provided per tool call