Get Extrenal Data

[Deleted]

Hello, I am in the middle of a lesson on Import External Data 2016, but I have Excel 2013 and cannot locate New Query or Get Data. How do I do this in 2013? Thanks for your help.

[#2]

Hi Dina,

To locate the importing data tools, go to the Ribbon and select Data, from the left-hand side of the Data tab, you will find the importing data tools collected in a group called (Get External Data).

I hope this helps you

[#3]

For Excel 2013 Power Query add-in is to be installed https://www.microsoft.com/en-us/download/details.aspx?id=39379

In ribbon Power Query group will appear