Provides guidance for hosting the MCP server on Cloudflare to enable remote access to Excel manipulation tools
Allows installation directly from the GitHub repository to access Excel file manipulation capabilities
Supports running on Linux systems with environment variable configuration for Excel file management
Supports running on macOS with environment variable configuration for Excel file management
Built with Python and requires Python 3.10 or higher to enable Excel workbook creation, analysis and conversion
Provides conversion of Excel files to XML format with high fidelity
What is Spire.XLS MCP Server?
The Spire.XLS MCP Server is a robust solution that empowers AI agents to work with Excel files using the Model Context Protocol (MCP). It is totally independent and doesn't require Microsoft Office to be installed on system. This tool enables AI agents to create, read, modify, and convert Excel workbooks seamlessly
Main Features:
- Convert Excel to PDF, HTML, CSV, image, XML, and more with high fidelity.
- Create, modify, and manage Excel workbooks
- Manage and control worksheets: rename, move, hide, freeze panes, and more.
- Manage worksheets and cell ranges
- Read and write data
- Analyze Excel data
- Add various chart types to create visual Excel dashboards from data
- Create and manipulate pivot tables to summarize, analyze, explore, and present Excel data.
How to use Spire.XLS MCP Server?
Prerequisites
- Python 3.10 or higher
Installation
- Clone the repository:
- Install using uv:
Running the Server
Start the server (default port 8000):
Custom port (e.g., 8080):
Integration with AI Tools
Cursor IDE
- Add this configuration to Cursor:
- The Excel tools will be available through your AI assistant.
Remote Hosting & Transport Protocols
This server uses Server-Sent Events (SSE) transport protocol. For different use cases:
- Using with Claude Desktop (requires stdio):
- Use Supergateway to convert SSE to stdio
- Hosting Your MCP Server:
Environment Variables
Variable | Description | Default |
---|---|---|
FASTMCP_PORT | Server port | 8000 |
EXCEL_FILES_PATH | Directory for Excel files | ./excel_files |
Available Tools
The server provides a comprehensive set of Excel manipulation tools. Here are the main categories:
- Basic Operations: Create, read, write, and delete workbooks and worksheets
- Data Processing: Read and write cell data, apply formulas, sort and filter
- Formatting: Apply styles, merge cells, set fonts and colors
- Advanced Features: Create charts, pivot tables, conditional formatting
- Conversion: Convert Excel to PDF, HTML, CSV, image, XML, and more with high fidelity.
See TOOLS.md for complete documentation of all available tools.
FAQ from Spire.XLS MCP Server?
Can I use Spire.XLS MCP Server for any directory?
Yes, Spire.XLS MCP Serer works for any directory.
Is Spire.XLS MCP Server free to use?
Yes, it is licensed under the MIT License, allowing free use and modification.
What programming languages does Spire.XLS MCP Server support?
It is built with Python.
License
MIT
This server cannot be installed
A robust solution that enables AI agents to create, read, modify, and convert Excel files through the Model Context Protocol without requiring Microsoft Office installation.
Related MCP Servers
- -securityAlicense-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,446276GoMIT License
- 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 -821211TypeScriptMIT License
- -securityAlicense-qualityProvides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.Last updated -PythonMIT License
- AsecurityAlicenseAqualityA Model Context Protocol server that enables AI assistants to create, read, edit, and format Microsoft Word documents through standardized tools and resources.Last updated -16198PythonMIT License