Importing data is easy with the help of the Get & Transform Data section of the Data tab in Excel. Power Query is a widely used ETL(Extract, Transform, Load) tool.

Let’s move forward and understand the concept of Power Query. It is a built-in tool starting with Excel 2016 and is available in the Get & Transforms Data Section under Data Tab. Power Query will then be downloaded on your system. On clicking the Download button, a dialog box opens where you can choose the appropriate download option that suits your OS. Power Query is available as a free add-in on Excel 20, which you can download from Microsoft's website. Needless to say, it is a very useful tool. We can also group and summarize data with the help of the tool. This is called the merging of the data sets. Power Query has several useful features embedded in it, such as the appending of data and creating relationships between different data sets. The data can then be cleaned and prepared for our requirements.

Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks, to list a few. What is Power Query?Īs the name suggests, Power Query is the most powerful data automation tool found in Excel 2010 and later. Since it is very similar to the Excel interface, many users will find it comfortable. The Power Query interface is user-friendly. The Power Query tool makes it a whole lot easier to perform such tasks.Īn added benefit here is that Power Query is easy to use when compared to other BI tools. A lot of precious time is usually spent on repetitive manual work such as cut & paste tasks or combining columns and applying filters. Power Query makes solving common data tasks easy.

Excel for mac new query