Home > Software design >  importxml from xml result google sheets
importxml from xml result google sheets

Time:03-20

i'm trying to retrieve travel distance and travel time from this XML URL :enter image description here

  • For example, when you want to retrieve the values to the columns, please use TRANSPOSE like =TRANSPOSE(IMPORTXML(A1,"//*[local-name()='TravelDistance' or local-name()='TravelDuration']")).
  • Related