Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainLogistics & ShippingDelivery Route Planner

SpreadsheetLogistics & ShippingFree

Delivery Route Planner

Plan a multi-stop route with miles, drive time, service time and a cumulative ETA for every stop, checked against delivery windows.

Shown with sample data

Colour

Delivery Route Planner

Plan a multi-stop route with miles, drive time, service time and a cumulative ETA for every stop, checked against delivery windows.

Delivery stops
8
Total miles
68.9
Back at depot
12:22
Arrival at the last row
Route cost
$202.59
Driver time plus vehicle miles
Late stops
1
Drive minutes by stop
  • Harbor Street Deli17
  • Greenleaf Market9
  • St. Mary’s Clinic kitchen12
  • Northside Elementary15
  • Copper Kettle Café13
  • Lakeside Hotel17
  • Riverbend Senior Living15
  • Fresh & Co. Grocers15
  • Return to depot19

How to use it

  1. 1On Settings, type the departure time as hhmm (730 for 7:30, 1315 for 1:15 pm) and your driver and vehicle costs.
  2. 2List stops in the order you will drive them, with miles from the previous stop (a map app gives this).
  3. 3Set an average speed for each leg: about 20–25 mph in town, 45–55 mph on highways.
  4. 4Enter time on site and each customer’s latest arrival time as hhmm; leave it blank if there is no window.
  5. 5Reorder stops until no stop shows Late, and keep the return-to-depot row last.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A dispatcher’s route sheet that does the arithmetic. Enter stops in delivery order with the miles from the previous stop, expected average speed and time on site; the planner works out drive time, a running ETA for each stop from the departure time, and checks it against each customer’s latest arrival time. It also shows total miles, total route time, the time the driver gets back and the cost of the route.

Who it’s for

  • Daily delivery routes for vans and box trucks
  • Checking a route fits a driver’s shift
  • Quoting delivery charges from real route cost
  • Field service visit planning

What’s included

  • Route sheet: Stops in order with drive time, ETA and window check.
  • Settings sheet: Departure time and cost rates.

How to use it

  1. 1On Settings, type the departure time as hhmm (730 for 7:30, 1315 for 1:15 pm) and your driver and vehicle costs.
  2. 2List stops in the order you will drive them, with miles from the previous stop (a map app gives this).
  3. 3Set an average speed for each leg: about 20–25 mph in town, 45–55 mph on highways.
  4. 4Enter time on site and each customer’s latest arrival time as hhmm; leave it blank if there is no window.
  5. 5Reorder stops until no stop shows Late, and keep the return-to-depot row last.

Tips

  • Add 10–15% to drive times for parking, traffic and fuel stops, or lower the average speeds.
  • Put stops with the earliest closing windows first, then sweep outwards in one direction to avoid crossing back.
  • Check the total against drivers’ hours rules: US property-carrying CDL drivers are limited to 11 hours driving within a 14-hour window; local rules vary.

Questions

How is the ETA calculated?

ETA = departure time + all drive time up to this stop + time spent at every earlier stop. Drive time = miles ÷ average speed × 60.

Does it optimise the stop order?

No. It calculates the times for the order you choose, so you can try different orders and compare. For dozens of stops, use routing software and paste the result here.

Why enter times as numbers like 1030?

Plain numbers work in every spreadsheet without time-format problems. 1030 means 10:30, 1545 means 3:45 pm.

Related searchesdelivery route plannerroute planning spreadsheetmulti stop route plannerdelivery schedule templatedriver route sheeteta calculator

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetLogistics & ShippingFree

Delivery Route Planner

Plan a multi-stop route with miles, drive time, service time and a cumulative ETA for every stop, checked against delivery windows.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Your copy is private to you.

More logistics & shipping templates

View all
Shipment & Delivery Tracker2 sheets

In transit

4

Overdue or exception

5

On-time rate

71%

ABCD
1DirectionCustomer or supplierCarrierService
2OutboundNorthwind RetailUPSStandard
3OutboundBlue Harbor CafeFedExExpress
4InboundEcoPackDHLFreight
5OutboundGreenfield SchoolUSPSStandard
Shipments
SpreadsheetLogistics & Shipping

Shipment & Delivery Tracker

Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.

10 min setupPreview
Fleet Vehicle Maintenance & Mileage Log2 sheets

Vehicles

4

Maintenance cost

$1,840

Due a service or inspection

1

ABCD
1DateVehicleTypeWork done
2Aug 14Van 1ServiceFull service, oil and filters
3Sep 2Van 2TyresTwo front tyres
4Sep 20Truck 1InspectionAnnual inspection, passed
5Oct 5Van 2RepairRear brake pads and discs
Service log
SpreadsheetLogistics & Shipping

Fleet Vehicle Maintenance & Mileage Log

Track each vehicle’s mileage, services, inspections and running cost per mile.

10 min setupPreview

Packing List

Packing list number: PL-0000 Date: Date Invoice number: INV-0000 Order / PO: Number

ShipperConsignee
Your companyCustomer company
AddressDelivery address

Shipment details

Carrier and serviceCarrier, service level
Tracking or waybillNumber
Ship dateDate

Contents

PackageDescription of goodsSKU
1 of 3Item descriptionSKU
2 of 3Item descriptionSKU

Total packages: 3 Total net weight: kg Total gross weight: kg Total volume: m³

DocumentLogistics & Shipping

Shipping Packing List

What is in each box of a shipment: items, quantities, weights and dimensions, for the receiver and for customs.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