Excel Store Locator - Locate the Closest Store to a List of Clients in Excel
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 customers and want to direct them to the closest store based on all 100 locations. Instead of looking them up one by one, you use the Excel Store Locator which with the click of a button tells you exactly which store from the list of the 100 stores is the closest to each one of your 1500 clients.
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.
It allows the user to calculate driving time and driving distances directly into excel. Some of the benefits are:
The Excel Store Locator follows the trend of all of our software - how to make the easiest possible
Step 1 Paste the data in the excel tool.
Step 2 Click the “Calculate” button.
Step 3 That’s it! - Watch the tool generate the driving distance and time in real time.
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.
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 here for more information on how to setup 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.