skills.rest
sbroenne
sbroenneCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

excel-mcp

Automate Microsoft Excel operations on Windows via COM interop.

427|61|Updated Oct 19, 2025
Search Tags:#automation#excel#pivot table#dax#vba#power query
One-click install
npx skills add https://github.com/sbroenne/mcp-server-excel --skill excel-mcp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-mcp
Source: https://github.com/sbroenne/mcp-server-excel/tree/main/skills/excel-mcp
Command: npx skills add https://github.com/sbroenne/mcp-server-excel --skill excel-mcp

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill allows AI assistants to automate Microsoft Excel tasks on Windows, eliminating the need for manual clicks and repetitive operations.

Core Features & Use Cases

  • Comprehensive Automation: Automate Power Query, DAX measures, VBA macros, PivotTables, Charts, formatting, and data transformations.
  • Natural Language Interface: Interact with Excel using conversational AI commands.
  • Use Case: You need to create a sales report. You can ask the AI to "Create a new Excel workbook, add sales data from a CSV, format it as a table, create a PivotTable summarizing revenue by region, and then generate a bar chart showing the top 5 regions."

Quick Start

Use the excel-mcp skill to create a new Excel file named 'sales_report.xlsx' in your Documents folder.

Frequently Asked Questions about excel-mcp

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel tasks like PivotTables and charts using natural language?▼

You can automate Excel tasks like PivotTables and charts by using an AI assistant connected via COM interop. This allows you to issue conversational commands to create workbooks, format data, and generate reports without manual clicks.

Can I use AI to create and modify DAX measures and Power Query in Excel?▼

Yes, AI can create and modify DAX measures and manage Power Query. Through COM interop automation, the AI assistant executes these specific Excel operations directly on your Windows environment.

Does Excel automation with AI work on macOS or require a specific Windows environment?▼

Excel automation with AI requires a Windows environment. It relies on COM interop to communicate with Microsoft Excel, meaning macOS and other operating systems are not supported for this specific automation approach.

What is the best way to generate a sales report in Excel from a CSV file using AI?▼

The best way to generate a sales report from a CSV is using AI-driven Excel automation. You can instruct the AI to import the CSV, format it as a table, summarize revenue with a PivotTable, and generate a bar chart.

Do I need a specific Excel version to run VBA macros and formatting through AI automation?▼

Yes, you need Excel 2016 or newer to run VBA macros and formatting through AI automation. The COM interop mechanism requires this minimum version to properly expose the necessary APIs for workbook and data manipulation.

Related Skills

Explore More Software Engineering Skills→
dachentdachent
18

xlsx-win

Automate Microsoft Excel COM operations on Windows using JSON job contracts.

Community
Advanced
CleanExpoCleanExpo
6

simple-report-export

Generate tax optimization reports and export them as Word, Excel, and PDF files.

Community
Intermediate
kerrybackkerryback

xlsx

Create, edit, and analyze Excel workbooks with formulas and recalculation.

Community
Advanced
mkalhitti-cloudmkalhitti-cloud
2

xlsx

Create and edit Excel workbooks with formulas and charts.

Community
Advanced