Excel Power Query: Open It, Import Data, and Refresh

In Excel for Microsoft 365 on Windows, open the Data tab and choose Get Data > Launch Power Query Editor, if that command appears. You can also open the editor by choosing a data source, such as Data > From Text/CSV, or by editing an existing query in the Queries & Connections pane.

Where Power Query is in Excel

Power Query is Excel’s built-in tool for connecting to data, cleaning and reshaping it, and loading the result into a worksheet or the workbook’s data model. In current Windows versions of Excel for Microsoft 365, its main controls are on the Data tab, in the Get & Transform Data area. Depending on the ribbon layout, the controls may be grouped under a Get Data button.

There is not usually a separate Power Query application to launch. The editor is a window within Excel, and it appears when you create or edit a query. A query is the set of connection details and transformation steps Excel uses to produce a result. You can save those steps in the workbook and refresh the result later.

If you do not see the same labels, check whether the ribbon is simplified or the Excel window is narrow; some commands may be tucked into a menu. You can also use Excel’s command search to look for Get Data or query-related commands. The available options can vary with Excel version, update channel, account, and organization settings.

Three ways to open the editor

Choose the route that matches what you want to do. To bring in a new file or database, begin with its source command. To work on a query that is already in the workbook, use the query list.

Launch the editor directly: Select Data > Get Data > Launch Power Query Editor if this command is available in your Excel build. This opens the editor without requiring you to choose a new source first.
Start from a source: Choose a command such as Data > From Text/CSV, Data > From Web, or Data > From Table/Range. Excel connects to or reads the selected source, then opens a preview in Power Query Editor so you can inspect and transform it.
Edit an existing query: Choose Data > Queries & Connections to open the pane. On the Queries tab, double-click a query, or right-click it and choose Edit. The editor opens with that query’s existing steps.

The exact source commands depend on what Excel supports on your device and what connectors are enabled. For example, From Table/Range is useful for data already in the workbook, while From Text/CSV is intended for a delimited or text file.

Open a worksheet range in Power Query

For a quick first query, put the source data in a clean rectangular range with one header row and no completely blank rows or columns inside the data. Click a cell in the range, then select Data > From Table/Range. If Excel asks whether to create a table, confirm the range and indicate whether the first row contains headers.

Power Query Editor opens with a preview. For instance, a sales table might contain OrderDate, Region, Product, and Amount columns. You could set OrderDate to a date type, filter out blank Product values, remove columns that are not needed, or group the records by Region. The original source table remains in the worksheet; the query creates a transformed result rather than silently changing the source cells.

When you finish, use Home > Close & Load to load the output with the default destination. To select where it goes, use Home > Close & Load > Close & Load To, then choose an available destination, such as a worksheet table or a connection. The precise choices depend on the query and workbook.

What happens inside Power Query Editor

The editor separates the data preview from the recorded transformation steps. Selecting a column or using a ribbon command can create a step, such as changing a data type, filtering rows, splitting a column, or removing duplicates. The Applied Steps list shows the operations in sequence. Selecting an earlier step lets you inspect the data at that point; deleting or changing a step can affect later steps.

Power Query often records the underlying operations in the M language, but most everyday tasks can be done through the interface. This is different from writing a worksheet formula: a formula generally calculates in a cell, while a query transforms a data source when it is loaded or refreshed. A transformation does not necessarily change the source file or the original worksheet data.

Data types matter. A column containing dates should generally be recognized as a date, and amounts should generally be numeric or currency values rather than text. A type mismatch can cause errors or unexpected sorting—for example, text values that look like numbers may sort alphabetically. Check the type icon beside each column name and use the editor’s data-type controls when necessary.

Loading a query or keeping it as a connection

A query does not have to place its full result in a worksheet. In the load options, a connection-only query keeps the connection and transformation steps in the workbook without creating a visible output table. This can be useful when one query prepares data for another, or when the result will be used in the data model. A worksheet table is easier to inspect directly, but very large outputs may be more practical to use through a connection or the data model.

Before loading, consider the size and purpose of the result. A query that returns a few hundred summarized rows may be a good worksheet table. A query that returns a large detailed dataset could make a workbook slower or harder to navigate if loaded to a sheet. You can change a query’s load destination later through the query’s load options, though the available options depend on the workbook and Excel build.

