Skip to product information
1 of 1

Order List of Clients By Proximity to Office in Excel

Order List of Clients By Proximity to Office in Excel

The Order List of Clients By Proximity to Office in Excel is an Excel-based tool that allows YOU as the user to Order the List of Clients Addresses from the Closest to the Farthest from Office directly in an Excel spreadsheet.

Regular price $89.00 USD
Regular price Sale price $89.00 USD
Sale Sold out
Users
View full details

WHAT OUR CUSTOMERS ARE SAYING!

Don't just listen to us....read also what our customers are saying in Google Reviews!!!

Our Software is Used by:

Order the List of Clients Addresses from the Closest to the Farthest from Office in Excel

A quick Demo Video of how the Order List of Clients By Proximity to Office in Excel works!

The Order List of Clients By Proximity to Office in Excel is an extremely easy-to-use tool that allows you to order a list of clients location to the office from the closest to the farthest. 

It is the only tool of its kind that can complete this task in Microsoft Excel leveraging the power of Google Maps that will help you cater clients systematically without wasting time and gas. 

Why the "Order List of Clients By Proximity to Office in Excel" is the tool you need to sort a large list of addresses at once?

My goal here at ExcelDistanceCalculators.com is to provide the easiest-to-use and most affordable tool of its kinds. 

Nothing to Install

As the tool is built in Excel, there is nothing to install. Just open the file and start using it. 

One Click Gets you Results

Once you have input the data, you click "Calculate" and the Sorted List of Clients will show on your page. It's that easy. 

No Ongoing Charges

Once you purchase my Order List of Clients By Proximity to Office in Excel...you own it for life. No monthly or annual charges. Consider the Multi-User license for Unlimited Users. 

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. 


100% Money Back Guarantee

If for any reason....you feel the product will not meet your needs....Just send me a note, and I will refund your purchase...NO QUESTIONS ASKED!

Oh just So Easy to Use!!

All you have to do is set up the "Employees" tab which can be a list of Clients or Employees with their Addresses. Then paste your office address or a client location and click "Calculate". You'll get the sorted list from Closest to Farthest within seconds!

How Does It Work?

The Order List of Clients By Proximity to Office in Excel is the easiest-to-use tool of its kind. You can order list of clients by proximity from your office directly in Excel in three Easy steps. See below:

Step 1

Paste Client List with their Addresses and your Office Address.

Step 2

Click "Calculate" button

Step 3

Watch the tool sort Clients from Closest to Farthest with the driving distances. It's that easy!

What is the Purpose of the Tool?

It allows the user to sort clients addresses by proximity to office directly in Excel. Some of the benefits are:

  • NO installation is necessary. All you need is Microsoft Excel installed on your computer.
  • NO programming know-how required. A spreadsheet with a "Calculate" button in it and the tool will sort the addresses from closest to farthest in a breeze!
  • NO monthly charges. Just a one time fee!
  • REAL In Person Help if you need it. If you have any questions, email, call or just talk to me on the chat on this site!

Who is the "Order List of Clients By Proximity to Office in Excel" for?

The Order List of Clients By Proximity to Office in Excel is an Excel-based distance calculator that allows the user to generate Driving distances of a large list of addresses, zip codes, cities or geocodes. It allows the user to save tremendous amount of time by automating the process of sorting a large list of clients to the office from the closest to the farthest.



This tool can benefit various professionals in multiple situations and scenarios:


Businesses:

Scenario: A company with multiple offices needs to plan a series of site visits for maintenance checks. The tool helps them schedule the visits efficiently by organizing the offices based on their proximity to each other.


HR Departments:

Scenario: An HR manager needs to coordinate a company-wide training session across several locations. Using the tool, they can arrange for the trainer to visit the locations in an order that minimizes travel time and costs.


Sales Teams:

Scenario: A sales representative has a list of clients to visit in a new city. The tool helps them organize their visits so that they can see the maximum number of clients in the shortest amount of time.


Logistics Companies:

Scenario: A delivery company needs to plan routes for multiple deliveries in a day. The tool assists in determining the most efficient route, reducing fuel costs and ensuring timely deliveries.


Real Estate Agents:

Scenario: A real estate agent has several property showings in different neighborhoods. The tool enables them to plan the showings in a way that minimizes driving time between properties.


Event Planners:

Scenario: An event planner is organizing a city-wide event with multiple venues. The tool helps them coordinate vendor and guest arrivals by organizing the locations in an efficient sequence.

What do our Customers Say about us!

Hannah 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.

Matthew Smith - It's amazing, love it!

It's amazing, love it!!! Saved me weeks of analysis!

Steve Whenman - Software Worked Perfectly

The Software installed perfectly, really pleased with the results.

Mandy Miller - I absolutely love the tool!

This tool was so helpful and worked like a charm.

Robert Phillips - From Ohio

No Issues with the software. 

Vinnie, thanks for making such a great product.

Bob

Travis Robey - This product is amazing

The Product is Amazing!

Hannah Ferguson - Software Works Perfectly
Milan Stamenkovic - It's a Great Program
Matthew Smith - It's amazing, love it!
Steve Whenman - Software Worked Perfectly
Mandy Miller - I absolutely love the tool!
Robert Phillips - From Ohio
Travis Robey - This product is amazing

Frequently Asked Questions (FAQs)

  • Does this software work on Mac, or just PC?

    While the Order List of Clients By Proximity to Office 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 Order List of Clients By Proximity to Office 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 Order List of Clients By Proximity to Office 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 Order List of Clients By Proximity to Office in Excel be used for non-US addresses? Can I enter, say Canadian or British Zip Codes?

    Absolutely. The Order List of Clients By Proximity to Office 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 Order List of Clients By Proximity to Office in Excel is meant to help you calculate distances 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)

You will need a Google Maps API to use this tool!

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 a 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.