Microsoft Power Query for Excel

Microsoft Power Query for Excel (formerly known as Microsoft "Data Explorer" Preview for Excel) is a software solution that was designed to provide computer users with a seamless experience for discovering data and transforming it for BI professionals, Information Workers and other users as well.

Microsoft Power Query for Excel is capable of identifying the data you care about from the sources you work with such as relational databases, Excel, text and XML files, OData feeds, web pages or Hadoop HDFS. More so, using this app you'll be able to discover various relevant data bits by making use of the search capabilities within Excel.

Combining data from multiple, disparate data sources and shaping it in order to prepare the data for further analysis in tools like Excel and PowerPivot is also possible when using this software solution.

It comes in two flavors, 32- and 64-bit, so you can choose whatever version suits your needs the best by downloading the package you want and deploying it on the target computer. The installation process is highly uncomplicated, as you're only required to follow the on-screen instructions provided by the wizard. The rest of the process is carried out without any additional assistance on your side.