Quick Brief
- The Launch: Microsoft deploys Agent Mode for Excel on Windows (generally available January 27) and Mac (rolling out), featuring GPT 5.2 and Claude Opus 4.5 model selection via Copilot integration
- The Expansion: Power Query’s full experience reaches general availability in Excel for web; new IMPORTTEXT and IMPORTCSV functions enter Windows Insider testing
- The Impact: Approximately 500 million Excel users gain access to autonomous AI agents capable of multi-step workbook manipulation, formula generation, and data analysis without manual intervention
- The Context: Follows December 2025 web-only release, completing Microsoft’s desktop AI rollout as enterprise productivity tools shift toward agentic workflows
Microsoft announced January 27, 2026, that Agent Mode in Excel powered by Microsoft 365 Copilot has reached general availability on Windows with Mac deployment underway, extending the AI-driven assistant beyond its December web launch. The update introduces a model switcher allowing users to choose between GPT 5.2 from OpenAI and Claude Opus 4.5 from Anthropic, alongside web-grounded search capabilities and improved task success rates across core Excel workflows.
Agent Mode Architecture and Multi-Model Integration
Agent Mode transforms Copilot from a passive assistant into an autonomous collaborator that executes multi-step operations directly within workbooks. The system now supports dual AI reasoning engines: users can select between GPT 5.2 (OpenAI) and Claude Opus 4.5 (Anthropic) through an integrated model picker, with an Auto mode that selects the optimal model based on task requirements.
The platform operates through outcome-based prompts, enabling tasks such as building loan calculators with automated amortization schedules, repairing complex formulas, and generating PivotTables without manual configuration. Microsoft reports the feature creates dedicated worksheet tabs for data preparation, applies formulas programmatically, and delivers analytical insights directly into cells rather than chat-only responses.
Access requires navigating to Home > Copilot > Tools > Agent Mode in Excel for web, Windows, or Mac versions. The model switcher appears within the Agent Mode interface, allowing users to toggle between Auto, GPT 5.2, and Claude Opus 4.5 selections.
Power Query Reaches Feature Parity on Web Platform
Excel for the web now offers the complete Power Query experience including the import wizard and Power Query Editor as a generally available feature for Microsoft 365 Business and Enterprise subscribers. This marks feature parity with desktop versions, enabling cloud-based data transformation, authenticated source connections, and query management through the browser interface.
The rollout addresses a critical gap in web-based data workflows, previously limited to viewing and refreshing existing queries. Users can now perform data shaping operations, manage credentials via Data Source Settings, and execute advanced ETL (Extract, Transform, Load) processes without desktop client dependency.
Windows Insider Preview: Import Functions and Error Diagnostics
Two additional features entered testing for Windows Insider users:
IMPORTTEXT and IMPORTCSV Functions: These dynamic array formulas load text-based data directly into refreshable ranges with single-line syntax, replacing multi-step import workflows. The functions return spill arrays that auto-update when source files change, streamlining recurring data ingestion tasks.
Descriptive Error Cards: Excel for Windows now displays contextual error explanations with remediation guidance, reducing troubleshooting time for formula and data validation failures. The cards replace cryptic error codes with plain-language diagnostics.
AdwaitX Analysis: Enterprise Productivity and AI Workflow Shift
This release signals Microsoft’s strategic pivot toward agentic AI systems that autonomously plan, execute, and validate multi-step tasks. By retiring Excel App Skills in February 2026 and consolidating functionality into Agent Mode, Microsoft streamlines its Copilot interface while expanding capabilities.
The dual-model approach addresses enterprise requirements for AI diversity, allowing organizations to benchmark GPT 5.2 and Claude Opus 4.5 performance across proprietary datasets. Financial modeling, budget forecasting, and operational planning Excel’s core business use cases benefit from Agent Mode’s ability to iterate on outputs and validate results programmatically.
Bloomberg reports Excel maintains approximately 500 million paying users globally, representing a multitrillion-dollar ecosystem of financial models, business forecasting, and data analysis workflows. Agent Mode’s desktop deployment extends AI capabilities to this entrenched user base, particularly finance teams automating month-end reporting cycles, sales organizations generating real-time dashboards, and HR departments conducting workforce analytics through natural language queries.
| Feature | Platform | Availability | Requirements |
|---|---|---|---|
| Agent Mode | Windows | GA (Jan 27, 2026) | Microsoft 365 Copilot subscription |
| Agent Mode | Mac | Rolling out (Jan 2026) | Microsoft 365 Copilot subscription |
| Agent Mode | Web | GA (Dec 2025) | Microsoft 365 Copilot subscription |
| Model Switcher | All platforms | GA | GPT 5.2 or Claude Opus 4.5 selection |
| Power Query | Web | GA (Jan 2026) | Microsoft 365 Business/Enterprise |
| IMPORTTEXT/IMPORTCSV | Windows | Insider Preview | Windows Insider enrollment |
| Error Cards | Windows | Insider Preview | Windows Insider enrollment |
| PDF Scripts | Windows, Mac, Web | GA | Office Scripts enabled |
Technical Specifications
Deployment Timeline and Regional Rollout
Agent Mode follows a phased availability schedule:
- December 2025: Excel for web general availability
- January 27, 2026: Windows general availability
- Late January 2026: Mac rollout begins (ongoing deployment over coming days)
- Pending: EU/UK region deployment with additional regional considerations
Power Query web capabilities launched January 2026 for all qualifying Microsoft 365 subscribers. The Import Functions and error diagnostics remain in Insider testing with no confirmed general availability date.
Microsoft plans to deprecate legacy App Skills in Excel by late February 2026, directing users to Agent Mode as the unified Copilot interface. Office Scripts PDF functionality enabling automated worksheet-to-PDF conversion and email distribution is now live across all platforms.
Frequently Asked Questions (FAQs)
What is Agent Mode in Microsoft Excel?
Agent Mode is an AI assistant in Microsoft 365 Copilot that autonomously builds, edits, and analyzes Excel workbooks through multi-step operations, formula generation, and data validation.
Which AI models does Excel Agent Mode support?
Agent Mode supports GPT 5.2 from OpenAI and Claude Opus 4.5 from Anthropic via a model switcher, with an Auto mode for automatic model selection.
When is Power Query available in Excel for the web?
Power Query’s full experience, including import wizard and editor, became generally available January 2026 for Microsoft 365 Business and Enterprise subscribers.
What are Excel’s new IMPORTTEXT and IMPORTCSV functions?
These Windows Insider Preview functions load text-based data into dynamic arrays using single-formula syntax, creating refreshable ranges that auto-update when source files change.
Is Agent Mode available in all regions?
Agent Mode is generally available on Windows globally with Mac deployment underway. EU and UK regions have additional considerations for availability.
