Dominic Lessard
Dominic Lessard

Reputation: 1

Trying to fetch data in a webpage with Google ImportXML

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?

Code Image

Upvotes: 0

Views: 34

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15318

Try

=index(importxml(url,"//div[@class='col-xs-6']//h4"),9,1)

or

=index(importxml(A1,"//h4"),13,1)

Upvotes: 1

Related Questions