extract data from scholaro

[stefanoste78]

With power query or macro you can extract data from this site:
https://www.scholaro.com/ed/Countries

I would like to import in a file for each state the following data to be inserted on each sheet with the name of the data type (education system etc.) the following data:
1) the table on the education system and the description below;
2) Credentials;
3) Universities (in this case I would need a list of all the universities in the state with all the indications for each university ranging from the website, address and ranking) to add to the columns "local name" and city, then: web rank (in the three types), General Information, Links, Location, Students and Staff, Tuition, Admissions.
4) resouces (indicating in a table the name and other data as a website, etc.).
Thanks

 

[stefanoste78]

Good afternoon.
I looked for a shorter solution.
By listing the links for each state, could you create the right code that extrapolates the data at each column?

https://www.dropbox.com/s/u4wsz71tq4be0d3/SCHOOLARO.xlsx?dl=0

 

[stefanoste78]

Hello
Is there anyone who could help me with this currently?