title: How can I extract the distance from Google Directions API via Excel web query?
body: <p>I have a long list of origins and destinations in Excel, using webquery I can fill in the cities and postal code to give a webquery like:</p>
  
  <p><a href="http://maps.googleapis.com/maps/api/directions/xml?origin=Scoresby&amp;destination=Melborne&amp;sensor=false" rel="nofollow">http://maps.googleapis.com/maps/api/directions/xml?origin=Scoresby&amp;destination=Melborne&amp;sensor=false</a></p>
  
  <p>This returns me a long XML file, but all I need is just the distance. Is there a way to extract only the distance value?</p>
  
  <p>Or should I just run a macro script to extract distance one by one? (Since the format remains roughly the same each time I ask the server)</p>