Skip to content

Excel Automation Features

A PivotTable summarizing revenue by region and quarter, built in the real Excel app by Excel MCP Server
A PivotTable — revenue by region and quarter with grand totals — created in the real Excel application from a plain-language request.

Excel MCP Server provides 31 specialized tools and 326 operations for automating the real Microsoft Excel application. You can ask your AI assistant in plain language—the reference pages below are for discovering what is possible and looking up individual operations.

  • Data & analytics

    Import and reshape data with Power Query, build DAX models, create Excel Tables and PivotTables, and manage external connections.

    Includes: Power Query, Data Model, Excel Tables, PivotTables, Data Connections, QueryTables

    Explore data and analytics features

  • Cells & workbooks

    Read and write ranges, formulas, and formats; manage worksheets, workbook settings, named ranges, calculation, and files.

    Includes: File Operations, Calculation, Ranges, Worksheets, Workbook, Named Ranges

    Explore cells and workbook features

  • Charts & visuals

    Turn workbook data into charts, slicers, conditional formatting, screenshots, drawings, and sparklines.

    Includes: Charts, Slicers, Conditional Formatting, Screenshots, Drawing Objects, Sparklines

    Explore chart and visual features

  • Automation & advanced

    Run VBA and Python, control Excel windows, solve What-If scenarios, and work with XML Maps.

    Includes: VBA, Python in Excel, Window Management, What-If Analysis, XML Maps

    Explore automation and advanced features

What you want to do Feature reference
Import or transform data Power Query
Build a Power Pivot model Data Model & DAX
Create a PivotTable PivotTables
Read, write, or format cells Ranges
Create a chart Charts
Run a macro VBA Macros
Find an input for a target result What-If Analysis

You do not need to memorize operation names

Describe the Excel result you want. Your AI assistant selects the appropriate tool and operation from the reference automatically.