Connect Excel to Windows Azure HDInsight with Power Query
Power Query can be used to import data from a variety of sources into Microsoft Excel, where it can be used to power Business Intelligence (BI) tools like PowerPivot and PowerView. In particular, Power
Query can import data that has been output or that has been generated by a Hadoop job running on an HDInsight cluster.
The Power Query add-in for Excel makes it easy to import data from your HDInsight Service cluster into Excel where Business Intelligence tools such as Power Pivot and Power Map may be used to inspect, analyze, and present the data.
To get an insight of how to connect follow the link