What is the Excel MCP Server?

It's a server that facilitates real-time manipulation and editing of Microsoft Excel files via the Model Context Protocol (MCP) and xlwings, providing instant visual updates to open workbooks.

What types of Excel content can be manipulated in real-time?

You can comprehensively manipulate data, formulas, formats, charts, pivot tables, and manage workbooks, worksheets, ranges, rows, and columns, all with immediate visibility of changes.

Does the server support VBA code execution in Excel?

Yes, it supports executing VBA code within Excel files. For this functionality, users must enable 'Trust access to the VBA project object model' in Excel's Trust Center settings.

How does Excel MCP Server connect to Excel files?

It connects directly to already open Excel instances using xlwings, supporting both local execution via stdio and remote connections via streamable HTTP. This allows modifications to be viewed instantly in the Excel window.

Excel

Name: Excel
Author: llllxxlllll

byllllxxlllll

•

Productivity & Workflow

Developer Tools

Provides a server for real-time manipulation and editing of Microsoft Excel files through the Model Context Protocol (MCP), leveraging xlwings.

This tool serves as an Excel operation backend, built on the Model Context Protocol (MCP) and powered by xlwings. It enables seamless, real-time editing of Excel files, allowing users to instantly view changes directly within an already open Excel instance. Supporting both local and remote deployments, it offers comprehensive capabilities for data manipulation, formatting, chart creation, and pivot table management, effectively integrating Excel functionalities into programmatic workflows.

Key Features

01Support for executing VBA code within Excel files.

02Management of workbooks, worksheets, ranges, rows, and columns.

03Extensive formatting options for fonts, colors, borders, alignment, and conditional formatting.

04Real-time editing of open Excel files with instant visibility.

051 GitHub stars

06Comprehensive data manipulation including formulas, formats, charts, and pivot tables.

Use Cases

01Programmatically generating and managing reports, charts, and pivot tables in Excel.

02Automating complex Excel tasks and data processing workflows.

03Integrating real-time Excel editing capabilities into custom client applications.