Forum Discussion
import data from website to excel 2016
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...
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).