ImportXML geocode

2 posts / 0 new
Last post
Lufabbiu
ImportXML geocode

i need the correct formula for google sheet to import Lat & Lon from address

 

a formula like this 

 

=ImportXML("http://open.mapquestapi.com/...../.../search?format=xml&q= ADDRESS ", "//place[1]/@lat")

 


MQBrianCoakley
I'm not Sheets expert so I
I'm not Sheets expert so I can't help with the formula but I can say that saving results is strictly against the Terms & Conditions unless you have an Extended Rights Geocoding plan.