skills.rest
reason-machines
reason-machinesOFFICIAL
Explore all skills by this author →
Website𝕏@reasonmachinesGitHub

excel-mcp-automation

Automates Microsoft Excel via COM API for Power Query, DAX, PivotTables, charts, and VBA.

7|2|Updated May 16, 2026
Search Tags:#automation#Excel#MCP server#dax#vba#Power Query#pivottable
One-click install
npx skills add https://github.com/reason-machines/mcp-skills --skill excel-mcp-automation-reason-machines
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-mcp-automation
Source: https://github.com/reason-machines/mcp-skills/tree/main/skills/excel-mcp-automation
Command: npx skills add https://github.com/reason-machines/mcp-skills --skill excel-mcp-automation-reason-machines

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Automating Microsoft Excel tasks like building PivotTables, writing Power Query M code, creating DAX measures, and formatting ranges normally requires deep Excel expertise and repetitive manual work. This Skill lets an AI assistant control the actual Excel application through natural language commands via an MCP server or CLI. ## Core Features & Use Cases - Full Excel Automation: 25 tools covering Power Query, Data Model/DAX, Excel Tables, PivotTables, Charts, VBA, ranges, connections, slicers, and conditional formatting. - CLI for Coding Agents: The excelcli command-line interface uses 64% fewer tokens than the MCP server, making it ideal for Copilot, Cursor, and scripted workflows. - Use Case: Build a sales dashboard end-to-end: create a workbook, load data into a table, add a calculated column, generate a PivotTable summarizing revenue by product, and render a clustered column chart, all from natural language commands. ## Quick Start Ask the AI to create a new Excel workbook, add sample sales data, convert it to a table, and build a PivotTable with a chart summarizing totals by product.

Frequently Asked Questions about excel-mcp-automation

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

FAQPage Schema
How do I automate Excel with an AI assistant?▼

Install the ExcelMcp MCP server or the excelcli CLI tool, then issue natural language commands to create workbooks, tables, PivotTables, charts, and Power Query scripts. The server controls the real Excel application via the COM API on Windows.

How to create a PivotTable in Excel using a CLI?▼

Use excelcli pivottable create with a source range or table and destination, then add row and data fields with commands like pivottable add-row-field and pivottable add-data-field specifying the aggregation function such as Sum.

Does ExcelMcp work on macOS or Linux?▼

No, ExcelMcp is Windows-only because it relies on Excel's COM interop API. It also requires Microsoft Excel 2016 or later installed and a desktop environment, so it is not suitable for server-side processing.

What is the difference between the excelcli CLI and the MCP server?▼

The CLI is a single-tool interface that uses about 64% fewer tokens, making it better for coding agents like Copilot and Cursor. The MCP server offers better tool discovery and suits conversational AI clients like Claude Desktop and VS Code Chat.

Why does ExcelMcp fail with a COM initialization error?▼

COM initialization fails when Excel is not installed, the OS is not Windows, or Excel is open in another user session. Verify Excel 2016 or later is installed and close all running Excel instances before starting automation.

Can ExcelMcp run VBA macros and manage Power Query?▼

Yes, it can import, export, list, and run VBA modules, and create, refresh, and export Power Query M code with load destinations to worksheets or the Data Model. M formulas must use absolute file paths.

Related Skills

Explore More Data & Analytics Skills→
nexu-ionexu-io
8.2k

data-report

Convert CSV, Excel, or JSON data into an HTML report with Chart.js charts and tables.

Official
Advanced
goodstoriesworldgoodstoriesworld

coco-intel-briefing

Aggregate RSS feeds, summarize articles, and generate structured Markdown briefings.

Official
Advanced
Sampi314Sampi314
1

ag-vba-auditor

Audit Excel VBA code for security, performance, and compliance issues.

Community
Advanced
J-StaR-Films-StudiosJ-StaR-Films-Studios
23

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Official
Advanced