The integration of Get & Transform Data (now called Power Query),into Excel has gone through a number of changes over the years.
Excel 2010 and 2013 for Windows
In Excel 2010 for Windows, we first introduced Power Query and it was available as a free add-in that could be downloaded from here:Download the Power Query add-in.Once enabled, Power Query functionality was available from the Power Query tab on the ribbon.
Microsoft 365
Weupdated Power Query to be theprimary experience in Excel for importing and cleaning data. You can access the Power Query data import wizards and tools from the Get & Transform Data group on the Data tab of the Excel ribbon.
This experience included enhanced data import functionality, rearranged commands on the Data tab, anew Queries & Connection side pane,and the continuing ability to shape data in powerful ways by sorting, changing data types, splitting columns, aggregating the data, and so on.
This new experience also replacedthe older, legacy data import wizards under the Data command in theGet External Data group. However, they can still be accessed from the Excel Options dialog box (SelectFile>Options>Data>Show legacy data import wizards).
Excel 2016 and 2019 for Windows
We added the same Get & Transform Data experience based on the Power Query technology as that of Microsoft 365.
Excel for Microsoft 365 for Mac
In 2019 we started the journey to support Power Query in Excel for Mac. Since then, we added the ability to refresh Power Query queries from TXT, CSV, XLSX, JSON and XML files. We have also added the ability to refresh data from SQL server and from tables & ranges in the current workbook.
In October of 2019,we added the ability torefresh existing Power Query queries and to use VBA to create and edit new queries.
In January of 2021,we added support for the refresh of Power Query queries fromOData and SharePoint sources.
For more information, seeUse Power Query in Excel for Mac.
Note There is no support for Power Query on Excel 2016 and Excel 2019 for Mac.
Data Catalog deprecation
With the Data Catalog, you could view your shared queries, and then select them to load, edit, or otherwise use in the current workbook. This feature was gradually deprecated:
-
On August 1st, 2018, we stopped onboarding new customersto the Data Catalog.
-
On December 3rd, 2018, users couldn't sharenew or updated queries in the Data Catalog.
-
On March 4th, 2019,the Data Catalog stopped working. After this date, we recommended downloading your shared queries so you could continue using them outside the Data Catalog, by using the Open option from the My Data Catalog Queries task pane.
Power Query add-in deprecation
Early in the summer of 2019, we officially deprecated the Power Query add-in which is required for Excel 2010 and 2013 for Windows. As a courtesy, you may still use the add-in, but this may change at a later date.
Facebook data connector retired
Import and refresh of data from Facebook in Excel stopped working in April, 2020. Any Facebook connections created before that date no longer work. We recommend revising or removing any existing Power Query queries that use the Facebook connector as soon as possible to avoid unexpected results.
Excel for Windows critical updates
From June 2023, Power Query in Excel for Windows requires the following components:
-
Power Query in Excel for Windows uses the .NET framework, but it requires version 4.7.2 or later. For more information, see Update the .NET Framework.
-
Power Query in Excel for Windows requires WebView2 Runtime to continue supporting the data Web connector (Get Data from Web). For more information, see Download the WebView2 Runtime.