Unable to extracted nested data with ImportXML xpath query

Home > Back-end > Unable to extracted nested data with ImportXML xpath query - google sheets

Unable to extracted nested data with ImportXML xpath query - google sheets

Time：11-01

Hello dear internauts!

I want to extract the country distribution from:

if you want to work with those numbers:

=INDEX(QUERY(IMPORTXML("https://www.etf.com/"&A1, 
 "//div[@class='rowText col-md-12 col-sm-12 col-xs-12']"), 
 "limit 10", 0))