Awesome MCP › Other MCP Servers

haris-musa/excel-mcp-server

⭐ 4180 Python added to this list on 2025-03-24 repository created 2025-02-12

The project "excel-mcp-server" is a Model Context Protocol (MCP) server designed to enable AI-driven creation, reading, and modification of Excel files without requiring Microsoft Excel installation. It allows users to create, read, and modify Excel workbooks through an AI agent, providing a powerful toolset for Excel file manipulation. The server supports a wide range of Excel functionalities including creating and modifying workbooks, reading and writing data, applying formatting and styles, creating charts and visualizations, generating pivot tables, and managing worksheets and ranges. It supports dual transport modes: stdio and SSE, catering to different integration needs. The stdio transport mode is ideal for direct integration with local tools and development environments, allowing manipulation of local files. The SSE transport mode is designed for remote connections, enabling manipulation of remote files. The server requires Python 3.10 or higher to run. For SSE transport, users must set the EXCEL_FILES_PATH environment variable to specify the directory for reading and writing Excel files, with a default path of ./excel_files if not set. The FASTMCP_PORT environment variable can be used to control the server's listening port, defaulting to 8000. For stdio transport, the file path is provided with each tool call, so no environment variable setting is needed. The server integrates seamlessly with AI tools, allowing Excel manipulation capabilities to be accessed through AI assistants. It provides comprehensive documentation of all available tools in a separate TOOLS.md file. The project is open-source under the MIT License and has a presence on PyPI with versioning and download statistics. Overall, this MCP server offers a robust and flexible solution for AI-driven Excel file management without the need for Microsoft Excel, supporting both local and remote use cases through its dual transport modes.

https://github.com/haris-musa/excel-mcp-server

aiai-agentai-drivenai-integrationai-tools-integrationapply-formattingautomationchartscreate-chartscreate-excelcreate-excel-workbookscreate-visualizationscursor-ideexcelexcel-file-manipulationexcel-filesexcel-workbooksformattinggenerate-pivot-tablesllmlocal-file-manipulationmanage-rangesmanage-worksheetsmcpmcp-servermit-licensemodel-context-protocolmodify-excelmodify-excel-workbookspivot-tablespythonpython-3.10rangesread-excelread-excel-dataremote-file-manipulationremote-hostingserver-sent-eventsssesse-transportstdio-transportstylestoolcallingvisualizationsworksheetswrite-excelwrite-excel-data