title: Calculate the geo-coordinates distance between two places in Excel Sheets
body: <p><strong>EDIT: Im using Exchel Online Sheets</strong></p>
  
  <p>This is what i have in a column</p>
  
  <pre><code>=importXML("http://maps.googleapis.com/maps/api/geocode/json?address"&amp;"=A4,A5&amp;key=MYKEYISHERE--9-W1GIAHcQb9O6fm0";"B6,B7")
  </code></pre>
  
  <p>This may be hard to read so let me translate.
  It should take the latitude from A4 and the longitude from A5 and calculate the distance to B6, B7</p>
  
  <p>The first problem that im seeing is that here /<code>geocode/json?</code>it says JSON even tho I'm importing an XML, so I'm not sure how exactly this works, or how to work around it. </p>
  
  <p>Thank you in advance</p>