mcp-server-excel

Overview

ExcelMcp is a comprehensive Model Context Protocol server that enables AI assistants to automate Microsoft Excel through natural language commands. It uses Excel's native COM API for safe, direct control of Excel applications rather than manipulating XLSX files. The project offers both MCP Server and CLI interfaces, with 25 specialized tools covering Power Query, DAX, Excel Tables, PivotTables, Charts, VBA, Ranges, Worksheets, Connections, Named Ranges, Files, Calculation Mode, Slicers, Conditional Formatting, Screenshots, and Window Management. Both interfaces share the same backend service, ensuring feature parity while optimizing for different use cases.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• power_query

  Atomic workflows, M code management, load destinations for Power Query

  Try:Use Power Query to import products.csv and load it to the Data ModelTry:Export all Power Query M code to files for version control
• data_model_dax

  Create and manage DAX measures, relationships, and model structure

  Try:Create a measure for Total Revenue using SUMXTry:Create a relationship between the Orders and Products tables using ProductID
• excel_tables

  Manage Excel tables including filtering, sorting, and structured references

  Try:Convert this range to an Excel Table with a blue style and add a totals rowTry:Format the Price column as currency and highlight values over $500 in green
• pivot_tables

  Create and manage PivotTables including fields, aggregations, and calculated members

  Try:Create a PivotTable from this data showing total sales by ProductTry:Add a calculated field to the PivotTable showing profit margin
• charts

  Create and configure charts including series, formatting, and data labels

  Try:Create a bar chart from the sales dataTry:Add a trendline to the existing chart
• range

  Get/set values, formulas, formatting, validation, and protection for ranges

  Try:Put this data in A1:C3 - Name, Age, City / Alice, 30, Seattle / Bob, 25, PortlandTry:Add a formula column that calculates Quantity times Unit Price
• worksheets

  Manage worksheets including lifecycle, colors, visibility, and moves

  Try:Rename the active sheet to 'Sales Report'Try:Hide all worksheets except the first one
• connections

  Manage OLEDB/ODBC connections and refresh data sources

  Try:Refresh all data connections in this workbookTry:Create a new connection to the SQL Server database
• named_ranges

  Create and manage named ranges for parameters and configuration

  Try:Create a named range 'TaxRate' with value 0.07Try:Use the named range 'RegionFilter' to filter the PivotTable
• files

  Manage session, workbook creation, and IRM/AIP-protected file support

  Try:Create a new Excel file called SalesTracker.xlsxTry:Save the current workbook with IRM protection
• slicers

  Create and manage slicers for interactive filtering of PivotTables and Tables

  Try:Create a slicer for the Region fieldTry:Connect the slicer to multiple PivotTables
• screenshot

  Capture ranges or sheets as PNG for visual verification

  Try:Take a screenshot of the current sheetTry:Capture A1:G10 as an image for documentation

Comparable tools

Installation

{
  "mcpServers": {
    "excel": {
      "command": "path/to/mcp-excel.exe",
      "args": []
    }
  }
}

FAQ

Is this compatible with Mac or Linux?

No, this is Windows-only due to the use of COM interop. Microsoft Excel is required.

Can I use this for server-side automation?

No, this is designed for desktop environments where Excel is installed and running. For server-side processing, use Excel-compatible libraries like ClosedXML or EPPlus.

Compare mcp-server-excel with