import data from website to excel 2016

Copper Contributor

How to import data from web?

I want to get data from https://www.privateschoolreview.com/new-york/brooklyn/elementary 

Name and address , phone numbers

but I dont know how. 

Below it's what I got when I copy the link to From Web.

Then I get second picture's information, obviously, that's not what I want, but I dont know how to convert it to real data.

Could someone help me out? Thank YOU!

 

微信图片_20180520222217.png微信图片_20180520222613.png

1 Reply

Hi 

The data is not laid out well for this.  I

tried but failed.

You have to  click on Document and then edit in the first screen and then start drilling down, but the data is inconsistent.

 

Hopefully there will be a new web connector coming to Excel soon that will help with this exact scenario  (it was added to Power BI this month).   But until then this isn't possible (I don't think).

 

image.png