Generate Timezone Result from an Address List in Excel
The Excel Zip Code Finder is a quick tool to find the zip codes that are within a distance radius of a point or address. Its most common application is for businesses trying to determine a location's ability to service addresses and zip codes.
Example 1 - "Servicing Shop A" located in "123 Main Street, Atlanta, GA" services and repairs refrigerators. The technicians are willing to travel 50 miles from the shop for a service call. The Excel Zip Code Finder allows the user to generate a list of zip codes that this shop can service that fall within the 50 miles radius. That list allows the shop to determine whether they should take a service call or refer it to a neighboring/competing business.
Example 2 - Harry employs several technicians across multiple locations. Each technician has a different maximum travel range based on their preferences. The "Excel Zip Code Finder" allows Harry to generate a list of zip codes each technician can service based on their travel range. He can do this with a click of a button and generate a personalized list of zip codes for each technician in a matter of seconds.
It allows the user to generate a list of zip codes based on a central address (or zip code) and a maximum radius/distance with the click of a button within Excel. Some of the benefits are:
The Excel Zip Code Finder is the easiest-to-use tool of its kind. You can generate a list of the zip codes within a radius of an address in Excel in three Easy steps. See below:
Step 1 Enter the central Zip code, Radius to search and the Maximum number of results you would like displayed. Then Click "Generate
Step 2 The tool will automatically generate a list of zip codes starting with the closest.
Step 3 That's it - there is no step 3.
While the Excel Zip Code Generator 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.