A
securityA
licenseA
qualityA Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.
Last updated -
6
2,218
472
MIT License
A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent.
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
- 🔌 Triple transport support: stdio, SSE (deprecated), and streamable HTTP
- 🌐 Remote & Local: Works both locally and as a remote service
Usage
The server supports three transport methods:
1. Stdio Transport (for local use)
2. SSE Transport (Server-Sent Events - Deprecated)
SSE transport connection:
3. Streamable HTTP Transport (Recommended for remote connections)
Streamable HTTP transport connection:
Environment Variables & File Path Handling
SSE and Streamable HTTP Transports
When running the server with the SSE or Streamable HTTP protocols, you must set the EXCEL_FILES_PATH environment variable on the server side. This variable tells the server where to read and write Excel files.
- If not set, it defaults to
./excel_files.
You can also set the FASTMCP_PORT environment variable to control the port the server listens on (default is 8017 if not set).
- Example (Windows PowerShell):
- Example (Linux/macOS):
Stdio Transport
When using the stdio protocol, the file path is provided with each tool call, so you do not need to set EXCEL_FILES_PATH on the server. The server will use the path sent by the client for each operation.
Available Tools
The server provides a comprehensive set of Excel manipulation tools. See TOOLS.md for complete documentation of all available tools.
Star History
License
MIT License - see LICENSE for details.
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Tools
Bietet Funktionen zur Bearbeitung von Excel-Dateien. Dieser Server ermöglicht die Erstellung von Arbeitsmappen, die Bearbeitung und Formatierung von Daten sowie erweiterte Excel-Funktionen.
- Merkmale
- Schnellstart
- Verwendung mit KI-Tools
- Umgebungsvariablen (für SSE-Transport)
- Verfügbare Tools
- Lizenz
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityEnables seamless reading, writing, and analyzing of Excel files through Model Context Protocol, with features for worksheet management, structure analysis, and automated caching.Last updated -843940MIT License
- -securityAlicense-qualityProvides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.Last updated -6MIT License
- AsecurityFlicenseAqualityAn MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.Last updated -865