How to Find Power Query in Excel and Open the Editor

In Excel for Microsoft 365 on Windows, open the Data tab and choose Get Data to find Power Query; choose Launch Power Query Editor to open the editor directly. To open a query that already exists, go to Data > Queries & Connections and double-click the query. Power Query is Excel’s built-in tool for importing, cleaning, and reshaping data before loading it into a worksheet or the Data Model.

You do not need to install a separate Power Query add-in in current Microsoft 365 Excel for Windows. The labels and available sources can vary by platform and update, so the steps below explain both the direct route and how to open the editor through an import.

What You’ll Need

Excel for Microsoft 365 on Windows for the ribbon paths in the main steps. Excel 2016 and later for Windows also include Power Query as part of the Data tab’s Get & Transform features, though the layout can differ.
A workbook to work in. You can open the editor without choosing a data source, but a file, table, or other source is useful if you want to try a query.
Permission to access the source data. For example, a password-protected workbook or a company database may require sign-in details.

Step-by-Step

Open Excel and a workbook. Start Excel and open the workbook where you want to create or manage a query. If you are only checking whether Power Query is available, a blank workbook is fine. You can also use an existing workbook containing data or queries.
Select the Data tab. Find Data on the ribbon at the top of the Excel window. Power Query commands are grouped with data import and transformation tools, rather than on the Home or Formulas tab. If the ribbon is minimized, click a tab to show its commands or expand the ribbon using the ribbon display control.
Look for Get Data. On the Data tab, find the Get & Transform Data group and open Get Data. This dropdown is the main entry point to Power Query in Windows Excel. It may show options such as importing from a file, database, online service, or another source, along with query-combining commands.
Open the editor directly, if the command is available. In the Get Data menu, select Launch Power Query Editor. The Power Query Editor opens in a separate window. If you do not see this option, use the import route in the next step or check the troubleshooting section; menu contents can vary with Excel build and ribbon layout.
Open the editor by starting an import. From Data > Get Data, choose a source that matches your data, such as From File > From Workbook for another Excel file or From Table/Range for data already in your current workbook. Browse to the file or select the relevant range as prompted. For a worksheet range, Excel may ask you to confirm or create a table before continuing.
Choose Transform Data. When the Navigator window appears for a file or other source, select the sheet, table, or object you want, then click Transform Data. This opens the selected data in Power Query Editor so you can inspect and change it. Clicking Load instead usually loads the data directly and skips the editing stage for that import.
Locate the query list in the editor. Once the editor is open, look for the Queries pane on the left. It lists the queries in the current workbook. Select a query to preview its data and review its steps. The settings or applied steps pane is generally on the right; if a pane is hidden, check the editor’s View options.
Return the result to Excel when ready. To finish editing, use Home > Close & Load to load the result to a worksheet, or open the Close & Load dropdown for available loading options. The query remains associated with the workbook, so you can refresh it later rather than repeating the cleanup manually.
Open a query that is already in the workbook. In the Excel window, choose Data > Queries & Connections to show the pane. On the Queries tab, double-click the query you want to edit. You can also right-click a query and choose Edit. If the pane is empty, the workbook may not contain a saved Power Query query, or you may be viewing a different workbook.

Common Mistakes

Looking on the wrong tab. Power Query is accessed from Data, not from the standard Insert or Formulas tabs. Search the Data tab’s Get & Transform Data group first.
Expecting every Get Data option to open the editor immediately. Choosing a source often opens a file picker or Navigator first. Select the data item and then choose Transform Data to enter the editor.
Clicking Load when you meant to edit. Load sends the selected result into Excel. If you need to change column types, remove rows, or combine data before loading, choose Transform Data in Navigator.
Confusing the query pane with the editor. Queries & Connections is a pane in the Excel window; it lists queries and lets you manage or edit them. The Power Query Editor is a separate window where you work through transformation steps.
Assuming Power Query is missing because a button is not visible. A narrow Excel window, simplified ribbon, older build, or different platform can change what is shown. Maximize the window, expand the ribbon, and check the Get Data dropdown before concluding that the feature is unavailable.

