
Extract time and distance from google directions api for list of postcodes in Excel
- or -
Post a project like this4488
$$
- Posted:
- Proposals: 6
- Remote
- #224571
- Awarded
AWS Certified, Azure Certified, Cloud Solutions Architect, Cloud Solutions, Cloud Infrastructure & Security, Information Security, Compliance & Governance, Digital Transformation

⭐ ⭐ ⭐ ⭐ ⭐ Top Rated in Plymouth UK, 17+ Years Professional Experience, A+ Communications

111505109321410888103209274263415686





Description
Experience Level: Intermediate
Required ASAP
Hi,
I want to be able to take a travel route, shown as a list of UK postcodes in excel, and then get the travel time (seconds or minutes) and distance (miles) between each postcode on the route and save this information in the same excel spreadsheet.
An idea would be that I start with a spreadsheet with name, address and postcodes in running order (columns A:C) then time between locations in column D and distance/miles between locations in column E using a macro and google api. Plus a map displayed that I can print/save. See example attached.
Quotes and alternative ideas welcomed.
Regards
Hi,
I want to be able to take a travel route, shown as a list of UK postcodes in excel, and then get the travel time (seconds or minutes) and distance (miles) between each postcode on the route and save this information in the same excel spreadsheet.
An idea would be that I start with a spreadsheet with name, address and postcodes in running order (columns A:C) then time between locations in column D and distance/miles between locations in column E using a macro and google api. Plus a map displayed that I can print/save. See example attached.
Quotes and alternative ideas welcomed.
Regards

Samir P.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
28 Oct 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies