Microsoft’s January 2026 Excel update is one of the most consequential monthly refreshes in recent memory: Agent Mode moved out of limited previews and into broader availability on desktop, the full Power Query experience landed in Excel for the web, Microsoft introduced lightweight formula-based import functions for text and CSV data, and Office Scripts picked up cross-platform PDF save-and-email capabilities—changes that collectively accelerate everyday data work while raising fresh questions about governance, accuracy, and operational risk.
Background
Microsoft has been accelerating AI and data tooling across Microsoft 365, folding Copilot capabilities into Word, Outlook, PowerPoint and especially Excel—the app where most businesses do their numbers, models, and reporting. January’s additions are part of that broader roadmap: expanding Copilot-driven workflows, removing friction in data import and shaping, and improving error visibility for workbook authors. These moves reflect Microsoft’s strategy of embedding AI assistants directly into productivity surfaces while also making powerful data-preparation capabilities available on the web.What arrived in January 2026: a quick inventory
- Agent Mode in Excel: Generally available on Windows and rolling out to Mac; web rollout began earlier. Includes model selection and web search grounding.
- Power Query in Excel for the web: The full Power Query Editor and import wizard are now available in the browser.
- New Import Functions (Insiders): Formula-based IMPORTTEXT and IMPORTCSV to bring text-based files into the grid as dynamic arrays.
- Descriptive error cards (Insiders): Improved error diagnostics and cards to help users identify and fix formula and data issues faster.
- Office Scripts: save & email as PDF (cross-platform): Scripts can convert workbooks to PDF and email them programmatically across platforms.
Agent Mode: Excel’s new multi-step assistant
What Agent Mode actually does
Agent Mode is the Copilot experience designed to execute multi-step workflows inside a workbook. That includes generating formulas, building PivotTables and charts, reshaping data, and making iterative changes after presenting a proposed plan to the user. The January update expanded Agent Mode’s availability on Windows, added web search grounding (so it can pull current web data), and introduced a model selector that lets eligible tenants choose between OpenAI and Anthropic models.This is not a single-shot help tool; Agent Mode is explicitly multi-step. It can propose a plan, run actions (in a sandbox preview), and then apply selected changes to the workbook after user approval. That design aims to keep users in control while automating repetitive analyst tasks.
Why it matters for power users
- Agent Mode lowers the barrier to complex modeling tasks for non-experts by combining natural language prompts with direct workbook edits.
- It shortens iterations: ask for a trend analysis, tell Agent Mode to add a smoothing column and a chart, then accept or tweak the proposed changes.
- For teams, Agent Mode can standardize recurring reports and reduce repetitive formula authoring.
Controls, choices, and the model switcher
A notable addition in January is the model selector, which gives tenants the option to use different reasoning engines—commonly OpenAI models or Anthropic’s models—depending on policy, preference, or performance. Microsoft documented that organizations can choose which models are permitted, subject to admin controls. This is significant because different models have different strengths, latency profiles, and safety characteristics.Risks and limitations
- Hallucinations and accuracy: Agent Mode’s outputs still require human validation. Even with web grounding, model-generated formulas or dataset joins can be logically incorrect or subtly biased by prompt context. Users should not treat agent edits as authoritative without review.
- Data exfiltration and grounding: When Agent Mode uses web search grounding, organizations must consider whether requests could surface proprietary data or sensitive third-party content. Admins should review policies for Copilot connectivity and grounding sources.
- Governance complexity: Model selection introduces governance overhead—admins must decide permitted models, monitor performance, and handle audit trails for automated edits. Larger enterprises will need guardrails around model use, approvals, and change logging.
Power Query arrives in the browser—what changes for modern workflows
Full Power Query Editor on the web
The full Power Query experience—complete with the import wizard and the Power Query Editor—became generally available in Excel for the web in January. That represents a major shift: previously, advanced transformations required the desktop app; now users can do the same transformations directly in a browser session. For distributed teams and workers on Chromebooks or locked-down devices, this closes a capability gap.Practical benefits
- No desktop required: Transform, clean, and shape data in the web app without switching to desktop Excel.
- Consistent queries: Queries built in the browser are compatible with desktop, enabling hybrid editing.
- Faster collaboration: Coauthoring around data shapes and transformations becomes practical when the entire team can review queries online.
Caveats
- Credentialed data sources: Some authenticated sources still require a desktop refresh or specific authentication flows; administrators should test refresh behaviors for data sources that need enterprise credentials.
- Performance: Very large transforms may still perform better on desktop, especially when local compute and memory advantages matter.
New Import Functions: IMPORTTEXT and IMPORTCSV (Insiders)
What are the Import Functions?
Microsoft introduced formula-based import functions—IMPORTTEXT and IMPORTCSV—as a lighter-weight alternative to Power Query for bringing text and CSV data into the grid. These functions return a refreshable dynamic array, letting users maintain a live import footprint with a single formula cell rather than a heavier query UI. The new feature began rolling out to Insiders in January and is documented on Microsoft Support pages.Why formula-based import matters
- Simplicity: A single formula can import and parse a CSV or a delimited text file without navigating the full Power Query editor.
- Dynamic arrays: Imported ranges expand automatically and can be referenced by downstream formulas and tables.
- Parameters: The functions accept parameters for delimiters, encoding, row filtering, and locale—making them flexible for global datasets.
Typical use cases
- Quickly pulling a CSV published on an intranet or accessible by URL for immediate analysis.
- Embedding light ETL into a workbook that must remain portable and formula-based.
- When users want programmatic imports that can be refreshed via the standard Data ribbon.
Limitations and differences from Power Query
- Not a full replacement: Import functions are intended to complement, not replace, Power Query. They lack the GUI-driven transformations and advanced connectors that Power Query provides.
- Refresh semantics: Imported data doesn’t auto-refresh continuously; users must use Refresh All or script the refresh operation in automation scenarios.
Descriptive error cards: better error handling for formula debugging
January’s Windows Insiders build added descriptive error cards, a usability-focused feature that explains common error conditions and suggests fixes. Instead of terse error codes, Excel now surfaces contextual guidance and remediation steps—speeding debugging for complex formulas and reducing time spent tracking down obscure mistakes.This is a low-friction, high-impact enhancement: by improving error messaging, Microsoft reduces the cost of adopting more advanced formulas and promotes spreadsheet correctness across teams.
Office Scripts: save and email as PDF across platforms
Office Scripts—Microsoft’s automation framework for Excel—now supports converting workbooks to PDF and sending them via email programmatically from any supported platform. The Microsoft Learn documentation includes sample scripts demonstrating OfficeScript.convertToPdf(), OfficeScript.downloadFile(), and OfficeScript.sendMail(), and the Excel January blog confirms the cross-platform rollout. This makes it easier to automate report generation and delivery without relying on desktop-only automation paths.Practical implications:
- Scheduled reporting pipelines can convert workbooks to PDFs and dispatch them directly from the cloud.
- Teams that relied on desktop macros for emailing reports can migrate to a cloud-first workflow.
- Sensitivity labels and protection policies still apply; scripts may be blocked if a file’s sensitivity label prevents external emailing.
How these features fit together: a short workflow example
- Use IMPORTCSV to pull a nightly sales export into a tracking workbook.
- Clean and transform data in the browser with Power Query (no desktop required).
- Use Agent Mode to ask Excel to generate summary charts, a PivotTable, and a written executive summary draft.
- Save the finalized sheet to PDF and email it automatically with an Office Script.
Security, privacy, and governance: what IT must plan for
Data leakage and data residency
Agent Mode’s web grounding and Copilot interactions mean that prompts and potentially workbook context may be sent to external models. Administrators must understand how Copilot handles data, what is logged, and where model processing occurs. GDPR, HIPAA, and other data residency regulations may place constraints on sending sensitive data to third-party models even if processing is routed via Microsoft’s infrastructure. Organizations should review their Copilot and Microsoft 365 data handling policies before enabling web grounding broadly.Audit trails and change control
Agent Mode can apply multi-step edits to workbooks. Enterprises need:- Audit logging for agent-initiated changes.
- Version control and change approvals so analysts can validate agent edits before they are used in production reports.
- Policies to control which users can run agents and which models they can invoke.
Model risk and explainability
Different models behave differently. Anthropic and OpenAI models have distinct reasoning and output styles; switching models may change result wording, explanation quality, and occasionally result correctness. Organizations should treat AI-driven outputs as suggestions, validate them, and document which model and prompt were used for important decisions.Licensing and access controls
While Microsoft has been expanding free Copilot-style capabilities, some advanced features and model options may still be gated by licensing tiers or tenant settings. IT teams should inventory who has access, test the feature behavior under current licensing, and reconcile usage with compliance and budget policies.Practical guidance for Excel users and administrators
For end users: quick checks and first steps
- Check your build: Import functions and some Insiders-only items require specific Insider builds on Windows. If you don’t see a feature, verify your Excel channel and build number.
- Try in a safe workbook: Use Agent Mode and Office Scripts first in test files to understand how the agent proposes changes and how scripts handle PDFs and email.
- Validate everything: Treat agent edits as drafts—scan formulas, check sample outputs, and confirm they match your domain rules.
For IT and governance teams: policies to implement
- Enable logging: Ensure Copilot and Office activity logs are retained and monitored to trace agent-driven edits.
- Limit models where needed: Use the model selector to restrict bright-line use of external models for sensitive work.
- Define approval workflows: Require sign-off for agent-applied edits to financial models or regulatory reports.
- Test data flows: Validate how Power Query web refreshes handle credentials and service accounts for authenticated sources.
Strengths and strategic value
- Productivity uplift: Automating repetitive analytics tasks and making advanced data tools available in the web client shortens time-to-insight for many teams.
- Accessibility: Formula-based import functions and web Power Query reduce friction for users on non-Windows devices.
- Automation parity: Office Scripts’ cross-platform PDF/email support finally gives cloud-first automation parity with many desktop-driven macro workflows.
Potential risks and open questions
- Overreliance on AI: Without disciplined validation, agent-suggested changes could propagate errors. The human-in-the-loop remains essential.
- Governance gaps: Rapid capability expansion can outpace policy and training, creating compliance exposure.
- Performance and scale: Browser-based Power Query is powerful, but large-scale ETL still favors desktop or server-based solutions in many scenarios.
- Licensing nuance: Feature availability sometimes depends on channel, build, or license—expect uneven user experiences across organizations.
Final verdict: a pragmatic embrace with strong guardrails
The January 2026 Excel refresh is a meaningful step toward making data work less tedious and more accessible. Agent Mode’s multi-step automation, Power Query in the web, and the new import functions simplify common pain points for analysts and casual users alike. Office Scripts’ PDF/email enhancements bring practical automation that many teams will immediately adopt.That said, the power of these features depends on careful governance. Organizations should treat Agent Mode and model selection as capabilities that require policy, auditing, and training, not as turnkey replacements for analytical rigor. For everyday analysts and spreadsheet authors, the advice is straightforward: experiment eagerly, validate consistently, and ask IT to help set sensible guardrails.
Quick reference: how to try January’s features today
- Confirm your Excel channel and build (Insiders vs. production) if you want early access to Import Functions and descriptive error cards.
- Open Excel for the web and look for the Power Query / Get Data experience in the Data ribbon to try the new web editor.
- In desktop Excel, check the Copilot pane for Agent Mode and try a small workflow; review the model selector if your admin permits it.
- Use the Office Scripts code samples to create a “Save as PDF and email” script and test delivery with a non-sensitive workbook.
Microsoft’s January updates to Excel make the application both more capable and more consequential. The new capabilities reduce friction for common workflows, enable cloud-first automation, and bring AI-assisted editing closer to mainstream use—but they also force organizations to think critically about model governance, data handling, and change control. Adopt these tools with intention: they’ll save time and unlock new possibilities when used with clear policies and consistent validation.
Source: Neowin https://www.neowin.net/news/here-are-all-the-features-microsoft-added-to-excel-in-january-2026/
