Spreadsheet functions to query route planner for travel time/distance
- by Rich
I would like to achieve something whereby I have a spreadsheet such that the columns are:
Column A - place name
Column B - place name
Column C - distance by road between places in columns A and B
Column D - travel time by road between places in columns A and B
I thought it might be possible using Google Docs' spreadsheet and its 'Google' functions, but I've not found any that might do the trick.
In the end I could knock up an app to do it using the Google Maps API but would rather avoid it if I can.