Open Power Query in Excel for the Web: Step-by-Step

How-to basics · Updated November 20, 2026

To open Power Query in Excel for the web, open your workbook, select Data > Get Data > Launch Power Query Editor. To work on a query that already exists, select Data > Queries, choose the query, then select Edit if that option is available. The editor lets you connect to data, shape it with steps such as filtering or changing column types, and load or refresh the result. The exact options can vary with your account, workbook, and the data source.

What You’ll Need

  • An up-to-date web browser and access to Excel for the web through a Microsoft account. Power Query features and available connectors can depend on your Microsoft 365 plan, organization settings, and rollout.
  • A workbook saved in OneDrive or SharePoint so you can open and edit it in Excel for the web. If your file is only on your computer, upload it to OneDrive or SharePoint first, or open it in desktop Excel instead.
  • If you are editing an existing query, a workbook that contains that query. If you are connecting to a protected source, you may also need permission to the source and the appropriate sign-in details.

Step-by-Step

  1. Open the workbook in Excel for the web. Go to Microsoft 365 or OneDrive, locate the workbook, and open it in your browser. If it opens in a preview or another app, choose the option to edit it in Excel for the web. Wait for the workbook to finish loading and, if necessary, confirm that you have editing access. For a file on your computer, upload it to OneDrive or SharePoint and open the uploaded copy.
  2. Find the Data tab. Select Data in the ribbon at the top of the workbook. If the ribbon is collapsed, expand it using the ribbon display control. On a narrow browser window, some commands may be grouped under a menu or hidden from view; widen the window or use the ribbon search if your Excel interface offers it. Make sure you are in Excel, not just viewing a file in OneDrive.
  3. Open the Power Query editor for a new connection. Select Get Data on the Data tab, then choose Launch Power Query Editor. In some interface versions, the wording or placement may differ slightly. This opens the query editor in the browser, where you can start a query by choosing an available data source or creating a query using the options shown. If the launch command is missing, read the troubleshooting section below before assuming that the workbook is damaged.
  4. Choose a source and connect. In the editor, select a connector that matches where your data is stored, such as a file or an online service, if that connector is available to your account. Follow the prompts to enter a location or sign in. Use the correct account for the source: being able to open the workbook does not automatically grant access to a separate SharePoint site, database, or service. Check the preview and select the relevant file, table, or data set when prompted.
  5. Make the changes you need. Use the editor’s commands to transform the preview, for example by removing unnecessary columns, filtering rows, splitting a column, or setting a data type. Each transformation is recorded as a query step, so the same change can be applied again when the query is refreshed. Review the preview after each important change. For example, if a date column appears as text, use the data type control to select a suitable date type and check that the dates are interpreted correctly.
  6. Save or apply the query and return to the workbook. When your changes are ready, use the editor’s available command to save or apply them. The precise button label and load options can vary. If Excel asks where to place the results, choose an appropriate destination and check that it will not overwrite existing worksheet content. Allow the workbook to finish processing before closing the browser tab. Saving the workbook preserves your changes; it does not guarantee that every external source can be refreshed in the web app.
  7. Edit a query that is already in the workbook. Return to the worksheet, select Data > Queries to open the queries pane, and locate the query by name. Select it and look for Edit; in some layouts, you may need to open the query’s menu first. The query editor should open with the existing steps. Select a step to inspect it, make the required change, and apply or save the query. If you only need current data rather than a change to the query, use the available refresh command instead of editing its steps.
  8. Check the result. After applying changes, look at the output table or destination sheet. Confirm that the expected columns and rows appear, that headings are sensible, and that dates and numbers have the right types. If the query is meant to update periodically, use the refresh option available in Excel for the web and check for a completion message or error. Save the workbook and reopen it if you need to verify that the edits were retained.

Common Mistakes

Looking for Power Query on the wrong tab: The editor is accessed from the Data tab, not the Home tab. Find Get Data there, then look for the editor launch command.

Expecting desktop Excel’s full set of commands: Excel for the web and Excel for Windows do not have identical Power Query features. Some connectors, transformations, query properties, or refresh scenarios may be unavailable in the browser. If a command is missing, check the web app’s available options rather than following a desktop-only tutorial step by step.

Opening the wrong copy of a workbook: A downloaded local copy and the cloud copy are separate files. Changes made in one do not necessarily appear in the other. Check the file name and OneDrive or SharePoint location before editing.

Confusing refresh with edit: Refresh asks Power Query to retrieve data using the existing instructions. Edit opens the query steps so you can change those instructions. Refresh will not fix an incorrect filter or rename a column in the query itself.

