Overview
This MCP server lets AI agents manipulate Excel files without requiring Microsoft Excel. It supports creating, reading, and updating workbooks and worksheets, along with data manipulation tasks such as formulas, formatting, charts, pivot tables, and Excel tables. It also provides data validation, styling options, and table management features. The server exposes multiple transport methods to accommodate different deployment scenarios, including stdio for local use, SSE (deprecated) for server-sent events, and streamable HTTP for remote access.
Usage notes: For SSE and Streamable HTTP transports, you must set the EXCEL_FILES_PATH environment variable to indicate where Excel files are stored; the default is ./excel_files. The FASTMCP_PORT variable can be set to control the listening port (default 8017). When using stdio transport, the file path is supplied with each call, so EXCEL_FILES_PATH is not required on the server. Documentation for the full toolset is available in TOOLS.md. The project is MIT licensed and can run locally or as a remote service.
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.
Who Is This For?
- AI developers:Power AI agents to read, write, and modify Excel workbooks without Excel installed, via stdio, SSE, or streamable HTTP transports.
