Excel Route Replay
Excel Route Replay
Excel Route Replay for GPS Logs
Stop guessing what happened during a trip. With Excel Route Replay, you can paste a GPS log into Excel and quickly turn raw latitude and longitude points into a clear trip summary, stop log, and driving behavior report.
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 Replay
Quickly calculate driving distances and travel times in Excel
Watch how the Excel Route Replay tool works:
Excel Route Replay helps you turn a raw GPS log into a clear trip analysis report directly inside Microsoft Excel. Instead of manually checking timestamps, latitude and longitude points, stops, idle time, and route segments one by one, you can paste your GPS data into the spreadsheet and let the tool analyze the trip for you.
It is built for reviewing completed driving routes, delivery trips, service routes, field visits, fleet activity, or any GPS log where you need to understand what happened during the trip.
Why Excel Route Replay is the GPS log analyzer you need for completed trips
My goal here at ExcelDistanceCalculators.com is to make GPS route analysis easier, faster, and more affordable for people who already work in Excel.
Nothing to Install
Excel Route Replay is built directly inside Microsoft Excel, so there is no complicated software to install. Just open the file, paste your GPS log, and you are ready to start analyzing your completed trip.
One Click Gets you Results
Once your GPS log is added, click the RUN button and the tool will generate your route analysis directly in the spreadsheet. It gives you a cleaner way to review completed trips without jumping back and forth between raw GPS data and Google Maps.
No Ongoing Charges
Once you purchase Excel Route Replay, you own the tool. There are no monthly or annual software subscription fees from us. 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 GPS log analyzer is built for regular Excel users. Paste your timestamped latitude and longitude data, then click the RUN button to analyze the trip. The tool will return a clear route report with total distance, drive time, idle time, stop locations, stop duration, and aggressive driving segments.
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 a simple, easy-to-use route planning tool built directly inside Microsoft Excel. It helps you optimize up to 100 stops and generate the best driving route, driving distance, and drive time. Here’s how it works:
Step 1
Open the Settings sheet, paste your Google Maps API key, choose your unit system, and adjust the stop, idle, GPS accuracy, and aggressive driving settings if needed.
Step 2
Open the Batch Input sheet and paste your GPS log with the timestamp, latitude, longitude, and optional speed.
Step 3
Click the RUN button and watch the tool generate your results in the Trip Summary, Stop Log, and Aggressive Driving sheets.
Who is the Excel Route Replay tool for?
Best for
- It is especially useful for teams that need to understand what happened during a route, including where the driver stopped, how long the vehicle stayed idle, how far the trip traveled, and how much time was spent driving. The tool can also help identify aggressive driving segments by comparing the driver’s actual travel time against Google’s estimated traffic-aware travel time for the same route segment.
What it helps with
- This helps reduce manual GPS log review, simplify route investigations, calculate total trip distance, review drive time and idle time, detect stops, convert stop locations into readable street addresses, and create a more organized Excel-based report from raw GPS data.
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 tool 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 Excel Route Replay be used for GPS logs from outside the US?
Yes. Excel Route Replay can be used with GPS logs from different countries because the main input is timestamped latitude and longitude data. If the tool needs to return stop addresses, it uses Google Maps data to reverse geocode those locations into readable addresses.
Just keep in mind that results depend on the quality of your GPS data and Google Maps coverage for that area. For driving analysis, the trip should also have valid road routes that Google Maps can recognize.
-
What is the maximum number of GPS records I can analyze in one run?
Excel Route Replay is designed to analyze a full GPS log in one run, but the practical limit depends on the size and quality of your GPS data. The tool uses smart sampling so it does not need to send every single GPS point to Google Maps.
For best performance, use a clean GPS log with timestamp, latitude, longitude, and optional speed. Very large files or noisy GPS data may take longer to process, especially if stop detection and aggressive driving checks are enabled.
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