Assuming a workbook permission is enough: A user may be able to edit the workbook but lack permission to its source. Confirm that you can sign in to the data source and that your organization allows the connection.

Tips

  • Use a wide browser window. The ribbon and query pane are easier to navigate on a desktop-sized screen. If a command appears absent, expand the ribbon or widen the window before troubleshooting further.
  • Give queries descriptive names. A name such as Monthly Orders is easier to recognize in the Queries pane than Query1, particularly when a workbook contains several data connections.
  • Make one change at a time. After filtering, renaming, or changing a data type, inspect the preview. If the result is unexpected, you can identify which recent step caused it more easily.
  • Keep a copy before substantial changes. For an important workbook, make a duplicate in OneDrive or SharePoint before changing a query or its output location. This gives you a recovery point if a later edit changes the results.
  • Check the source and destination separately. A successful preview means Power Query could read data for that step; it does not by itself confirm that the final output is in the intended sheet or that scheduled or future refreshes will work.
  • Use desktop Excel when needed. If the browser lacks a connector or editing feature that your workbook depends on, open the same cloud file in the Excel desktop app. The exact experience may differ between Windows and Mac, and between Excel versions.

Troubleshooting

Get Data or Launch Power Query Editor is missing: Confirm that you opened the workbook in Excel for the web and selected the Data tab. Expand the ribbon, widen the browser, and check whether the command is tucked into a menu. Sign in with the Microsoft account that has access to the workbook. If the option remains unavailable, your account, organization settings, or current web-app version may not include that feature. Try a supported Microsoft 365 account or open the workbook in desktop Excel.

The Queries pane is empty or a query is not listed: Make sure you opened the right workbook and that it is the cloud copy containing the query. Check that you have editing access, then reload the page after allowing any save operation to finish. If another person recently changed the workbook, ask them to confirm that the query was saved. A worksheet table containing imported values is not necessarily a saved Power Query connection; the Queries pane lists queries that are part of the workbook.

The editor opens but cannot connect to the source: Check the source address, network access, and sign-in method. Sign in with an account that has permission to the source, and ask your Microsoft 365 administrator whether access to that connector is restricted. Some sources or authentication methods that work in desktop Excel may not be supported for the same operation in Excel for the web. Try the desktop app if the web editor does not offer the required connection method.

Refresh fails or returns different data: Check whether the source has moved, whether your account credentials have expired, and whether the source data has changed its column names or format. If the query relies on a local file path, the browser may not be able to reach that path. Reconnect using a supported cloud location or use desktop Excel when the query depends on local resources. Review the error details before changing steps, since a connection problem and a transformation problem need different fixes.

The results do not appear where expected: Check the query’s load destination and whether the destination area contains existing data. Look for a completion message, allow processing to finish, and then check the relevant worksheet or table. If an option to load results is not offered in the web editor, use the available web workflow or open the workbook in desktop Excel to configure the output.

Frequently Asked Questions

Can I open Power Query in Excel for the web without creating a query?
Yes. To inspect or change a saved query, use Data > Queries, select it, and choose Edit if that command is available. Use Get Data when you want to start a new connection.

Is Power Query available in every Excel for the web account?
Availability depends on the account, Microsoft 365 plan, organization settings, and feature rollout. If the Data tab does not show the relevant commands, check that you are signed in to the correct account and ask your administrator about availability.

Can I refresh an existing query in the browser?
Some queries can be refreshed in Excel for the web, but refresh support depends on the source, credentials, and query setup. Use the refresh command shown in the workbook and read any error message. A query that cannot refresh in the browser may need desktop Excel or a different connection setup.

Do I need to download the workbook to use the editor?
No, if the query editor is available for your account and workbook, you can open it in Excel for the web. Keeping the workbook in OneDrive or SharePoint makes it accessible in the browser. Downloading a copy is an alternative when you need desktop Excel, but remember that the downloaded file and cloud file can diverge.

Why can I see query results but not edit the query?
The cells may be a static copy of data, or you may have view-only access, a different workbook copy, or a web version without the needed editing command. Check Data > Queries, confirm your permissions, and verify that you opened the workbook that contains the saved query. If the editor is still unavailable, try desktop Excel.

Does opening the editor automatically update the worksheet?
No. Opening or editing a query is not the same as refreshing it. Apply or save query changes, confirm the output destination, and refresh when you need the latest source data. Review the resulting table before relying on it.

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.