Excel Distance Calculator | Calculate distance and travel time with Excel and Google Maps
Are you looking for a handy tool to calculate distances and travel times between thousands of addresses or (zip)postcodes? The Excel Distance Calculator is a ready-made solution and calculates your distances with the help of Google Maps API! This application is also widely used to calculate distances and commuting times of your employees.
Specifications Distance Calculator
- Flexible mobility application to calculate distances and travel times between thousands ZIP/postal codes or addresses
- Windows Excel application. Works anywhere in the world!
- Distance and traveltime calculation at the touch of a button
- Choice of driving, cycling or walking and of KM or MILES
- RealTime distance calculations
- Use your own personal Google Maps directions API key or create one
- Up to 40,000 free calculations per month
- One-off purchase cost of € 195,-
How do I calculate distances and travel times between multiple adresses?
Q: How do I calculate distances and travel times between multiple adresses?
A: The Excel Distance Calculator uses Google Maps API to calculate distances and travel times between multiple addresses or postal codes!
The built-in VBA code of the Excel Distance Calculator processes the input of the location data and sends this data on to Google Maps. Here the location data is processed by the Directions API of Google Maps.
The entered addresses and postcodes are first converted to Latitude and Longitude coordinates. This conversion is also called geocoding. The LatLon coordinates are then processed by the route planner of Google Maps. This takes into account the mobility variables specified, such as car, bicycle and walking. The results of the distances and travel times are fed back to the Excel Distance Calculator and correspond 100% to the online Google Maps route planner.
Who are the users?
Companies and organizations that want to (re)calculate the distance between large numbers of addresses or postal codes can benefit from this Excel application. Every year distances and travel times of commuters change due to changes in company locations, relocation of employees or due to the construction of new (high)ways and bridges.
These changes have a direct impact on, among other things, the calculations of your employees’ mileage allowances. Personnel and salary administrations in particular find this calculator a useful tool that takes a lot of work off their hands. But also companies that want to measure the distances to postal codes around their compagnie location are clients of this mobility tool.
We offer this application in Germany as the Entfernungsrechner and in the Netherlands as the AfstandsCalculator.
Use and customise the VBA code of the Excel Distance Calculator
You can use the VBA code as a source and customise the tool for your own purposes. After purchase and payment of the application we will deliver you the Excel file without password protection. The only restriction is that you do not offer the tool for sale again via the internet (NFR).
- If you are interested or have any questions regarding purchasing the VBA code of this application, please contact sales.
Network of mobility and transport
Timedistancecalculation.com is part of a network of mobility and transport websites and is part of the Dutch website Waalstad.nl. Goal of the websites is to inform travellers about distances and travel times in commuting. In addition, the tools on the website provide distance calculations between places and/or locations.
Tags: excel, google maps, api, calculate, driving distance, driving time, distance calculator, drive, addresses, VBA script, macro, road, postcode, zipcode.