Web scrapping not working

[Revathi kannan]

Hi Everyone,

I want to extract the table which is available from the below website but i am not able to do that with the Get data option from excel.

Is there any other way that I can scrap the live table to my excel ?

https://portal.emsa.europa.eu/web/th...ent-detentions

Thanks.

[mogul]

It isn't formatted as an HTML table. It is a grid layout. It is possible to scrape but it will take some time to understand HTML. I recommend using XPath to extract elements. It is very powerful and can extract almost anything. Google/Bing xpath tutorial youtube