6 Free Templates for Microsoft Excel

Whether it's a delivery route, sales call schedule, or any other multiple-stop driving route, optimizing the order of stops can pay big dividends in saving employee time and reducing fuel usage. Our free Excel template for route optimization utilizes both CDXZipStream and Microsoft MapPoint to identify the order of intermediate stops that results in the shortest driving time. Just enter the list of addresses for the route into the template, click a button, and the optimized route is returned to the spreadsheet, with total driving time, duration, and cost already calculated. This easy-to-use, economical approach allows for multiple copies to be deployed among field office locations and sales representatives, and since the template can be installed on a laptop and doesn't require internet access, it can work remotely, especially important for last minute route changes. And the optimized route can then be exported to a GPX file that can be used with many GPS systems. View the tutorial to see how easy route optimization can be, both as a cost-saving measure and green initiative:

This template works with CDXZipStream and Microsoft MapPoint to calculate driving time, driving distance, cost, or total trip duration between two lists of addresses. There's no need to input addresses individually into Google Maps or Mapquest - just copy and paste your address lists into our driving calculation template, which will provide the desired output (time, distance, cost or duration) for each address pair. Input the same address for one of the lists if you need complete driving data around a single location. This is a quick and easy way to validate travel expenses. For a quick overview please watch the tutorial below:

Geocode (latitude and longitude) data is now frequently used by businesses to help find and identify current and new customers. The advantages of using geocode data are many, including better accuracy, the ability to calculate distances between points of latitude and longitude, and compatibility with GPS (Global Positioning Systems), now a common feature provided with the iPhone, iPad and many other mobile devices.

Our geocoding template works with CDXZipStream and MapPoint to provide latitude and longitude data for address lists. It can also be used to verify the accuracy of mailing lists based on the quality of the address match to the MapPoint database. Please view our tutorial below to see how it works:

To demonstrate a practical application of our zip code radius template, we've input the locations of all U.S. nuclear facilities into the template, allowing for easy identification of plants that fall within a radius distance of a target zip code. See how our nuclear facility radius calculator works in this tutorial: