Three ways to plan routes with spreadsheets 1: Route planning with Excel alone Now that your spreadsheet is set up correctly, we can get on with the route planning. To do this, simply create two columns titled Latitude and Longitude in lieu of the Address column.
There are benefits to doing this if you want to be able to sort your addresses by zip or postal code (more on this below).Īnother option is using lat-long coordinates. If you prefer, you may also split up the address into 4 separate columns: The “Address” should contain the full address of your customer which ideally includes the street number, street name, city, state or province (if applicable), country, and zip or postal code. In the “Name” column, you can put either your customer’s first and last name or their business name. The two columns should be called “Name” and the second one should be called “Address”. Here's a spreadsheet template to help you get started. We suggest starting off by creating at least 2 columns, at the bare minimum. To plan your routes using Excel, Google Sheets, or any other spreadsheet program, you’ll need to include some basic data. How to format your Excel file for delivery route planning
We're using Google Maps in our examples, but you can apply the same principals to Excel both software function almost identically. Our personal favorite here at Routific is Google Sheets.
There are also other programs like Numbers (for Mac users) and LibreOffice Calc (open source and free!). Perhaps the most well known is Microsoft Excel. There are a few computer programs to choose from when you’re working with spreadsheets. How to use Excel & Google Maps to plan delivery routes up to 2000 stopsĪll three ways use spreadsheets, but you’ll notice two of the tactics leverage the use of software as well.īefore we start route planning, we need to make sure your spreadsheet is set up properly.How to plan delivery routes with Excel (spreadsheets alone).In this blog, we’ll show you how to format your Excel spreadsheet and three ways to plan routes: In this post we’ll show you how to use Excel as a route planner to find the best routes. Love them or hate them, Excel spreadsheets are a part of your life-especially now that you’re managing a delivery business.
0 kommentar(er)
