In modern Excel, Power Query is built in, so Microsoft 365 users generally do not need to install a separate add-in. Find it on the Data tab under Get Data (Power Query) or Get & Transform Data; the separate Power Query add-in was for older Windows versions of Excel.
What the Excel Power Query add-in is
Power Query is Excel’s tool for connecting to data, reshaping it, and loading the result into a worksheet or the Data Model. It is designed for repeatable data preparation: instead of manually copying, deleting, splitting, and rearranging information each time a source changes, you create a query that records those steps. When you refresh the query, Excel runs the steps again on the latest available source data.
The name “add-in” reflects how Power Query was originally delivered for Excel 2010 and Excel 2013 on Windows. It was a separate download that added query commands and an editor to Excel. Starting with Excel 2016 for Windows, Power Query became part of the product and was presented as Get & Transform. In current Microsoft 365 Excel, the same core feature is integrated into the Data tab; it is not normally a checkbox you must enable in Excel’s Add-ins dialog.
Power Query is useful for recurring work such as combining monthly files, cleaning exported reports, joining tables from different sources, or changing a column’s data type consistently. It does not replace formulas or pivot tables: it prepares and imports data, while those tools can be used afterward to analyze it.
Where to find it in different Excel versions
In Excel for Microsoft 365 on Windows, open the Data tab. Look for Get Data or the Get & Transform Data group. The exact labels and layout can vary with the ribbon configuration and update channel, but commands for importing files and opening the Power Query Editor are there. Excel 2016 and later desktop editions for Windows also include Power Query as a built-in data feature, although available connectors can vary by edition and update level.
- Microsoft 365 and newer Windows desktop Excel: Use the Data tab’s Get Data or Get & Transform commands. A separate add-in is not normally required.
- Excel 2010 or Excel 2013 for Windows: Power Query was supplied as a separate Microsoft add-in. A legacy installation must match the 32-bit or 64-bit architecture of Office. Consult Microsoft’s support or download information for that older product rather than installing an unrelated third-party add-in.
- Excel for Mac: Microsoft 365 for Mac includes Power Query features, but connector availability and some authoring or refresh capabilities differ from Windows. Use the Data tab’s Get Data (Power Query) commands when available, and check your Excel update level if a connector or action is missing.
- Excel for the web: Power Query features are available in some Microsoft 365 environments, but the web experience is not identical to the Windows desktop editor. Source, editing, and refresh support can be limited, so use desktop Excel when a query depends on an unsupported connector or advanced operation.
How to create a query in Microsoft 365 for Windows
For a common file import, start with the source file and choose whether to load it directly or inspect and transform it first. For example, to import a CSV file, use Data > Get Data > From File > From Text/CSV. Excel may also show a direct From Text/CSV button on the Data tab. To connect to another Excel workbook, use Data > Get Data > From File > From Excel Workbook.
- Browse to the source file and select it. In the preview window, check that the delimiter, headers, and sample values look right.
- Choose Transform Data to open the Power Query Editor. Choose Load when the preview already has the layout you need and you want to bring it into Excel.
- In the editor, select a column to change its type, remove unwanted rows or columns, filter records, or split a column. The ribbon and column context menus provide common transformations.
- When the preview is ready, choose Home > Close & Load. Use the load options when you need to choose a worksheet destination or load the result to the Data Model instead of a visible table.
Power Query records transformations as query steps, visible in the Applied Steps pane. A step such as filtering out blank rows is not a one-time edit to the source file; it is an instruction that Power Query reapplies during refresh. You can select a step to inspect it, change its settings, or remove it. More advanced users can inspect or edit the query’s M language in the Advanced Editor, but most routine cleaning can be done through the interface.
A practical example: combine monthly sales files
Imagine a folder containing one CSV export for each month. Each file has the same column headings—Date, Region, Product, and Sales—but the number of rows changes monthly. Instead of copying the rows into a master sheet by hand, create a folder query with Data > Get Data > From File > From Folder, select the folder, and choose to combine the files. In the combine preview, confirm that Power Query is using the correct sheet or table and that the column names and types are consistent.
You can then filter out blank records, set Date to a date type and Sales to a numeric type, and remove columns that are not needed. Load the combined result as an Excel table. When a new monthly file with the same structure is placed in the folder, refresh the query to include it. This works best when files follow a consistent naming and layout convention. A renamed column or an extra header row in just one file can cause errors or unexpected results, so check the preview after changing the source pattern.
The original CSV files remain separate source files; Power Query does not turn them into one editable source workbook. The loaded table is an output of the query. If you type corrections directly into that output, a refresh can replace or rearrange the results, so make durable corrections in the source data or add a deliberate step or separate table for them.
Refresh, load options, and what happens to your data
Creating a query does not usually make its output update continuously. Refresh it when you need current data by selecting a cell in the loaded query table and using Data > Refresh All, or right-clicking the table and choosing Refresh. You can also open Data > Queries & Connections to review queries and their connection information. Depending on the connection and Excel version, query properties can offer refresh behavior such as refreshing when the workbook opens.
A query can load results to a worksheet table, load to the Data Model for use with supported analysis tools, or be set to connection only. Connection-only queries are useful as intermediate steps—for example, one query can clean a customer list and another can merge it with orders without displaying every intermediate result on a sheet. A worksheet has a limit of 1,048,576 rows, so very large results may need a different destination or a smaller, filtered query.
Refresh reruns the query against the source it can access; it does not guarantee that the source itself is current. A local file must still be present at its expected path, and a network or online source must be reachable and authorized. If you move a workbook or share it with someone else, the source path and their access permissions may need attention.
Power Query compared with formulas and other Excel tools
Use Power Query when the main task is importing, cleaning, combining, or reshaping data in a repeatable way. Use worksheet formulas when results need to respond immediately to edits in cells, or when the calculation belongs alongside the data. Use PivotTables to summarize or explore a prepared dataset. These approaches can work together: Power Query can standardize incoming reports, then a PivotTable can summarize the loaded table.
Power Query is also different from Power Pivot. Power Query handles data acquisition and transformation; Power Pivot is associated with the Excel Data Model and measures used for analysis. They can form parts of one workflow, but they are not the same add-in or feature. Likewise, ordinary Excel tables do not automatically acquire a connection to external data just because their contents look like an imported report.
For a one-off, small cleanup, direct editing may be quicker. For a recurring report, the initial time spent building a query can prevent repeated manual work and make the preparation steps easier to review. A query is not automatically the best answer for every source, however: a data connection may have licensing, authentication, firewall, or connector limitations, and complex transformations can require maintenance when source formats change.
Common problems and how to troubleshoot them
If Power Query appears to be missing, first confirm which Excel application and version you are using. On modern Windows Excel, look across the Data tab for Get Data or Get & Transform; a simplified ribbon may hide some commands. Check that the ribbon has not been customized and install available Office updates. The old Power Query add-in is relevant to Excel 2010 or 2013, not normally to Microsoft 365.
- A refresh says the file cannot be found: Check the source path, filename, and whether a shared drive or cloud location is available. If the workbook moved, edit the source step or reconnect to the correct file.
- Credentials are rejected: Confirm that the account has access to the source. Excel’s data-source settings may retain permissions or sign-in choices; clear or update the relevant permission only when you understand which connection it affects.
- Columns show errors or unexpected values: Inspect the affected rows and the Applied Steps pane. A type-conversion step may fail if a new file contains text where earlier files contained numbers, or if dates use a different regional format.
- The query returns fewer records than expected: Review filters and the combine-files sample. A filter can exclude valid rows, and files with different sheet names or headings may not match the sample structure.
- Data does not update after changing the source: Run Refresh All and check that the query points to the edited file or correct folder. Refreshing a query does not necessarily refresh every external source unless the relevant connection is included and available.
Privacy and safe use
Before connecting to a source, consider what the workbook will reveal and who can access the source. A workbook can contain query definitions, source paths, and cached results; sharing it may expose data even if the original database or file is not attached. Use only accounts and sources you are authorized to access, and follow your organization’s rules for confidential or personal information.
Power Query’s privacy-level settings help govern how data from different sources can be combined. Do not lower or bypass privacy protections simply to remove a warning unless you understand the consequences and your organization permits it. Also remember that an imported result can become stale: label reports with an appropriate refresh date or communicate when the data was last refreshed if readers might mistake it for live information.
Frequently Asked Questions
Is Power Query free in Excel?
Power Query is included with many desktop editions of Excel, including Microsoft 365 Excel, rather than sold as a separate modern add-in. What you can connect to can depend on your Excel edition, update level, account, and source service.
Do I need to enable Power Query in Excel for Microsoft 365?
Usually not. In Windows desktop Excel, open the Data tab and look for Get Data or Get & Transform. If those commands are absent, check the Excel version, ribbon customization, and Office updates before looking for the legacy Excel 2010/2013 add-in.
Can Power Query update automatically?
It can be configured to refresh under certain conditions, such as when a workbook opens, where the connection and Excel version support that option. Otherwise, refresh it manually with Data > Refresh All. It is not a live feed that updates every cell immediately when a source changes.
Does Power Query change my original file?
No. It reads from a source and applies transformations to the query result. The output loaded into Excel is separate from the original file, although changes made manually to the output can be lost or displaced when the query refreshes.
Can I use the old Power Query add-in on a Mac?
The separate add-in was for Excel 2010 and Excel 2013 on Windows, not Mac. Current Excel for Microsoft 365 for Mac has built-in Power Query capabilities, but its connectors and feature set are not identical to Windows.
Related
- Philippine Wedding Budget Spreadsheet: Build a Budget
- How to Self-Record a Presentation in PowerPoint
- How to Run a PowerPoint Slideshow on a Loop Automatically
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Time Duration Format: Display Hours Beyond 24To show an elapsed time in Excel without resetting the hours after 24, apply the custom number format…
- How to Double Space in Word for Text or Full DocumentTo double-space text in Microsoft Word, select the text, then choose Home > Line and Paragraph Spacing >…
- Convert Japanese to English in Excel: A Step-by-Step GuideTo convert Japanese text to English in Excel for Microsoft 365, enter =TRANSLATE(A2,"ja","en") in a blank cell if…
- How to Delete a Page in Word UK: A Practical GuideTo delete a page in Word, remove the text, paragraph marks or break creating it; Word does not…
- Excel for Literature Analysis: What It Can and Can’t DoYes—Microsoft Excel can help organize literary evidence, code passages, compare recurring themes, and visualize patterns across a text…
- Excel Keyboard Shortcuts for Changing TabsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Up to move to the previous worksheet tab, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.