How to Open Power Query Editor in Excel

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, open the Power Query Editor from Data > Get Data (Power Query) > Launch Power Query Editor, or select a table and choose Data > From Table/Range. The editor lets you import, clean, reshape, and preview data before loading it into a worksheet or data model. You will need a supported desktop version of Excel and, for the table method, a range of data or an Excel table.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the Data tab available. Power Query is built into current desktop Excel; you normally do not need to install a separate add-in.
  • A workbook in which you have permission to create or edit queries. If you are working with a shared or protected file, your access may limit what you can change.
  • For the From Table/Range route, a set of data arranged in columns with a header row. It helps to remove completely blank rows and columns first.
  • For an existing query, the workbook that contains it. Save a copy before making substantial changes to a query that other worksheets or reports depend on.

Step-by-Step

  1. Open the workbook and check the ribbon. Open the workbook where you want to create or edit a query. Select the Data tab. Look for the Get & Transform Data group or a Get Data button. In current Windows versions of Microsoft 365, Power Query is part of Excel, so a separate Power Query download is generally unnecessary. If the ribbon is minimized, click a tab to show its commands or expand the ribbon.
  2. Choose how you want to open the editor. If you only want the editor window, open Data > Get Data (Power Query) > Launch Power Query Editor. Depending on the Excel build and ribbon layout, the command may appear as Data > Get Data > Launch Power Query Editor. This opens the editor without requiring you to start by importing a particular file. If you do not see that command, use one of the data-based routes below; the editor also opens when you start a query and choose to transform its data.
  3. To work with worksheet data, select the data first. Click a cell inside the range you want to use. The data should have one clear header row, with each column holding one type of information, such as dates, names, or amounts. If the range is not already an Excel table, choose Data > From Table/Range. Excel may ask you to confirm the range and whether it has headers. Check both, then select OK. The Power Query Editor opens with a preview of the selected data. If the data is already a table, selecting a cell in it and using the same command is sufficient.
  4. To open data from a file or another source, start an import. Choose Data > Get Data, then select the appropriate source, such as From File or From Text/CSV. Browse to the file or enter the required source details. If Excel first displays a preview or Navigator window, select the table or sheet you want and choose Transform Data to open the editor. Choosing Load at that point instead may load the data without opening the editor, so use the transform option when you want to inspect or change it first.
  5. To reopen a query already in the workbook, find it in the query pane. On the Excel ribbon, choose Data > Queries & Connections. In the pane that opens, select the Queries tab if needed. Find the query by name, then right-click it and choose Edit. In many builds, double-clicking the query name also opens it. The editor opens with its existing steps and a data preview, rather than starting a new query.
  6. Check that you are in the right window. The Power Query Editor is a separate window from the worksheet. It usually shows a data preview in the middle, query names on the left, and Query Settings with Applied Steps on the right. The editor has its own tabs, including Home, Transform, and Add Column. If you see only a source-selection dialog or Navigator, you have not reached the editing window yet; select Transform Data to continue.
  7. Make a small check, then return the result to Excel. Confirm the query name and preview before changing anything. When you are finished, choose Home > Close & Load to load the result using Excel’s default destination. To choose where it goes, use the arrow next to Close & Load and select Close & Load To…, then pick a worksheet, a new worksheet, or another available destination. Closing the editor this way saves the query steps in the workbook; it does not simply discard the query.

For a blank query on Windows, open Data > Get Data > From Other Sources > Blank Query if that option appears in your Excel build. This is useful when you plan to build a query without selecting a worksheet range or a source file first. Menu labels and grouping can vary slightly by update, so the key action is to start a blank query or choose Transform Data from a source preview.

Common Mistakes

  • Choosing Load instead of Transform Data. In a file-import workflow, Load can send the selected data straight to Excel. If you want to inspect or clean it in the editor, select Transform Data in the preview or Navigator window.
  • Looking for a separate Query Editor button in the wrong place. The command is on the Data tab under the Get Data or Get & Transform controls. It is not a command on the worksheet’s right-click menu.
  • Selecting only part of a dataset. If you use From Table/Range with a partial selection, Excel may create a query from only that portion. Click inside the intended table, or check the range in the confirmation box before proceeding.
  • Confusing the Navigator with the editor. Navigator is where you choose a sheet or table from a source. Choose Transform Data there to open the editor; selecting a source in Navigator alone does not mean you are editing its steps.
  • Assuming a query preview is the worksheet output. The preview is shown in the editor. To place or update results in the workbook, use Close & Load or refresh the query after closing.

