Skip to main content
Glama

xlwings Excel MCP Server

by hyunjae-labs
GitHub
Python
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

xlwings-mcp-server

A Model Context Protocol (MCP) server that manipulates Excel files using xlwings - providing native Excel integration through COM automation.

🎯 Why xlwings Instead of openpyxl?

This MCP server is specifically designed for corporate environments where:

  • 🔒 Document security policies prevent direct file access
  • 🏢 Excel files are managed by enterprise document management systems
  • 📊 You need to work with Excel through official Microsoft APIs
  • ✅ IT compliance requires using approved COM automation

Key difference: While openpyxl directly reads/writes Excel files (which may be blocked by security policies), xlwings controls Excel through Microsoft's official COM interface - the same way VBA macros work. This means if you can run Excel macros, you can use this MCP server.

🙏 Acknowledgments

This project is based on excel-mcp-server by Haris Musa.

The original excel-mcp-server uses openpyxl for Excel manipulation. This fork has been modified to use xlwings instead, which provides:

  • Native Excel COM automation
  • Better compatibility with complex Excel features
  • Real-time Excel interaction
  • Support for Excel-specific features like native pivot tables and charts

📋 License

This project is licensed under the MIT License - see the LICENSE file for details.

The original excel-mcp-server is also MIT licensed. Copyright (c) 2025 Haris.

🚀 Features

All 25 tools from the original excel-mcp-server are fully functional:

Core Excel Operations

  • ✅ Create, open, save workbooks
  • ✅ Manage worksheets (create, copy, rename, delete)
  • ✅ Read and write data with validation
  • ✅ Apply formulas and validate syntax
  • ✅ Format cells and ranges

Advanced Features

  • ✅ Native Excel charts through COM
  • ✅ Real pivot tables (not just data summaries)
  • ✅ Excel tables (ListObjects)
  • ✅ Cell merging and unmerging
  • ✅ Row and column operations
  • ✅ Range operations (copy, delete)
  • ✅ Data validation info

📦 Installation

Prerequisites

  • Python 3.10+
  • Microsoft Excel (required for xlwings)
  • Windows (recommended) or macOS with Excel

Setup

  1. Clone the repository:
git clone https://github.com/hyunjae-labs/xlwings-mcp-server.git cd xlwings-mcp-server
  1. Create virtual environment:
python -m venv .venv .venv\Scripts\activate # Windows # or source .venv/bin/activate # macOS/Linux
  1. Install in development mode:
pip install -e .

🔧 Configuration

Add to your Claude Code MCP configuration:

{ "mcpServers": { "xlwings-mcp-server": { "type": "stdio", "command": "C:\\path\\to\\xlwings-mcp-server\\.venv\\Scripts\\python.exe", "args": ["-m", "xlwings_mcp", "stdio"] } } }

📚 Available Tools

The server provides 25 tools for Excel manipulation:

Workbook Operations (3)

  • create_workbook - Create new Excel file
  • create_worksheet - Add new worksheet
  • get_workbook_metadata - Get workbook information

Data Operations (5)

  • write_data_to_excel - Write data to cells
  • read_data_from_excel - Read cell data
  • apply_formula - Apply Excel formulas
  • validate_formula_syntax - Validate formula syntax
  • validate_excel_range - Validate cell ranges

Formatting & Visual (5)

  • format_range - Apply cell formatting
  • create_chart - Create Excel charts
  • create_pivot_table - Create pivot tables
  • create_table - Create Excel tables
  • merge_cells - Merge cell ranges

Sheet Management (6)

  • copy_worksheet - Copy worksheets
  • delete_worksheet - Delete worksheets
  • rename_worksheet - Rename worksheets
  • unmerge_cells - Unmerge cells
  • get_merged_cells - Get merged cell info
  • copy_range - Copy cell ranges

Row/Column Operations (6)

  • delete_range - Delete cell ranges
  • get_data_validation_info - Get validation rules
  • insert_rows - Insert rows
  • insert_columns - Insert columns
  • delete_sheet_rows - Delete rows
  • delete_sheet_columns - Delete columns

🔄 When to Use Which?

Use excel-mcp-server (Original) when:

  • ✅ You don't have Excel installed
  • ✅ You need cross-platform support
  • ✅ You want faster performance
  • ✅ Simple Excel operations are sufficient

Use xlwings-mcp-server (This Fork) when:

  • ✅ Corporate security blocks direct file access
  • ✅ You need to work with protected/encrypted Excel files
  • ✅ You require native Excel features (real pivot tables, complex charts)
  • ✅ Your organization mandates using official Microsoft APIs
  • ✅ You need real-time Excel integration
Featureexcel-mcp-server (Original)xlwings-mcp-server (This Fork)
How it worksDirect file manipulationControls Excel application
Security PolicyMay be blockedWorks if macros are allowed
Excel RequiredNoYes
Best forPersonal use, serversCorporate environments

🤝 Contributing

Contributions are welcome! Please feel free to submit issues or pull requests.

📄 Citation

If you use this project, please acknowledge both:

  1. The original excel-mcp-server by Haris Musa
  2. This xlwings modification

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

local-only server

The server can only run on the client's local machine because it depends on local resources.

Enables Excel file manipulation through Microsoft's official COM automation interface using xlwings, designed for corporate environments where security policies prevent direct file access. Provides 25 tools for workbook operations, data manipulation, formatting, charts, pivot tables, and worksheet management through native Excel integration.

  1. 🎯 Why xlwings Instead of openpyxl?
    1. 🙏 Acknowledgments
      1. 📋 License
        1. 🚀 Features
          1. Core Excel Operations
          2. Advanced Features
        2. 📦 Installation
          1. Prerequisites
          2. Setup
        3. 🔧 Configuration
          1. 📚 Available Tools
            1. Workbook Operations (3)
            2. Data Operations (5)
            3. Formatting & Visual (5)
            4. Sheet Management (6)
            5. Row/Column Operations (6)
          2. 🔄 When to Use Which?
            1. Use excel-mcp-server (Original) when:
            2. Use xlwings-mcp-server (This Fork) when:
          3. 🤝 Contributing
            1. 📄 Citation
              1. 🔗 Links

                Related MCP Servers

                • Excel MCP Server

                  haris-musa
                  A
                  security
                  A
                  license
                  A
                  quality
                  Provides Excel file manipulation capabilities. This server enables workbook creation, data manipulation, formatting, and advanced Excel features.
                  Last updated -
                  20
                  1,814
                  Python
                  MIT License
                  • Linux
                  • Apple

                • Excel MCP Server

                  negokaz
                  A
                  security
                  A
                  license
                  A
                  quality
                  A 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 -
                  5
                  2,942
                  424
                  Go
                  MIT License
                  • Linux
                  • Apple

                • Excel MCP Server

                  zhiwei5576
                  A
                  security
                  A
                  license
                  A
                  quality
                  Enables seamless reading, writing, and analyzing of Excel files through Model Context Protocol, with features for worksheet management, structure analysis, and automated caching.
                  Last updated -
                  8
                  795
                  37
                  TypeScript
                  MIT License
                  • Linux
                  • Apple

                • Excel MCP Server

                  fish0710
                  -
                  security
                  A
                  license
                  -
                  quality
                  Provides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.
                  Last updated -
                  5
                  Python
                  MIT License
                  • Linux
                  • Apple

                View all related MCP servers

                New MCP Servers

                MCP directory API

                We provide all the information about MCP servers via our MCP API.

                curl -X GET 'https://glama.ai/api/mcp/v1/servers/hyunjae-labs/xlwings-mcp-server'

                If you have feedback or need assistance with the MCP directory API, please join our Discord server