Hello,
I have a JSON URL "https://maps.googleapis.com/maps/api/distancematrix/json?origins=Aurora+CO&destinations=Willis+TX&mode=driving&language=en_US" That Results Like
I am trying to get the Distance Text into a Cell? How can i do that in Excel?
Thank You for all of your help!
I have a JSON URL "https://maps.googleapis.com/maps/api/distancematrix/json?origins=Aurora+CO&destinations=Willis+TX&mode=driving&language=en_US" That Results Like
Code:
{ "destination_addresses" : [ "Willis, TX, USA" ], "origin_addresses" : [ "Aurora, CO, USA" ], "rows" : [ { "elements" : [ { "distance" : { "text" : "1,577 km", "value" : 1577246 }, "duration" : { "text" : "14 hours 22 mins", "value" : 51716 }, "status" : "OK" } ] } ], "status" : "OK"}
I am trying to get the Distance Text into a Cell? How can i do that in Excel?
Thank You for all of your help!