Google Maps Distance Sheets. All the above Google Sheets functions internally use the Google Maps API to calculate routes distances and travel time. Tools Script editor and paste this.
First zoom in or enter the address of your starting point. All the above Google Sheets functions internally use the Google Maps API to calculate routes distances and travel time. Overview Also see the Maps JavaScript API Reference.
You can make a copy of the Google Sheet with the data from here.
Using the DirectionFinder class of Google Apps script you get directions between locations from Google Maps. Spreadsheet Mapper is a powerful tool for mapping point locations. You can put the two places in separate cells in a Google Spreadsheet and then use the getDirection function to find the distance between the two place in miles or kilometers. This service does not return detailed route information.