Tips

Use From Table/Range for data already in the workbook. If your source is a plain range, click inside it and choose Data > From Table/Range where shown. Excel may convert the range to a table; give the table clear column headings before importing. This makes the query easier to understand and refresh.
Use Transform Data when you want to inspect first. The editor previews the source and records each change as an applied step. You can check the result before loading it, which is especially helpful when importing a large file or cleaning inconsistent columns.
Keep the original source intact. Power Query transformations do not normally edit the source file itself. They create a query result that can be loaded to Excel. Keep the source in a stable location if you expect to refresh the query later.
Give queries meaningful names. Names such as MonthlySales or CleanedContacts are easier to identify than Query1. In the editor, select a query and use its properties or the query settings to rename it.
Know that refresh reruns the steps. After you update the original source, use Data > Refresh All in Excel or right-click a query in Queries & Connections and choose Refresh. If the source has moved or access has changed, update the source path or credentials rather than rebuilding the query.
Do not confuse Power Query with Power Pivot. Power Query imports and transforms data. Power Pivot is for working with a data model and relationships. They can be used together, but the Power Query entry point is under Data and Get Data.

Troubleshooting

Get Data or the Data tab is not visible: Make sure you are using the desktop Excel app, not a different spreadsheet program. Maximize Excel and expand the ribbon. In a customized ribbon, the Data tab may be hidden; open Excel’s ribbon customization options and re-enable Data. If you are using an older Excel release, install available Office updates and check that your edition supports the Get & Transform features.

Launch Power Query Editor is missing: Start an import instead: choose Data > Get Data, select a source, and choose Transform Data in Navigator. This route opens the editor even when a direct-launch command is not shown. If neither route is available, check your Excel version and update Microsoft 365 through File > Account > Update Options > Update Now, where those commands are available in your installation.

Queries & Connections is empty: Confirm that the workbook containing the query is the active workbook. Check whether the data was simply pasted into cells or loaded without creating a saved query. A normal worksheet table is not automatically a Power Query query. To create one, select the table or range and use Data > From Table/Range.

The editor opens but the data is not listed: In Navigator, expand the workbook items and select the correct sheet or table. Some source files contain several sheets, named ranges, or tables, and the desired data may not be the first item. For a current-workbook range, ensure the data has recognizable headers and that you selected the intended cells.

You are on a Mac: Power Query support and the available connectors depend on your Excel for Mac version and update channel. Check the Data tab for Get Data (Power Query) or related import commands; choose an available source and use its transform or edit option. If the editor or a connector is absent, update Excel from Microsoft AutoUpdate and consult the current Microsoft support information for Mac feature availability. The Windows labels and source list are not guaranteed to match the Mac ribbon.

You are using Excel for the web: Power Query options in the browser depend on your account and the features currently supported for that workbook. Look under Data for Get Data or query-editing commands. If the option you need is unavailable, open the workbook in the desktop Excel app and use the Windows or Mac steps above.

Frequently Asked Questions

Is Power Query already included in Excel?
Yes. In current Excel for Microsoft 365 on Windows, Power Query is built into the Data tab as Get Data and Get & Transform features. You generally do not need to download a separate add-in.

Where do I find Power Query Editor?
On Windows, look under Data > Get Data > Launch Power Query Editor. If that command is not shown, start an import and click Transform Data in Navigator.

How do I edit a query I have already made?
Choose Data > Queries & Connections, then double-click the query or right-click it and choose Edit. This opens the query in Power Query Editor.

Is Power Query the same as a PivotTable?
No. Power Query is used to connect to data and transform it. A PivotTable summarizes data for analysis. You can load a query’s output to a worksheet and then use that result as the source for a PivotTable.

Can I use Power Query on a Mac?
Excel for Mac includes Power Query features, but the editor, connectors, and commands can differ by version and update. Check the Data tab and keep Excel updated; some Windows instructions may not apply exactly.

Do I need a source file to open Power Query?
No. If the direct launch command is available, you can open the editor without first selecting a file. To build a useful query, however, you will need a data source, such as a workbook, table, text file, or supported connection.

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.