
Alternatively, values are displayed in miles and kilometres if a user zooms out to view a greater-sized region of the map. Specify the origin, the destination, the travel mode (walking or driving) and the function will return the distance between the two points in miles. Google Map's Measuring Tool can be used to measure the distance between two points and the result is displayed in feet and metres. Next, tap the white Dropped Pin box at the bottom of the screen. Tap and hold the starting point where you want the distance measurement to begin.
GOOGLE MAPS MEASURE DISTANCE CODE
Get the address from the zip code itself. Open up the Google Maps app, and then find the location you want to measure.Print driving directions between any points on earth.Use reverse geocoding to find the postal address from GPS co-ordinates.Get the latitude and longitude co-ordinates of any address on Google Maps.Calculate the travel time (walking, driving or biking) between two points.Calculate distances between two cities or any addresses.

This tutorial explains how you can easily write custom Google Maps functions inside Google Sheets that will help you: If you would like to try the Google Maps formulas without getting into the technical details, just make a copy of this Google Sheet and you are all set. Or modify the formula slightly =GOOGLEMAPS_TIME(A1, B1, "walking") to know how long it will take for a person to walk from one point to another. Then draw a route by clicking on the starting point, followed by all the subsequent points you want to measure.

To give you a quick example, if you have the starting address in column A and the destination address in column B, a formula like =GOOGLEMAPS_DISTANCE(A1, B1, "driving") will quickly calculate the distance between the two points. First zoom in, or enter the address of your starting point. You don’t need to sign-up for the Google Maps API and all results from Google Maps are cached in the sheet so you are unlikely to hit any quota limits. You can bring the power of Google Maps to your Google Sheets using simple formulas with no coding. Use Google Maps formulas inside Google Sheets to calculate distances, travel time, get driving directions, look up postal codes with reverse geocoding and more!
