Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

The following information details which versions of Excel include the Power Query (known as Get & Transform in Excel) experience.

The Power Query experience is available in all Excel 2016 or later Windows stand alone versions and Microsoft 365 subscription plans on the Data tab in the Get & Transform group. The following table shows basic and advanced features available by version.

Connector Name

Office 2016
Home & Student
Home & Business Standard
Professional

Office 2016
Professional Plus
Standalone

Office 2019
Home & Student
Home & Business Standard
Professional

Office 2019
Professional Plus
Standalone

Microsoft 365
Home
Personal
Business
Business Premium

Microsoft 365
Apps for Enterprise

Excel workbook

Included

Included

Included

Included

Included

Included

Text & CSV

Included Included Included Included Included Included

XML

Included Included Included Included Included Included

JSON

Included Included Included Included

PDF (Requires

.Net Framework

4.5 or higher.)

Included

Included

Local folder

Included Included Included Included Included Included

SharePoint Folder

Included

Included

SQL Server

Included Included Included Included Included Included

Microsoft Access

Included

Included

Included

Included

Included

Included

Analysis Services

Included

Included

Included

Included

Included

Included

SQL Server Analysis Services (Import)

Included

Included

Included

Oracle

Included Included Included

IBM Db2

Included Included Included

MySQL

Included Included Included

PostgreSQL

Included Included Included

Sybase

Included Included Included

Teradata

Included Included Included

SAP HANA

Included Included

Azure SQL Database

Included

Included

Included

Azure SQL Data Warehouse

Included

Included

Azure HDInsight (HDFS)

Included

Included

Included

Azure Blob Storage

Included

Included

Included

Azure Table Storage

Included

Included

Included

Azure Data Lake Storage

Included

Included

Azure Data Explorer

Included

SharePoint Online List

Included

Included

Microsoft Exchange Online

Included

Included

Dynamics 365 (online)

Included

Included

Included

Facebook

Included Included Included Included Included Included

Important: Retirement of Facebook data connector notice    Import and refresh data from Facebook in Excel will stop working in April, 2020. You will still be able to use the Facebook Power Query connector until then. But starting in April, 2020, you will be unable to connect to Facebook and you will receive an error message if you try using the Facebook connector. We recommend revising or removing any existing Power Query queries that use the Facebook connector as soon as possible to avoid unexpected results.

Salesforce Objects

Included

Included

Included

Salesforce Reports

Included

Included

Included

Table/Range

​​​​​​​ Included

Included Included Included Included Included

Web

Included Included Included Included Included Included

Microsoft Query

Included

Included

Included

Included

Included

​​​​​​​ Included

SharePoint List

Included Included Included

OData Feed

Included Included Included Included Included Included

Hadoop File (HDFS)

Included

Included

Included

Active Directory

Included

Included

Included

Microsoft Exchange

Included

Included

Included

ODBC

Included Included Included Included Included Included

OLEDB

Included Included Included Included Included Included

Blank Query

Included Included Included Included Included Included

Because it’s a subscription-based version, Microsoft 365, at any one time, contains all the available Power Query features. You can think of it as the master set. Professional Plus Standalone (also called perpetual) versions have a large subset of features, but not all of them. For example, fuzzy merge is supported in Microsoft 365, but not in 2019 perpetual. More features were added to 2019 perpetual than were available in 2016 perpetual, and even more will be added to the next perpetual version called 2021. Given this situation, you have two choices. The first choice is to wait for the next upgrade to a perpetual version if you want a specific feature. This choice might work, but truthfully, it may not. We can’t guarantee that a specific feature will be added to the next perpetual version. The second choice is to subscribe to Microsoft 365. We encourage you to make that choice so that all the Power Query features are available to you. For more information, see Microsoft 365 with Office apps.

Power Query is a free add-in that can be downloaded here: Download the Power Query add-in. although the add-in is no longer officially supported, you can still use it. Once enabled, Power Query functionality is available from the Power Query tab on the Excel ribbon.

The following table summarizes what data sources are supported and what you can do with them.
Note:

  • Refresh for queries loaded to the Data Model is not yet supported.

  • Refresh for queries in workbooks saved in a third-party cloud location is not yet supported.

Data source

Refresh

Table/Range

Included

OData Feed

Included

If you're a Microsoft 365 subscriber, the Power Query experience is available in Excel for the Mac from the Get Data command on the Data tab. The following table summarizes what data sources are supported and what you can do with them. For more information, see Import data in Excel for Mac (Power Query).

Data source

Refresh

Import

Text & CSV

Included Included

Excel workbook

Included Included

XML

Included Included

JSON

Included Included

SharePoint Folder

Included

SQL Server

Included

Table/Range

Included

SharePoint List

Included Included

OData Feed

Included Included

Blank Query

Included Included

Blank Table

Included Included

Power Query is not supported.

Power Query is not supported.

See Also

Power Query for Excel Help

Import data from external data sources

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×