mcp-server-excel

🥈Silver

Excel MCP Server & CLI enables AI-powered Excel automation via COM API. Operations teams use it to automate Excel tasks, manage data connections, and generate reports. It integrates with Windows-based Excel workflows and connects to tools like Power Query, Power Pivot, and VBA.

2430Updated 1mo ago

Intermediate30min to implementautomation

Saves ~240 min per use

Quick InstallView Source

git clone https://github.com/sbroenne/mcp-server-excel.git

Works with:

Claude

Overview

About This Skill

Setup & Installation

Quick Install

No install command available. Check the GitHub repository for manual installation instructions.

Alternative Install (Git Clone)

git clone https://github.com/sbroenne/mcp-server-excel

Requirements

Claude Code or compatible AI agent
Works with: Claude

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

Prompt Template

I need to automate Excel tasks for [COMPANY] in the [INDUSTRY] sector. Using MCP Server & CLI, create a VBA script that can [TASK] with [DATA]. Ensure it integrates with Power Query for data refresh and Power Pivot for data modeling. Provide the script and a step-by-step guide to implement it.

Example Output

# VBA Script for Excel Automation

```vba
Sub AutomateDataProcessing()
    ' Open the workbook
    Dim workbook As Workbook
    Set workbook = Workbooks.Open("C:\Data\SalesData.xlsx")

    ' Refresh Power Query connections
    workbook.RefreshAll

    ' Apply data formatting
    With workbook.Sheets("Sales")
        .Range("A1:D100").NumberFormat = "$#,##0.00"
        .Range("A1:D100").AutoFilter Mode:=xlFilterValues
    End With

    ' Generate a pivot table
    Dim ws As Worksheet
    Set ws = workbook.Sheets.Add
    ws.Name = "SalesSummary"
    ws.Range("A3").PivotTableSourceDataSource := "SalesData.xlsx!Sales"
    ws.Range("A3").PivotTablePivotFields("Region").Orientation = xlRowField
    ws.Range("A3").PivotTablePivotFields("Product").Orientation = xlColumnField
    ws.Range("A3").PivotTablePivotFields("Sales").Orientation = xlDataField

    ' Save and close the workbook
    workbook.Save
    workbook.Close
End Sub
```

## Implementation Guide

1. **Open Excel VBA Editor**: Press `ALT + F11` to open the VBA editor.
2. **Insert a New Module**: Go to `Insert` > `Module` to create a new module.
3. **Paste the Script**: Copy and paste the provided VBA script into the module.
4. **Run the Script**: Press `F5` to run the script.
5. **Verify Output**: Check the generated pivot table and formatted data in the specified worksheet.