Microsoft has kicked off 2026 with a wave of Excel updates that go far beyond the usual incremental refinements. This year, the theme is unmistakable: automation that actually meets users where they are. Whether you manage financial models, operational dashboards, or enterprise reporting pipelines, the latest round of features is designed to eliminate the manual grunt work that has always slowed Excel workflows down. Here is a look at the most impactful automation features landing in Excel this year, and what they mean for your business.

Copilot Agent Mode: Natural-Language Automation Comes to the Grid

The single biggest change in Excel this year is the arrival of Agent Mode, now rolling out across Windows, Mac, and the web. Agent Mode is a Copilot-powered feature that lets users describe outcomes in plain English rather than building formulas step by step. Need to clean a messy dataset, generate a pivot table summary, or build a multi-step financial model? Simply tell Agent Mode what you want, and it creates the formulas, transformations, and layouts for you.

What makes Agent Mode more than a novelty is its iterative approach. It doesn’t just fire off a single formula and walk away. It can work through multi-step tasks, adjusting as it goes, while keeping you in control of every change. Microsoft has also added web search grounding and a model switcher to improve the accuracy and flexibility of Copilot’s responses. For teams that rely on Excel for complex reporting or analysis but lack deep formula expertise, Agent Mode dramatically lowers the barrier to entry. For a deeper look at how AI-driven automation is transforming Excel workflows, Analytics Insight’s coverage of the January update provides an excellent overview.

IMPORTTEXT and IMPORTCSV: Formula-Based Data Imports Without Power Query

Power Query is one of Excel’s most powerful tools, but for years users have told Microsoft the same thing: it’s overkill for simple imports. In January 2026, Microsoft answered with two new functions—IMPORTTEXT and IMPORTCSV—that let you pull data from .txt, .csv, and .tsv files directly into a dynamic array using a single formula.

IMPORTTEXT is the more flexible of the two, accepting parameters for delimiters, encoding, row skipping, and locale settings. IMPORTCSV is a streamlined shorthand that assumes comma-delimited, UTF-8 encoded data—perfect for clean CSV exports from other applications. Both functions return refreshable dynamic arrays, which means the data stays connected to its source file and updates when you refresh.

The real power emerges when you combine these import functions with other modern Excel functions like FILTER, SORT, and GROUPBY. You can import, filter, and summarize an external dataset in a single formula chain with no VBA, no Power Query, and no manual copy-paste. The Microsoft 365 Insider Blog announcement walks through the syntax and use cases in detail.

Power Query on the Web and Enhanced Data Transformation

For those workflows that do demand the full Power Query experience, 2026 brings a long-awaited milestone: full Power Query support in Excel for the web. Previously limited to the desktop client, users can now import, transform, and edit data directly in the browser through the Data > Get Data interface. This is a significant step toward platform parity and a game-changer for organizations with mixed-OS environments or remote-first teams who rely on the web client.

Additionally, Microsoft has enhanced Power Query’s conversational capabilities. Users can now describe data-cleaning tasks in natural language, such as “Merge these two tables on the customer ID column” or “Remove rows where the date field is blank,” and Power Query generates the transformation steps automatically. This makes Power Query far more accessible to users who have historically avoided it due to its learning curve.

Office Scripts: Automating Exports and Email Workflows

Office Scripts, Excel’s cloud-based automation layer, has gained a new capability that many users have been requesting: the ability to save worksheets as PDFs directly from a script. This means you can now build automated workflows that generate a report in Excel, export it to PDF, and email it to stakeholders—all without manual intervention. The feature works across Windows, Mac, and the web, making it a reliable option for cross-platform teams.

When paired with Power Automate, this opens up powerful recurring workflows. For example, a finance team could schedule a flow that refreshes a workbook’s data connections every Monday morning, exports the summary sheet as a PDF, and distributes it to a distribution list. That kind of hands-free reporting used to require custom VBA and IT involvement. Now it’s achievable with no-code tools built right into the Microsoft 365 ecosystem. If your organization is exploring Excel automation strategies, our team at ExcelHelp can help you design and implement solutions like these—learn more about our automation consulting services.

Smarter Error Handling and Formula Completion

Two smaller but highly practical improvements round out the automation story. First, Excel now offers descriptive error cards that explain what went wrong with a formula and suggest specific fixes. Instead of staring at a cryptic #VALUE! or #N/A error, users see a plain-English explanation and actionable next steps. For complex workbooks with hundreds of interconnected formulas, this alone can save hours of debugging time.

Second, formula auto-completion has gotten significantly smarter. Excel now suggests and completes formulas as you type based on the context of your data, reducing syntax errors and speeding up the formula-building process. For teams who handle large-scale reporting, these seemingly small quality-of-life improvements add up to meaningful productivity gains across every workbook.

Auto-Refreshing SPILL Pivot Tables

Pivot tables remain one of Excel’s most powerful features, and in 2026 they’re getting a notable upgrade. Pivot tables now support SPILL behavior and auto-refresh. Results expand dynamically as the underlying data changes, and the pivot table updates automatically without requiring a manual refresh. This ensures that dashboards and summary reports always reflect the latest data, eliminating a common source of stale reporting and manual upkeep. For a comprehensive list of all 17 new features, Geeky Gadgets’ roundup covers the full scope of what’s new.

What This Means for Your Organization

The 2026 automation features share a clear theme: Microsoft is making it possible to do more in Excel without needing deep technical expertise. Agent Mode, natural-language Power Query, IMPORTTEXT/IMPORTCSV, and Office Scripts-based PDF exports all reduce the dependency on VBA developers or IT teams for routine automation tasks. That’s good news for organizations looking to scale their Excel capabilities without scaling their headcount.

However, automation without a plan can introduce its own problems. AI-generated formulas still need validation. Automated data pipelines still require governance and documentation. The organizations that will get the most out of these features are the ones that pair the new tools with structured training and thoughtful oversight.

That’s where working with experienced Excel consultants makes a real difference. Whether you need help designing automated reporting workflows, training your team on Copilot and Agent Mode, or building enterprise-grade Excel solutions that take advantage of the latest features, the ExcelHelp team is here to help—explore our Excel training programs to get your team up to speed on what’s possible in 2026.

 

Ready to put these features to work for your business?

Contact ExcelHelp today at (800) 682-0882 or visit excelhelp.com for a free consultation.

---

Building something critical? ExcelHelp.com has spent 15+ years developing custom Excel solutions for inventory management, financial reporting, and business automation. Our US-based team combines AI acceleration with deep Excel expertise to deliver applications that handle real-world complexity. We know what works because we’ve built hundreds of these systems.

Talk to our team about your project.