Excel for Office 365
Excel 2019
Excel 2016
Excel 2013
Excel 2010

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.

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

Got It



Please enter your comment!
Please enter your name here

Comment moderation is enabled. Your comment may take some time to appear.