May 20 2018 07:29 PM
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!
May 23 2018 05:11 AM
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).