I have a list of coordinates in Google Sheets (around 20). I'd like to input a location and receive current travel times to each coordinate, for the different transport modes.

Is this possible from Google Sheets? In other words, can I make a travel distance query to Google Maps from Sheets, and if so, how?

  • 1
    Still need to do this? I doubt you can do it directly, but you could download the locations and run a python query to the google travel API, then push the data back to a google sheet. – Spacedman Sep 8 '18 at 11:18

You can probably utilize use Google MyMaps to do this in some capacity. It's at least worth a try. You can upload from Google Drive, as well as csv, xlsx, kml, and gpx files.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.