Excel Browser Power Query: What It Is & How to Use

How-to basics · Updated November 22, 2026

Yes, Power Query is available in Excel for the web (browser), but only for viewing and refreshing existing queries—you cannot create or edit queries in the browser. This article explains exactly what you can do in the browser version, how it differs from the desktop app, and how to get the most out of it.

What Is Power Query in Excel?

Power Query is a data connection and transformation tool built into Excel. It lets you import data from various sources (like databases, web pages, CSV files, and folders), then clean and reshape that data before loading it into a worksheet or the Data Model. In Excel for Microsoft 365 on Windows, the full Power Query editor is available under the Data tab > Get Data. In the browser (Excel for the web), the editor is not available, but existing queries can be refreshed and their results viewed.

What You Can Do in the Browser

In Excel for the web, Power Query functionality is limited to:

  • Refresh an existing query that was created in the desktop app.
  • View the query results in a table on the sheet.
  • See the query steps and source information (read-only).

You cannot open the Power Query Editor, add new queries, change steps, or modify the M code in the browser. This is a deliberate design choice by Microsoft—the full editor is a desktop feature.

How to Refresh a Query in Excel for the Web

If you have a workbook with a query that was created in Excel desktop, you can refresh it in the browser as follows:

  1. Open the workbook in Excel for the web.
  2. Go to the Data tab on the ribbon.
  3. Click the Refresh All button (or the refresh icon next to a specific query if you have the Queries pane open).

The refresh will re-run the query and update the data in the sheet. Note: this requires that the data source is accessible from your browser (e.g., a public web page or a file in OneDrive). If the source requires authentication, you may be prompted to sign in.

Key Differences: Desktop vs. Browser

The most significant differences are:

  • Editing: Desktop allows full editing; browser is read-only for queries.
  • Data sources: Desktop supports hundreds of connectors (SQL Server, Oracle, OData, etc.); browser only refreshes sources that are already defined and accessible.
  • Performance: Desktop uses your local machine’s resources; browser uses cloud resources, which can be faster for large datasets but may have limits.
  • M code: Desktop lets you view and edit M code; browser hides it.

If you need to modify a query, you must do it in the desktop app (Excel 2016 or later, or Microsoft 365). After saving and uploading the workbook to OneDrive or SharePoint, the changes appear in the browser.

Common Problems and Workarounds

Users often encounter these issues when using Power Query in the browser:

  • “Refresh is greyed out” – This usually means the workbook is in a format that doesn’t support queries (e.g., .xls) or the query has been disabled by an admin. Convert to .xlsx and check with your IT department.
  • Data source not accessible – If the source is a local file on your computer, the browser can’t reach it. Upload the source to OneDrive or use a cloud data source.
  • Query results are not updating – Check that the query is set to refresh on open, or manually click Refresh All.
  • “We couldn’t refresh the connection” – This often happens when the source requires a login. Sign in to the source in the browser, or use a stored credential in the query.

For most problems, the solution is to edit the query in desktop Excel, then re-upload the workbook.

How to Create a Query in the Browser (Alternative)

While you can’t use Power Query in the browser, you can still import data using built-in browser features:

  • Data > From Text/CSV – This uses a simplified importer that lets you choose a file and load it as a table, but it doesn’t have the transformation steps of Power Query.
  • Data > From Web – Similar to the desktop, but with limited options.

For complex transformations, you’ll need to use the desktop app. If you don’t have Excel desktop, consider using Google Sheets (which has a similar but separate “Data” menu) or a free tool like Power BI Desktop (which also uses Power Query).

Cost and Licensing

Power Query in Excel for the web is included with any Excel for the web subscription (free or Microsoft 365). The desktop version of Power Query is included in Excel 2016 and later, and in Microsoft 365. There is no extra cost for the feature itself. However, some premium connectors (e.g., certain database sources) may require a separate license or a Power BI Pro subscription if you use them in Power BI.

Frequently Asked Questions

Can I edit a Power Query in Excel online?

No, the Power Query Editor is not available in Excel for the web. You can only refresh and view query results. To edit, use the desktop app.

Why is my Power Query not refreshing in the browser?

This can happen if the data source is not accessible (e.g., a local file), if the workbook is in an older format, or if you’re not signed in to the source. Check the source and try refreshing again.

Is Power Query the same as Get & Transform?

Yes, “Get & Transform” is the name used in Excel 2016 and later for the Power Query technology. They are the same thing.

Can I use Power Query in Excel for free?

Yes, Excel for the web is free to use with a Microsoft account, and it includes the ability to refresh queries. The desktop version requires a paid license, but you can use the free trial or the Excel mobile app.

Does Power Query work on Mac?

Power Query is available in Excel for Mac (Microsoft 365) since version 16.54 (2021). The interface is similar, but some connectors may differ. The browser version on Mac is the same as on Windows.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.