Skip to main

Making Excel even more powerful

Power Query lets you analyze your data right from within Excel, while seamlessly connecting to a wide range of external data sources. Easily reshape and transform your data along the way if needed.

Making Excel even more powerful

Power Query lets you analyze your data right from within Excel, while seamlessly connecting to a wide range of external data sources. Easily reshape and transform your data along the way if needed.

Transform Data

Get to know “Get and Transform Data”

To use Power Query, just click the Data tab in Excel 2016 or newer, called “Get and Transform Data”.

Learn more

If you’re using Excel 2010/2013, download the Microsoft Power Query add-in to get started.

Download
Laptop Generic

Out-of-the-box connectivity

Choose from a wide range of data connectors to import the data you need. It’s fast and it’s easy.

Transform, reshape and combine data

Power Query Editor lets you choose from more than 300 no-code transformations to get your data in the right shape quickly—no matter where it comes from. And we’re adding new transformations all the time.

Automate to make it easier

Keeping your data up-to-date couldn’t be easier using Excel’s Visual Basic APIs. Just define your Power Query queries within the program and automate their refresh.

mc-excel-logo-connector

Get started

Get the latest version of Excel now, and see for yourself how much more you can do with your data—right from the Data tab. Thanks to Power Query.