Data Explorer Add-in enhances the self-service BI experience in Excel by simplifying data discovery and access to a broad range of public and enterprise data sources, enabling richer insights from data that has traditionally been difficult for users to get to.
Using this add-in we can get data from a wide variety of data sources like Sql Server, Files, Azure etc and analyze them in Excel. This add-in is really useful one and I found it very useful for many customers.
With Data Explorer, users can now quickly and easily import data from a variety of sources, including Web, Excel, Text, Database and Azure. Access to non-traditional sources such as Active Directory, Facebook and big data solutions like Hadoop are now within the reach of any user.
Connecting directly to data from the web is easy and intuitive. Filtering and transforming your data can be done in just a few clicks and importing your final data into Excel is straightforward. Given this is a preview, these features may appear differently in the future versions.
Here is the link to Download Data Explorer Add-in
Source: Office Blog