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.
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 moreIf you’re using Excel 2010/2013, download the Microsoft Power Query add-in to get started.
Download
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.
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.