Reputation: 1
I am trying to fetch the value 44.244815 from this code's web site using Google Sheet but I can't seams to make it work. Anyone would know how to fetch this data and import it?
Upvotes: 0
Views: 34
Reputation: 15318
Try
=index(importxml(url,"//div[@class='col-xs-6']//h4"),9,1)
or
=index(importxml(A1,"//h4"),13,1)
Upvotes: 1