Agents

Microsoft Brings Agent Mode to Excel, Letting Copilot Run Multi-Step Workflows

The AI assistant can now plan, execute, and validate complex spreadsheet tasks without constant prompting.

Oliver Senti
Oliver SentiSenior AI Editor
December 11, 20254 min read
Share:
Laptop displaying Excel spreadsheet in modern office with soft blue lighting suggesting AI-powered workflow processing

Microsoft announced December 9 that Agent Mode in Excel is now generally available for web users with a commercial Microsoft 365 Copilot license or Microsoft 365 Premium subscription. The feature, which had been testing in Microsoft's Frontier early access program since September, represents the company's first major push to bring autonomous AI workflows to its spreadsheet application.

What Agent Mode Actually Does

The core shift is from single-prompt interactions to multi-step task execution. Where standard Copilot responds to individual queries, Agent Mode takes a request like "analyze this sales data and create a visual breakdown of trends" and works through the problem: selecting formulas, generating new sheets, building charts, and validating results before presenting them back.

Microsoft's Excel team describes the capability through five main use cases: creating workbooks with data pulled from web searches, running what-if scenario analyses, generating and fixing formulas with explanations, building PivotTables and charts, and producing data visualizations. Each workflow shows users the reasoning chain behind decisions, allowing them to intervene or redirect as needed.

The feature runs on OpenAI's latest reasoning models, with Microsoft now also offering Anthropic model options for users in the Frontier program who want alternatives.

Benchmark Performance and Limitations

Microsoft published performance data using SpreadsheetBench, a benchmark of 912 real questions gathered from online Excel forums. Agent Mode achieved 57.2% accuracy on the complete task set. For context, human experts scored 71.3% on the same benchmark, while competing systems like ChatGPT agent (45.5%) and Claude Files scored lower.

The 14-point gap to human performance points to ongoing limitations. According to DataCamp's testing, Agent Mode handles straightforward calculations and lookups reliably but struggles more with nested multi-step transformations. Microsoft's own engineering team acknowledged the system has room for improvement on formatting and presentation-quality layouts.

SpreadsheetBench's design also doesn't capture Excel's full capability set. The benchmark excludes dynamic arrays, PivotTables, charts, and formatting, meaning Agent Mode's real-world performance on complex modeling tasks remains less quantified.

Availability and Platform Rollout

Agent Mode works in Excel for the web starting now, with desktop support for Windows and Mac arriving in January 2026. Microsoft 365 Personal and Family subscribers will gain access in January as well, expanding the feature beyond commercial licenses.

Language support covers English, Spanish, Japanese, French, German, Portuguese, Italian, and Simplified Chinese at launch. EU customers do not have access yet, according to Microsoft's support documentation.

Web search grounding is active, allowing outputs to incorporate current data. File grounding and Work IQ (Microsoft's cross-app context system) are planned for early 2026.

The Multi-Model Strategy

The Excel rollout continues Microsoft's pattern of deploying different AI providers for different tasks across its productivity suite. OpenAI's GPT-5 powers Agent Mode within the Office applications, while Anthropic's models drive the separate Office Agent feature in Copilot chat, which generates entire Word documents and PowerPoint presentations from scratch.

Microsoft's VP of Microsoft 365 AI, Jared Spataro, has been explicit about the approach: the company is testing across model families to match capabilities to specific tasks rather than relying on a single provider. Anthropic's integration currently runs through Amazon Web Services' API infrastructure, which Microsoft acknowledges as a factor in why some Anthropic-powered features aren't yet available in desktop Office applications.

What Comes Next

Agent Mode in PowerPoint is available through the Frontier program now, with broader rollout expected to follow Excel and Word. Microsoft has also announced that starting March 2026, some Agent Mode features will become available to Microsoft 365 users without a dedicated Copilot license, though the company hasn't specified which capabilities will be included in that free tier.

The December rollout continues through late February 2026 as Microsoft stages access across regions and user segments.

Tags:MicrosoftExcelCopilotAI agentsMicrosoft 365spreadsheet automationOpenAIproductivity software
Oliver Senti

Oliver Senti

Senior AI Editor

Former software engineer turned tech writer, Oliver has spent the last five years tracking the AI landscape. He brings a practitioner's eye to the hype cycles and genuine innovations defining the field, helping readers separate signal from noise.

Related Articles

Stay Ahead of the AI Curve

Get the latest AI news, reviews, and deals delivered straight to your inbox. Join 100,000+ AI enthusiasts.

By subscribing, you agree to our Privacy Policy. Unsubscribe anytime.

Microsoft Brings Agent Mode to Excel, Letting Copilot Run Multi-Step Workflows | aiHola