ImportXML geocode

2 posts / 0 new
Last post
ImportXML geocode

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


a formula like this 


=ImportXML(" ADDRESS ", "//place[1]/@lat")


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.