Excel MCP server

This is a helper that lets your AI assistant control the actual Microsoft Excel app on your Windows computer. You ask in plain words, and Excel does the work, so you can watch it happen and keep editing afterwards. It is handy for anyone who lives in spreadsheets and wishes they could just describe what they want.

What this MCP server does

You type a request to your AI, like asking it to build a PivotTable or refresh a Power Query. The AI sends that request to this helper, and the helper talks to the real Excel app on your PC. Excel does the work, so formulas recalculate, charts appear, and macros run just like when you click around yourself. When it is done, the AI tells you what changed, and you can keep working in the same workbook.

Click to zoom

What you can do with it

• Refresh Power Query data and load it into the Data Model
• Create PivotTables and charts from your data
• Write and run formulas, including DAX and VBA
• Format cells, ranges, and worksheets
• Use Goal Seek to find a value that hits a target
• Take screenshots of your workbook while it works
• Run Python inside Excel with the =PY() function

Try asking your AI

• “Import products.csv with Power Query and load it to the Data Model.”
• “Create a PivotTable showing revenue by region, then add a column chart.”
• “Use Goal Seek to find the price that produces $100,000 profit.”
• “Show me Excel while you work.”

What it gives back to you

You get back answers, summaries, and confirmations in your chat, like which cells were filled or which chart was added. Sometimes it sends a screenshot so you can see the result. The real changes happen inside your Excel workbook, which you can open and keep editing.

Before you start

Who it's for

Anyone who works with Excel all day, like analysts, finance people, and operations staff who want to describe tasks instead of clicking through menus.