title: Get the distance between two Addresses in google sheets with mode transit
body: <p>I am trying to get the distance between A an B with the mode transit.</p>
  
  <p>This is my code on google sheets(excel)</p>
  
  <pre><code>=importXML("http://maps.googleapis.com/maps/api/directions/json?origin="&amp; A4  &amp; "&amp;destinations=" &amp; D4 &amp; "&amp;mode=transit&amp;arrival_time=1391374800&amp;key=MYKEYHERE"; "//distance/text")
  </code></pre>
  
  <p>It says the the "Url can not be called".
  Im sitting on this problem for some time and i would appreciate any help.</p>
  
  <p>Other then importing XML and in the code it says <code>/json?origin</code> I don't really understand the problem. </p>
  
  <p>EDIT: I found this in the Doc</p>
  
  <pre><code>&lt;travel_mode&gt;TRANSIT&lt;/travel_mode&gt;
      &lt;start_location&gt;
       &lt;lat&gt;40.7563670&lt;/lat&gt;
       &lt;lng&gt;-73.9907530&lt;/lng&gt;
      &lt;/start_location&gt;
      &lt;end_location&gt;
       &lt;lat&gt;40.8179080&lt;/lat&gt;
       &lt;lng&gt;-74.0656630&lt;/lng&gt;
  </code></pre>
  
  <p>But im not sure how to input it in the line above.
  I do the all the long and lat for the destination and origin. </p>