Check out how the "Excel Straight Line Distance Calculator" works in the video below:
The Excel Straight Line (as-the-crow-flies) Distance Calculator brings the straight line (aka air miles) results directly into your Excel Spreadsheet. It will save you hours of trying to figure out these distances up. With no coding necessary it allows YOU to calculate thousands of straight line distances with the click of a button!
How Easy it is to use the Excel Straight Line Distance Calculator?
The Excel Straight Line Distance Calculator is the easiest-to-use tool of its kind. You can get your "Straight Line" or "Air Miles" Distances directly in Excel in three easy steps. See below on how it works:
Enter the central Zip code, Radius to search and the Maximum number of results you would like displayed. Then Click "Generate
Click the “Calculate” button.
That’s it! - Watch the tool generate the straight line distance directly in the spreadsheet!
What is the Purpose of the Tool?
It allows the user to calculate straight line (as the crow flies) distances directly into excel. Some of the benefits are:
NO installation necessary. All you need is Excel in your desktop.
NO programming know-how required. A spreadsheet with a "Calculate" button in it and you are on your way to automating the driving distance and driving time calculations!
Who is the Excel Straight Line Distance Calculator for?
The Excel Straight Line Distance Calculator is an excel based distance calculator that allows the user to generate Straight Line Results (aka as-the-crow-flies or air miles) of a large list of addresses, zip codes, cities or geocodes. It allows the user to save tremendous amount of time by automating the calculation of straight line distances for a large list of addresses, up to tens of thousands of address or zip code combinations!
Frequently Asked Questions (FAQs)
Does this software work on Mac, or just PC?
While the "Excel Straight Line Distance Calculator" works on some version 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?
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 a billing 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 fond in this link.
Can I use Addresses or Zip codes? What format should my input data be?
The Excel Straight Line Distance Calculator 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 Excel Distance Calculator be used for non-US addresses? Can I enter, say Canadian or British Zip Codes?
Absolutely. The Excel Distance Calculator 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 Excel Distance Calculator is meant to help you calculate driving distances and driving times between large sets of addresses. However keep in mind that the calculation is at the rate of about 3-5 calculations per second. So a 200,000 calculations data set would not be practical as it would take quite a long time. In addition, be aware of the costs associated with running such a large number of address sets. Refer to the API Setup Page for more information, but as to current time google allows for 40,000 calculations monthly free of charge. (via a 200 USD recurring monthly credit)
Would I get my calculations in Miles or KMS? Can I choose between the two?
The Excel Distance Calculator includes a "Settings" tab which allows you to choose your results between KMS or Miles.
How is the driving time calculated? Would I always get the same result?
The Excel Driving Distance Calculator generates real-time Driving Time from Google Maps. As such the driving time between the same addresses might vary slightly depending on traffic conditions.