
Thanks to the notorious updates and development, Google maps offer new options to discover our world in the comfort of our armchairs. You may use it as a satellite imagery tool ( satellite map – the Earth’s surface recorded from the view of a satellite and compiled into a searchable, scrollable, zoomable map), as a street view tool, a simple but very comprehensive place or address search application, or a GPS coordinate reverse search utility.Īre you planning to reach a destination in a possibly traffic-hit area? Here is a free, live traffic information map by Google for your service to easily beat traffic jams. Since Google purchased those maps in 2004, digitalized them, and continuously updated them in more than 220 countries worldwide, it probably became one of the most popular online travel assistant tools on the internet.ĭon’t forget that the Google map below is more than just an address search utility. 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 maps are free and one of the most useful tools you may use while traveling or just cruising around your city and looking for a particular site or point of interest.


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.

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. 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!
