Where is Get & Transform (Power Query)

What versions of Excel include the Get & Transform (Power Query) experience?

Excel 2016

The Get & Transform (Power Query) experience is available in all Excel 2016 plans on the Data tab under the Get & Transform section. It is available with basic and advanced features depending on your version.

Basic business analytics features

  • Available with any Office 365 subscription or Office 2016.

  • Import data from private files, databases and websites:

    • CSV & Text, Table/Range, Excel workbook, XML, JSON, Folder, Access, SQL Server, Web, OData feed, Analysis Services, Facebook, ODBC, OLEDB, and Microsoft Query.

Advanced business analytics features

  • Available with Office 365 ProPlus, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone.

  • In addition to basic business analytics features, you can also import data from corporate, big-data, and cloud data sources.

    • Databases:

      • Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, and SAP Hana.

    • Azure:

      • Azure SQL Server, Azure SQL Data Warehouse, Azure HDInsight (HDFS), Azure Blob Storage, Azure Table, and Azure Data Lake Store.

    • Other sources:

      • SharePoint, Active Directory, Hadoop, Exchange, Dynamics CRM, and Salesforce.

    • Data Catalog:

      • Data Catalog Search

      • My Data Catalog Queries

Excel 2010 and Excel 2013

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 2011 and Excel 2016 for Mac

Get & Transform (Power Query) is not supported on the Mac.

Excel for Android, iOS and Online

Get & Transform (Power Query) is not supported on these platforms.

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

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×