Where is Get & Transform (Power Query)

 The following list details which versions of Excel include the Get & Transform (Power Query) experience.

Excel 2019 and Excel 2016 for Windows

The Get & Transform (Power Query) experience is available in all Excel 2019 and 2016 for Windows plans on the Data tab under the Get & Transform section. 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

Office 365
Home
Personal
Business
Business Premium

Office 365
ProPlus

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 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

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

Excel 2010 and Excel 2013 for Windows

Power Query is a free add-in that can be downloaded here: Download the Power Query add-in. Once enabled, Power Query functionality is available from the Power Query tab on the ribbon.

Excel for Office 365 for Mac

If you're an Office 365 subscriber, and have signed up for the Insiders Program, then you can refresh existing Power Query queries on your Mac for connections to Text, CSV, XLSX, XML and JSON files. The refresh functionality is live for all Office Insiders Fast customers in Excel for Mac, version 16.26 (19052200) and later.

Excel 2011 and Excel 2016 for Mac

Get & Transform (Power Query) is not supported.

Excel for Android, iOS and Online

Get & Transform (Power Query) is not supported.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×