excel-mcp-server

What it does

The server enables Excel file manipulation through MCP without requiring Microsoft Excel installation. It handles workbook and worksheet creation, reading, and modification, with support for formulas, data validation, and comprehensive formatting options including fonts, colors, borders, alignment, and conditional formatting. Additional capabilities include chart generation (line, bar, pie, scatter, and more), pivot table creation, Excel table operations, and sheet management (copy, rename, delete). The server supports three transport methods: stdio for local use, SSE (deprecated), and streamable HTTP for remote connections.

Who it's for

Data engineers and analysts who need to programmatically generate or modify Excel workbooks within Claude's context. Developers building Claude agents that work with spreadsheet data, reporting systems, or data processing workflows.

Common use cases

• Generate formatted Excel reports from processed data
• Create and populate pivot tables for data analysis
• Apply consistent formatting and styling to bulk spreadsheets
• Build dynamic workbooks with charts based on real-time data
• Validate and clean spreadsheet data programmatically

Setup pitfalls

• SSE and streamable HTTP transports require the EXCEL_FILES_PATH environment variable set on the server; defaults to ./excel_files if unset
• With SSE/HTTP transports, file paths must be relative to the configured directory; absolute paths and directory traversal are rejected
• Port can be customized via FASTMCP_PORT environment variable (default 8017 for streamable HTTP)
• Stdio transport does not require EXCEL_FILES_PATH