Finding the right tools inside a sprawling application like Microsoft Excel can sometimes feel like searching for a needle in a digital haystack. On the flip side, this powerful data connection and transformation technology—often described as the best thing to happen to Excel in decades—is built directly into modern versions, but its location has shifted over the years. If you have ever asked yourself where is Power Query in Excel, the answer depends heavily on which version of the software you are running. Understanding exactly where to look saves valuable time and unlocks a world of ETL (Extract, Transform, Load) capabilities without leaving the familiar spreadsheet interface Took long enough..
The Short Answer: It Is Already Installed
For the vast majority of users today, there is no need to download an add-in or run a separate installer. Because of that, if you are using Excel 2016, Excel 2019, Excel 2021, or Excel for Microsoft 365 (formerly Office 365), Power Query is natively integrated into the application. It lives permanently on the Data tab of the Ribbon, nestled inside the Get & Transform Data group.
You will see icons labeled Get Data, From File, From Database, From Azure, From Online Services, and From Other Sources. Clicking any of these launches the Power Query Editor window, the dedicated environment where you clean, shape, and merge data before loading it back into your workbook or the Excel Data Model Turns out it matters..
Locating Power Query by Excel Version
Because Microsoft rebranded and relocated the feature during its evolution, the exact visual cues differ slightly depending on your specific build. Here is a breakdown by version so you can identify it instantly.
Excel for Microsoft 365, Excel 2021, and Excel 2019
This is the modern, standard experience.
- Open Excel.
- Click the Data tab on the Ribbon.
- Look at the far left section of the Ribbon labeled Get & Transform Data.
- The primary entry point is the Get Data dropdown button. This is your gateway to the Power Query Editor.
Excel 2016
The integration began here, but the Ribbon group was originally named Get & Transform (without the word "Data") Not complicated — just consistent..
- Go to the Data tab.
- Find the Get & Transform group on the left.
- Click New Query (the terminology was slightly different; "Get Data" became the standard label in later updates). If you have kept your Office 2016 installation updated, it likely now mirrors the "Get & Transform Data" labeling found in newer versions.
Excel 2013 and Excel 2010 (The Add-in Era)
In these older versions, Power Query was not built-in. It existed as a free, separate COM Add-in that users had to download from the Microsoft Download Center.
- After installing the add-in, a brand new tab named POWER QUERY appeared on the Ribbon (distinct from the Data tab).
- This tab contained all the connection buttons: From File, From Database, From Azure, etc.
- Critical Note: Mainstream support for Office 2013 and 2010 has ended. The Power Query add-in is no longer officially distributed or updated by Microsoft. If you are on these versions, upgrading to a supported version of Excel is highly recommended for security and functionality.
Excel for Mac
Historically, Mac users were left out of the Power Query ecosystem. That said, modern Excel for Microsoft 365 on Mac now supports Power Query (often labeled Get & Transform (Power Query)) Which is the point..
- Go to the Data tab.
- Look for the Get Data or Get & Transform Data group.
- Feature parity with Windows has improved significantly, though some advanced connectors (like specific legacy ODBC drivers or on-premise SharePoint folders) may still be limited compared to the Windows desktop client.
Excel on the Web (Excel Online)
Power Query authoring—creating new queries and writing M code—is not available in the browser version. You can refresh existing queries that were built in the desktop app (provided the data source is supported, like a table in the same workbook or a public OData feed), but you cannot launch the Power Query Editor to build new transformations Practical, not theoretical..
What If You Don’t See It? Troubleshooting Missing Ribbon Tabs
If you are on a supported version (2016+) but the Get & Transform Data group is missing from the Data tab, do not panic. Practically speaking, it is almost never "uninstalled" because it is a core DLL of the Excel executable. Here are the most common reasons it disappears and how to fix them.
1. Ribbon Customization Reset
A custom Ribbon import or a UI glitch may have hidden the group And that's really what it comes down to..
- Fix: Right-click anywhere on the Ribbon > Customize the Ribbon. In the right pane, ensure Main Tabs is selected. Expand Data. Check if Get & Transform Data is listed and checked. If it is missing from the list entirely, click Reset > Reset all customizations.
2. Disabled COM Add-ins (Rare but Possible)
While the core engine isn't a COM add-in anymore, the Power Pivot add-in (often used alongside Power Query) is. If Power Pivot is disabled, the Data Model features suffer, though Power Query usually remains visible.
- Fix: File > Options > Add-ins. At the bottom, Manage: COM Add-ins > Go. Ensure Microsoft Power Pivot for Excel is checked.
3. Group Policy or IT Restrictions
In corporate environments, IT administrators can deploy Group Policy Objects (GPOs) that hide specific Ribbon tabs or disable the "Get Data" experience to enforce data governance.
- Fix: Contact your IT Helpdesk. Ask if "Power Query" or "Get & Transform" is restricted via Policy. There is no user-level override for this.
4. You Are in "Protected View" or Opening a Legacy File
If you open a file downloaded from the internet or an .xls (Excel 97-2003) file, Excel opens in Protected View or Compatibility Mode. The Data tab may be greyed out or limited.
- Fix: Click Enable Editing on the yellow banner at the top. Save the file as a modern
.xlsxor.xlsmformat.
Inside the Power Query Editor: What Happens After You Click
Knowing where is Power Query in Excel is only the first step. Once you click Get Data > Launch Power Query Editor (or select a specific source like From Table/Range), a distinct application window opens. This is the Power Query Editor. It looks different from the main Excel grid for a reason: it is a record-and-replay macro recorder for data cleaning Not complicated — just consistent..
Honestly, this part trips people up more than it should.
The Four Key Panes
- Ribbon: Contains transformation commands (Remove Rows, Split Column, Pivot, Unpivot, Group By, Merge Queries, Append Queries).
- Queries Pane (Left): Lists all queries in the workbook. This is your project navigator. You can create folders, duplicate queries, and reference queries here.
- Data Preview (Center): Shows the top 1,000 rows of your data. Column headers have filter dropdowns (like Excel AutoFilter) but clicking them records a step.
- Query Settings Pane (Right):
- Properties: Name your query (crucial for readability
…is crucial for readability when you’re managing multiple queries.) Below Properties sits Applied Steps, a chronological ledger of every transformation you perform—filtering rows, changing data types, unpivoting columns, and so on. Click any step to preview the data exactly as it appeared after that action; right-click a step to delete, rename