Extract Data From Website 2

hello,
there is a website http://www.populstat.info/.
inside that website there is data regarding cities poplulation.
in order to work on this data I need to extract it to an excel file.

each data of each city in a seperate excel file.

if you look at the website, each country has a link “of some important towns”. so I wish to get the data of that table to excel.
after doing so, I need to arrange the data in 2 sorts:

I’ll give a list of cities which I want their info line by line on an excel. and then I want a list in another tab of all the rest of the cities of that website.
thank you,
shlomo

Leave a Reply

Your email address will not be published. Required fields are marked *