Tips

  • Use descriptive names. In the editor, name a query for its source or purpose, such as “Monthly Orders” or “Cleaned Inventory.” Clear names make the Queries & Connections pane easier to navigate later.
  • Keep source data consistent. Give each column a header, avoid merged cells, and keep one record per row. A tidy source makes the preview easier to understand and reduces errors when the query is refreshed with new data.
  • Use the existing query when you mean to update it. If a workbook already contains a query that loads to a report, edit that query through Data > Queries & Connections rather than accidentally creating a second query from the same source.
  • Remember that query edits are recorded as steps. The Applied Steps list shows transformations in order. If a change produces an unexpected preview, select the step that introduced it or remove that step, rather than rebuilding the entire query immediately.
  • Save before larger changes. A query can feed tables, charts, or other queries. Keeping a copy lets you recover if a change affects dependent outputs or if you need to compare the old and new results.
  • Account for platform differences. On Excel for Mac, Power Query features and available sources depend on the Microsoft 365 update and may not match Windows exactly. Check the Data tab for Power Query or Get Data commands; if the editor or a source is missing, update Excel and consult Microsoft’s current Mac feature availability. Excel for the web has different authoring capabilities from desktop Excel, so use the Windows desktop app if the editor command is unavailable online.

Troubleshooting

The Launch Power Query Editor command is missing. First expand the ribbon and inspect the Data tab for Get Data, Get & Transform Data, or a Power Query menu. Ribbon labels can differ between builds. Try selecting a cell in a table and choosing Data > From Table/Range, or start an import and choose Transform Data. If none of these options appears, check that you are using a supported desktop version of Excel and install available Office updates.

From Table/Range is unavailable or grayed out. Click a cell inside the intended data, rather than selecting a chart, a shape, or a blank worksheet cell. Check whether the worksheet is protected or the workbook is in a restricted editing state. If the range is on a protected sheet, you may need permission to unprotect it or to work with an unprotected copy. Also make sure the selection contains ordinary tabular data.

The source-selection window appears, but the editor does not. In Navigator, select the relevant sheet or table and choose Transform Data. If you selected Load, Excel may have loaded the data instead. You can still open the new query through Data > Queries & Connections, right-click its name, and select Edit.

You cannot find an existing query. Open Data > Queries & Connections and look under the Queries tab. If the pane lists connections but no queries, check whether you opened the correct workbook and whether the data was loaded as a regular range rather than created as a Power Query query. A worksheet table by itself is not necessarily a query.

The editor opens but shows an error or no preview. Check the source path, file permissions, network connection, and any sign-in prompt. For a file that has moved, the query may still point to its old location. Use the source step in Applied Steps to review the source settings, then reconnect to the correct file or location. If a work-managed source requires credentials, sign in with an account that has access.

Frequently Asked Questions

Is Power Query Editor the same as Query Editor?
In current Excel, the feature is generally called Power Query, and its editing window is the Power Query Editor. “Query Editor” is a common shorter name for the same window.

Can I open the editor without importing data?
Yes. On Windows, use Data > Get Data > From Other Sources > Blank Query if available, or choose Launch Power Query Editor from the Get Data menu. The precise menu arrangement can vary by Excel update.

How do I open a query I already made?
Choose Data > Queries & Connections, find it under Queries, then right-click the query and select Edit. Double-clicking its name may also open it.

Does opening the editor change my worksheet data?
Opening it does not by itself change the loaded worksheet results. Changes you make are saved as query steps when you close and load; the query output changes when you load or refresh it.

Can I use Power Query in Excel for Mac?
Some Power Query functionality is available in Microsoft 365 for Mac, but supported sources and editing features can differ from Windows and vary by update. Check the Data tab and update Excel if you do not see the options described here.

Can I edit queries in Excel for the web?
Web support differs from desktop Excel and may not expose the same editor or all source controls. If you cannot find the query-editing command in the browser, open the workbook in the Windows desktop app and use Data > Queries & Connections.

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.