Excel Store Locator - Locate the Closest Store to a List of Clients in Excel
Excel Store Locator - Locate the Closest Store to a List of Clients in Excel
Couldn't load pickup availability
Our Software is Used by:
Excel Store Locator - Locate the Closest Store to a List of Clients in Excel
Check out how the Excel Store Locator works in the video below:
The Excel Store Locator is an extremely-to-use tool that allows you to match a list of clients with a list of providers or stores based on address.
In other words, it allows you to match each client with a provider based on driving distance from the service provider.
It is the only tool of its kind that can complete this task in Microsoft Excel leveraging it’s ease of use and the power of Google Maps sprinkled with our proprietary algorithm.
Top Benefits of the Excel Distance Calculator!
Easiest to use tool of it’s kind
The Excel Store Locator makes matching your customers to your Service Providers or Store based on driving distance a breeze.
No coding necessary
You will not be required to create or edit code. The magic works on the background, so you as a user can have a no-coding-required magnificent experience.
No Installation Necessary
As it is built in Excel, there is nothing to install. Just Download, open the tool, paste your data and Click “Calculate”.
Amazing Support
In our digital era, where everything is AI generated, talking to an actual person is quite a treat. Talk to my by clicking on the “Chat Now” link in the bottom right.
100% Money Back Guarantee
My goal is to provide 10times more value than the tool costs. If you feel that is not the case…I WILL REFUND 100% OF YOUR COST- NO QUESTIONS ASKED!
How Does It Work?
The Excel Store Locator follows the trend of all of our software - how to make the Locate the Closest Provider from your Provider List based on Distance....THE EASIEST WAY!
Step 1
Enter your Store or Installer Data with Addresses in the first sheet:
Step 2
CEnter the Customer Information in the "Customers" Sheet!
Step 3
Click "Calculate". The Store Locator will match each customer with the closest Location in your list like Magic! All done in Excel!
What is the Purpose of the Tool?
It allows the user to calculate driving time and driving 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!
- 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 uses and how the Excel Store Locator?
The Excel Store Locator is an excel based tool that allows users to match a list of client addresses with the closest location based on a list of store or any other type of service provider locations. As there are many uses for this tool, I am including a few examples of how the Store Locator is used by current clients.
Example 1 - Match Customers with the Closest Store in Excel
- You have a list of 200 Customers and their addresses
- There are 150 Stores across the US that carry your product
- You need to direct each one of the 200 customers to the closest store by location in their area
The Excel Store Locator allows you to match each customer with the closest store
Example 2 - Match Customer Orders with the Closest Contractor in Excel - You have a list of clients that need their appliance repaired. You need to match that list with the list of the contractors that can provide that service based on location (closest contractor to the client). The Excel Store Locator makes that matching activity a breeze. You maintain the client list in the "Clients" sheet and the Contractor List in the "Stores" list. The Excel Store Locator makes finding the closest locator easy to generate with the click of a button.
Dont listen to me...see some emails I have received from my customers like you!
Travis R - From Pensylvannia
Hi Vinnie...
The Product is amazing!
Bob Phillips - From Ohio
No Issues with your Software..
Vinnie Thanks for making such a a great product...-Bob
I Absolutely Love the Tool - Mandy Miller
I absolutely Love the tool! The tool was so helpful and worked like a charm. I would love to see more of the Offerings!
Mandy Miller
Steve Whenman - Really Pleased with the results
The Software Installed perfectly...api was no problem. Really pleased with the results
Travis R - From Pensylvannia
Bob Phillips - From Ohio
I Absolutely Love the Tool - Mandy Miller
Steve Whenman - Really Pleased with the results
Frequently Asked Questions (FAQs)
-
Does this software work on Mac, or just PC?
While the Excel 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?
The Excel Distance Calculator 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 fond in this link. -
Can I use Addresses or Zip codes? What format should my input data be?
The Excel 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.
You will need a Google Maps API to use this tool!
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.