Refreshing data after opening Power Query

After a query has been loaded, Excel can run its saved steps again against the source. To refresh an individual query, right-click its output table or its entry in Data > Queries & Connections and choose Refresh. To refresh workbook connections together, use Data > Refresh All. Refreshing updates query results; it does not mean that the editor is open.

Refresh behavior depends on the source. A local file may need to remain at the expected path, while a database or online source may require a working network connection and valid credentials. If the source file has been moved or renamed, update the query’s source settings rather than expecting refresh to find it automatically. Excel may also ask you to sign in again or choose how to handle privacy levels when combining sources.

Refresh settings can be adjusted for a connection, but do not assume every query refreshes automatically just because its workbook is open. Check the connection or query properties if you need a particular refresh schedule or behavior, and consider how a refresh could affect formulas or reports that depend on the loaded table.

Common reasons Power Query will not open

The command is not visible: Expand the ribbon or inspect the Get Data menu. The editor launch command is not shown in every version or layout; starting with a source command or opening a saved query can still open the editor.
The file type is unsupported or unavailable: Connector availability differs across Excel versions and platforms. Try a supported source route, such as importing a text file, or check whether your organization manages connector access.
A query is missing from the pane: Open Data > Queries & Connections and inspect the Queries tab. If the workbook contains no saved queries, there may be nothing to edit yet; create one from a source first.
Excel displays a privacy, credential, or access prompt: Follow the prompt only if you recognize the source and are authorized to access it. Sign-in requirements and privacy settings can prevent a query from previewing or refreshing even when the editor itself opens.
The preview is blank or reports an error: Confirm that the source is reachable and that the selected sheet, table, or file still exists. For a worksheet range, check that the range has headers and that the source has not been replaced with a different layout.

If Excel becomes unresponsive, allow a large preview or refresh time to finish before closing the workbook. For recurring failures, note the exact error text, the source type, and whether the problem occurs while opening, previewing, or refreshing. Those details help distinguish a connector issue from a changed file path, credentials, or malformed source data.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. Power Query is also available in some Excel for Mac editions, but its connectors and authoring capabilities do not necessarily match Windows. Look on the Mac Data tab for Get Data (Power Query) and use the source types displayed there; a Windows instruction may refer to a connector that is not available on Mac. Keyboard shortcuts are not needed for these menu steps, and ribbon names can vary between versions.

Excel for the web has been gaining query capabilities, but availability depends on the account, service rollout, source, and organization settings. If you need to create or edit a query and the web interface does not expose the needed controls, open the workbook in the desktop Excel application. A workbook can still contain queries created elsewhere even when the web version cannot perform every authoring task.

Power Query compared with formulas and ordinary imports

Use Power Query when the same cleanup needs to be repeated or when data comes from multiple files or external sources. For example, a monthly report could combine files with the same columns, remove empty rows, standardize headings, and load a consistent table. The saved steps make the process repeatable: replace or update the source, then refresh.

Formulas are often better for calculations that need to respond immediately to edits in worksheet cells, such as a total or a lookup next to the data. A one-time copy-and-paste import may be enough for a small dataset that will not be updated. Power Query is not a substitute for every formula or database operation; it is most useful when a repeatable import-and-transform workflow saves manual cleanup.

Frequently Asked Questions

Is Power Query already included in Excel?
In current Excel for Microsoft 365 for Windows, Power Query is built into the Data tab; it is not normally a separate add-in that must be installed. Older Excel releases and other platforms may present different features or menus.

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

Does opening Power Query change my original data?
No. Editing a query changes its instructions and its output, not the source data itself. If the query loads results to a worksheet, it creates or updates a result table; changes made directly to that output may be replaced when the query refreshes.

Can I open Power Query without importing a file?
Often, yes: use Data > Get Data > Launch Power Query Editor if your Windows build shows that command. Otherwise, start with a source command or edit an existing query to open the editor.

Why can I see a query but not edit it?
The workbook may be open in a version or platform with limited query-authoring support, or the source and connection may be restricted. Try opening a copy in Excel for Microsoft 365 on Windows and check whether the workbook is protected or managed by your organization.

Is Power Query the same as Power Pivot?
No. Power Query connects to and transforms data. Power Pivot is associated with working with the Excel data model, including relationships and calculations. They can be used together, but they serve different roles.

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.