Route Optimizer in Excel
Route Optimizer in Excel
Route Planner with Google Maps API
Route Optimizer in Excel brings route planning and Google Maps powered results directly into your spreadsheet. It helps you optimize the best driving route for up to 100 stops, calculate drive time and driving distance, view the optimized route on Google Maps, and keep everything organized inside Excel.
Who Is This For?
Key Features
Watch How It Works
Couldn't load pickup availability
Check our 150+ Google Reviews
More than 150 clients have shared how our Excel tools made a difference in their business. See what they have to say about their experience!
Excel Route Optimizer and Route Planner
Quickly calculate driving distances and travel times in Excel
Watch how the Route Optimizer in Excel works:
Route Optimizer in Excel brings powerful route planner functionality directly into Microsoft Excel. Instead of checking stops one by one in Google Maps, you can paste your starting point, ending point, and stop list into the spreadsheet, then let the tool calculate the optimized route for you.
It is built to help you save time when planning deliveries, service routes, sales visits, pickup schedules, or any trip with multiple destinations. No coding is needed. Just paste your locations, click the button, and let the tool generate the best stop order with driving distance and drive time.
Why Route Optimizer in Excel is the route planner you need for multiple stops?
My goal here at ExcelDistanceCalculators.com is to make route planning easier, faster, and more affordable for people who already work in Excel.
Nothing to Install
Route Optimizer in Excel is built directly inside Microsoft Excel, so there is no complicated software to install. Just open the file, paste your route data, and you are ready to start planning.
One Click Gets you Results
Once your stops are added, click the route optimization button and the tool will generate your optimized route directly in the spreadsheet. It gives you a cleaner way to plan multiple stops without jumping back and forth between Excel and Google Maps.
No Ongoing Charges
Once you purchase Route Optimizer in Excel, you own the tool. There are no monthly or annual software subscription fees. If you need access for more people on your team, you can choose the multi user license.
World Class Support
If you have any questions...just Call me @ 801-243-8350 or Chat with me via the Chat Window. If needed, I will Zoom with you to make sure the product is setup correctly and you get all the help you need...in real time.
Oh just So Easy to Use!!
This route planner is built for regular Excel users. Paste your starting point, ending point, and list of stops, then click the button to optimize the route. The tool will return the best stop order along with driving distance and drive time.
100% Money Back Guarantee
If the product does not meet your needs, just send me a note and I will refund your purchase. No questions asked.
How Does It Work?
Route Optimizer in Excel is an easy to use route planner built directly inside Microsoft Excel. It helps you optimize up to 100 stops and get the best driving route, driving distance, and drive time. Here's how it works:
Step 1
Open the Settings sheet and paste your Google API key.
Step 2
Open the Stops Input sheet and paste up to 100 addresses.
Step 3
Click the OPTIMIZE ROUTE button and watch the tool do it's magic!
Who is the Route Optimizer in Excel for?
Real in-person help is available if you need it. Call, email, or chat with Vinnie
What do our Customers Say about us!
Don't just listen to us....read also what our customers are saying in Reviews!!!
Travis Robey - This product is amazing
The Product is Amazing!
Robert Phillips - From Ohio
No Issues with the software.
Vinnie, thanks for making such a great product.
Bob
Mandy Miller - I absolutely love the tool!
This tool was so helpful and worked like a charm.
Steve Whenman - Software Worked Perfectly
The Software installed perfectly, really pleased with the results
Matthew Smith - It's amazing, love it!
It's amazing, love it!!! Saved me weeks of analysis!
Hanna Ferguson - Software Works Perfectly
This excel sheet is going to make a massive difference to how much time we spend on mileage calculations!
Thank you so much for creating this.
Milan Stamenkovic - It's a Great Program
Everything is working great so far. It's a great program.
Travis Robey - This product is amazing
Robert Phillips - From Ohio
Mandy Miller - I absolutely love the tool!
Steve Whenman - Software Worked Perfectly
Matthew Smith - It's amazing, love it!
Hanna Ferguson - Software Works Perfectly
Milan Stamenkovic - It's a Great Program
You will need a Google Maps API to use this tool!
Powered by Google Maps API for fast, precise driving distances and times—just follow the steps to obtain and enable your API key.”
All of our tools use the Google Maps API to generate results. This allows for accurate driving distance and time results and fast data. I have included some instructions on how to get a google maps API and what services to enable.
Click on this video for more information on how to setup the Google Maps API Key.A few more things regarding the Google Maps API Key.
You don’t need to be a developer to setup a google maps api key. It takes about 5 minutes, and it is as simple as setting up an account with Google
- The Google Maps API Key is free to setup. It doesn’t cost anything.
- You will get up to 40,000 calculations free of charge. (Google allows for a 200 dollar credit for every calendar month).
- If you need more than 40,000 calculations in a calendar month, google charges an a-la-carte fee of 5 USD/1000 calculations.
- For most of my clients that use this tool, 40,000 calculations are more than enough.
- You will need to setup a billing account with Google, although you will not be charged unless you go over the 40,000 calculations per month.
- If you have a large number of calculations, (more than 40,000) contact me. I might be able to help.
Frequently Asked Questions (FAQs)
Quick, clear answers to your most common questions—self‑serve support when you need it.
-
Does this software work on Mac, or just PC?
While the Route Optimizer in Excel works on some versions of Mac computers, I currently do not offer support for MACs. As Macs use different VBA libraries, that can cause some conflicts with some of the functions in this tool. -
Is this a one time fee, or ongoing?
You will only pay once for this software. This will provide upgrades and live support via zoom if needed for one year. However the software should serve your needs for years to come. -
Do I need a Google Maps API Key? What is a Google Maps API key?
The Route Optimizer in Excel uses the Google Maps Platform to give you extremely accurate (to the 1/100th of a mile). As such you will need to setup a google maps account. It takes 5 minutes to setup and it is free of charge. You can view the instructions on how to setup the google maps api key in this page. I have also created a video where it shows step by step how to setup the api key by clicking in this youtube video.
-
Is the Google Maps API key free? Do I have to pay for my calculations?
The Google Maps API key is free to get. However, keep in mind Google does require you to setup an account. You can run up to 40,000 calculations every calendar month free of charge. If you go over the 40,000 calculations Google charges an a-la-carte fee of 5 USD/1000 queries/calculations. More information on Google Maps API Pricing can be found in this link.
-
Can I use Addresses or Zip codes? What format should my input data be?
The Route Optimizer in Excel is extremely forgiving when it comes to what data you can use/enter. You may enter a combination of full addresses, zip codes, City/State or even Geocodes (Long/latitude).
So “84122”, “ 123 Main, Park City, UT, 84101” or “Park City, UT” are all acceptable addresses. You can also mix and match your different address types. Obviously the more complete the address, the better ( more accurate) results you will receive.
-
Can the Route Optimizer in Excel be used for non-US addresses? Can I enter, say Canadian or British Zip Codes?
Absolutely. The Route Optimizer in Excel works with addresses from all over the world. As it calculates driving distances please note that there needs to be a driving path between the two addresses. So a calculation between “New York City, NY” and “Paris, France” will not return a value as there is no driving path between those two cities as they are separated by ocean.
-
What is the maximum number of calculations I can perform at any one single run?
The tool can optimize up to 100 stops. For route optimization, Google Maps API allows a maximum of 20 locations per calculation, so Route Optimizer in Excel processes larger stop lists in groups while keeping the route planning workflow organized inside Excel.
Address Validator/Checker Excel
The Excel Address Validator is an Excel-based tool that allows YOU as the user to Validate and Standardize a list of Addresses in USPS format directly in an Excel spreadsheet.
View Now
Matrix Excel Distance Calculator
The Excel Matrix Driving Distance Calculator is an Excel-Based Tool that allows YOU as the user to Calculate Driving Distances in a Matrix format directly in your Excel Spreadsheet.
View Now
Driving Distance Calculator with Toll Cost in Excel
The Driving Distance Calculator With Toll Cost in Excel is an Excel-based tool that allows YOU as the user to Calculate Driving Distances with Toll Cost directly in your Excel Spreadsheet.
View Now