Multi-Route Optimiser with Stop Times

A client required a practical non-expensive route planner/optimizer which would optimise a list of addresses, plus the ability to add stop/service times for each address.

Not much to ask? However I did manage to create one with Google sheets with a combination of formulas and scripts.

It’s not pretty but works pretty well

Route Planner map

Notes:

  • First location is used as “From”, last location is used as “To”, the rest is used as waypoints, which can be optimised.
  • Addresses must match on Google map platform, if your using a Google api to capture addresses on order or contact forms it won’t be an issue.
  • When you open the sheet or enter new addresses it will take a few minutes to optimise.
  • 2,500 free directions requests per day
  • Up to 23 waypoints allowed in each request
  • You must have a Google account, to copy the sheet to your Google Drive
  • Delete empty waypoints when exported to Google Maps

Route Planner

  • Get the Route Optimiser here




If you find the Route Optimiser useful a donation would be nice to fund my daughters college fees


I believe in synergy skills for creating quicker, more efficient experiences in technology and workflows I am a Photo Restoration artist & SEO consultant specialising in small business and start-ups.

Leave a Comment