0

This topic has been brought up a few times - but i've tried every option in google sheets but it keeps returning "Imported Content is empty" on my function

The code im using is below (where G23 & H23 are postcodes)

=importxml("http://maps.googleapis.com/maps/api/directions/xml?origin="&G23&"&destination="&H23&"&sensor=false&alternatives=false&key=MYKEY","//leg/duration/value")

Any ideas?

  • Welcome. One of the issues here is the use of "postcodes" rather than specific locations. You mentioned that the topic had been brought up a few times - please include these references in your question so we avoid duplicated research. Calculate (road travel) distance between postcodes/zipcodes python and Google maps - Postcode plotting are two references that i found, but neither has anything as uncomplicated as an importxml function. Would you please give a reference for that function. – Tedinoz Dec 3 at 2:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.