For years, data professionals and everyday spreadsheet users have shared a common insight: Power Query is one of the most powerful tools in Microsoft Excel. It serves as a robust connection and transformation engine, enabling you to connect to multiple data sources, clean messy data effortlessly, and automate repetitive tasks.
Until recently, that power was limited to the full Windows desktop client. That changes today. With Power Query now generally available in Excel for the Web (2026), this release levels the playing field giving everyone access to advanced data transformation capabilities, regardless of operating system or device. In this article, we’ll explore what this update means for you and how it can benefit professionals who rely on Excel every day.
What It Means for You
1. No More Desktop Dependency
Power Query is now accessible through a web browser, making it completely operating system–agnostic. Mac users, who have historically experienced a limited or inconsistent Power Query feature set compared to Windows, can now access its full capabilities directly in Excel for the Web. Linux and Chromebook users are also fully included in the data preparation experience.
2. Seamless Cloud Collaboration
Excel for the Web has always excelled at real-time co-authoring. Now, your data workflows can live entirely in the cloud. You can build complex data transformation pipelines in shared OneDrive or SharePoint files, allowing colleagues to access, review, edit, or refresh queries through a simple browser link, without worrying about version control or desktop software compatibility.
3. A Familiar, Modernized Experience
If you’ve used Power Query on the desktop, you’ll feel right at home in the web version. The interface remains highly consistent, now even more refined, with similarities to modern data tools like Dataflow Gen2. You still get the familiar ribbon, formula bar (M code), and step-by-step “Applied Steps” pane. The logic remains exactly the same.
Benefits for Excel-Dependent Professionals
Accountants and Finance Professionals
Automate repetitive data preparation tasks for each reporting cycle. Spend more time analyzing data and less time preparing it.
Marketing and Sales Teams
Combine data from multiple sources, such as CRM systems, web analytics, and email campaigns without relying on IT support. They get to clean and merge data on their own schedule.
Educators and Students
Learn data transformation concepts within a familiar Excel environment. These skills transfer directly to real-world, professional workflows.
Casual Excel Users
Even simple tasks like combining CSV files or removing duplicates—can become repeatable workflows, saving time with every use.
How to Get Started Today
To begin transforming your data in the browser:
- Open Excel for the Web at
excel.microsoft.com
Open an existing workbook or create a new one.
2. Navigate to the Data tab on the ribbon and select Get Data to start the import process
3. Choose your data source and follow the prompts to launch the Power Query Editor.
Power Query in Excel for the Web is more than just a feature release, it’s a major step toward accessibility. The same powerful data preparation engine that professionals have relied on for years is now available to anyone with a browser and an internet connection.
Whether you’re cleaning a small dataset for a quick analysis or building enterprise-scale data pipelines, Power Query in Excel for the Web gives you the tools to work smarter and more efficiently.
Note:
Viewing and refreshing queries is available to all Microsoft 365 Subscribers.
The full Power Query experience is available to all Microsoft 365 Subscribers with Business or Enterprise plans.
