Excel’s powerful Agent Mode is finally coming to Windows and Mac
Microsoft is bringing its most advanced AI collaborator to the Excel desktop app. Previously only accessible in Excel for the web, Agent Mode is now generally available on Windows and Mac, allowing Copilot to create complex workbooks, fix formulas, and even choose between templates.
This update brings us a major change in the way we interact with spreadsheets. While we’ve seen many AI assistants integrated into Office apps over the past couple of years, including the COPILOT feature in Excel, the introduction of Agent Mode in the desktop app represents a move away from simple chatbots toward autonomous agents that can navigate the grid like you and I would. Unlike the standard Copilot sidebar, which often acts as a premium search engine, Agent Mode actively participates in our workflow. He rolls up his sleeves and performs tasks directly in the grid.
The distinction is vital: while the original Copilot experience in Excel was largely conversational, asking you to confirm every small step, Agent mode is much more outcome-focused. You tell it the destination, and the agent plots and plots the route, creating the necessary infrastructure within your file to get there. In other words, instead of having to figure out the five or six separate steps required to create a complex dashboard or multi-sheet tracker, you can simply tell it your end goal. For example, if you ask it to “create a debt repayment tracker with a visualization of interest saved,” the agent creates the tables, fills in the logic, generates the graphs, and formats the entire project, all while you watch it work in real time.
Here’s how to get started:
-
Open Excel on your desktop or in your browser.
-
Click “Copilot” and select “Agent Mode” from the Tools menu.
-
Enter a prompt. Microsoft’s example is: “Create a loan calculator that calculates monthly payments based on user inputs for loan amount, annual interest rate, and term in years. Generate a schedule showing month, payment, principal, interest, and remaining balance. Present the results in a clear, formatted table.”
One of the most useful parts of this release is the introduction of the template picker. Microsoft recognizes that different major language models (LLMs) have different personalities and strengths. Some models are designed for rigid math and speed, while others are better suited to explaining complex logical steps or handling creative requests. For this reason, Agent mode allows you to switch between OpenAI (GPT-5.2), the structured task engine, and Anthropic (Claude Opus 4.5), which is often preferred for tasks that require more human reasoning or detailed iterative planning. If one model hits a wall, you can simply swap brains and see if the other model can solve the puzzle.
To add to this, Microsoft has included web search, which allows the agent to search for real-time data, such as current exchange rates, inflation statistics or stock prices, and pull that information directly into your sheet with the appropriate citations.
The agent is also a pro at handling messy data, like spreadsheets with missing headers, inconsistent date formats, and uneven spacing that usually trip up the AI. Additionally, if you have a large workbook with broken links or circular references, it can find these errors and suggest repairs via dedicated “repair” logic. This means that, overall, the wizard plays two crucial roles in your spreadsheet: creation and maintenance.
No, Microsoft Office wasn’t just renamed Microsoft 365 Copilot
The Word shortcut in your taskbar will always be called Word.
Agent mode is available for those using Excel on Windows and Mac with a Microsoft 365 Copilot commercial license or Personal or Family subscription. Just a heads up for those in the EU and UK: due to local regulations and data privacy frameworks, this feature is currently not available in your region. For everyone else, it’s time to see if your new AI assistant can finally handle that intimidating spreadsheet you’ve been avoiding.
Source: Microsoft Excel Blog
- Operating system
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1TB of OneDrive storage, and more.
