Excel Address Distance Calculator

  • Calculate distances in batch between multiple addresses in Excel
  • Done in VBA
  • Available for both Mac and Windows
  • One time fee of $49.99

 

FEATURES

What are the applications?
 
Application 1:
You have a list of contractors that you can assign a job to. You want to find the closest contractor in your Excel Spreadsheet to the client address.
You Enter the Client’s address and click Find “Closest Contractor”. My tool will give you the top 10 closest contractors with the one closest to the client being on top and sorted that way.
Application 2:
You have a list of 200 warehouses and you would like to know where to send the client. You Enter the Client’s address and after clicking “Find Closest WareHouse” a list of the top 10 closest warehouses will appear in your Excel Spreadsheet with the top one showing on top.

How did this Software Come to Be?

About 3 years ago, a client of mine was discussing over coffee a problem he was having. He, being in the real estate business, needed to find the driving distance and time between the different offices and each of the properties his company was listing. His secretary needed to make about 1,000 of these distance calculations daily. She would go to google maps and one by one would enter the addresses and note the distance. One day he was noticing that some of the distances seemed incorrect so he went to  check. ALL of the company’s calculations were WRONG in the file that was submitted.

How could that be? He asked the assistant and she swore she had calculated each one of them as instructed, and in fact it had taken her about half of the day to do so. Further investigation showed that the assistant, of Eastern European descent had switched the browser language and settings in Ukrainian so she could easily type in her native language to her long distance boyfriend. Hence the browser thinking it was being accessed in Europe was making the calculations in KM instead of MILES.

Thus came the idea to create a tool that calculates the distance between addresses or the distance between zip codes with the click of a button. The Zip Code Distance Calculator is integrated right into excel and it is ran with a click of a button. It eliminates the margin for error and in the case of my Real Estate Agent friend, it opened up his assistant’s time to do more lead generating and allowed her to contact more people. And YES she did marry her longtime boyfriend!

 

Our Zip Code Mileage Calculator calculates the mileage between a large set of zip codes in Excel. All you need to do is enter the beginning zip code in column A, and the destination Zip Codes in Column B and click calculate. Our tool will automatically calculate the driving distance between these 2 sets of zip codes. Whether you have 20 calculations to make or 2000 calculation is a breeze and with a click of a button.

  1. Calculates the distance between 2 addresses (zip codes) in excel
  2. Easy with a click of a button
  3. Uses Google API to calculate distance
  4. Only $19.98
  • You can calculate zip codes, addresses, cities
  • Uses the easiness of Microsoft Excel and the power of VBA Programming
  • You can calculate up to 2500 distances per day
  • 100% Money Back Warranty

Frequently Asked Questions:

What do I need to make Excel Distance Calculator  to Work?

All you need is Microsoft Excel Installed. Our software runs inside Excel. There is no need to install anything, not need to tweek anything. Just open the software as you would a regular Excel Spreadsheet. That’s it!

Will I have to install anything?

No, absolutely not! Our software is built on Excel. No need to install anything. Just open our file like you would any Excel Spreadsheet!

Can I install the software on Multiple Computers?

The License you will acquire today is for 1 user. Please purchase as many licenses as users you are planning to use the software.

Will it work on a Mac?

If you have a Mac please get the Mac Version of our Software here.

Please click here for the link to the Mac Version of the Excel Distance Calculator

How many calculations can I make? Am I limited to the number of calculations I can make every day? 

Our software uses Google Maps API which allows the user to make up to 2,500 calculations per day. If you think you need more than 2,500 calculations per day, please purchase the Professional Version of the Software

Click Here for the Link to the Professional Software. Make up to 100,000 Distance Calculations per day from Excel.

Can I apply the calculator to my own Spreadsheet?

OK you Excel Genius you! You can most Def apply our code to your Excel Spreadsheet to Calculate distances between addresses or Zip Codes. In order to do that, you might need to be a bit comfortable with VBA.

Does Coding scare you? No need to worry. Refer to this page and i will gladly apply that the calculations to your own spreadsheet.

Click to this page for more information on how I can help you make your spreadsheet super duper!

HELP / FREQUENTLY ASKED QUESTIONS (FAQ)

testing 123lkj lksdj sladkf jasdlfk asflkj

How many calculations can I make? Am I limited to the number of calculations I can make every day?

OK you Excel Genius you! You can most Def apply our code to your Excel Spreadsheet to Calculate distances between addresses or Zip Codes. In order to do that, you might need to be a bit comfortable with VBA.

Does Coding scare you? No need to worry. Refer to this page and i will gladly apply that the calculations to your own spreadsheet.

Click to this page for more information on how I can help you make your spreadsheet super duper!

Can I install the software to Multiple Computer ?

Does Coding scare you? No need to worry. Refer to this page and i will gladly apply that the calculations to your own spreadsheet.

Click to this page for more information on how I can help you make your spreadsheet super duper!

Can I apply the calculator to my own Spreadsheet?

OK you Excel Genius you! You can most Def apply our code to your Excel Spreadsheet to Calculate distances between addresses or Zip Codes. In order to do that, you might need to be a bit comfortable with VBA.

Does Coding scare you? No need to worry. Refer to this page and i will gladly apply that the calculations to your own spreadsheet.

Click to this page for more information on how I can help you make your spreadsheet super duper!

Will I have to install anything?

Does Coding scare you? No need to worry. Refer to this page and i will gladly apply that the calculations to your own spreadsheet.

Click to this page for more information on how I can help you make your spreadsheet super duper!