We’ve added a new template to our suite of CDXZipStream tools for FindZip Analysis. This template can take a long list of city and state combinations and produce a report of all matching zip codes. The template can be download for free at this link. It is compatible with both the demo registered versions of CDXZipStream.
While you can always copy the original FindZip formula to analyze a list this template streamlines the application. Rather than using delimiters as the formula does each zip code is output to a separate cell. This makes it simple to copy the lists to another application. The template can handle up to 250 zip codes per city/state entry. As with our other templates, you will see a status indicator showing the progress of the FindZip calculations in the lower left status bar.
Here is an example of the report output:
With the release of this application we now have templates that automate each CDXZipStream function. You can download this new FindZip tool and all of the other templates here. We recommend the use of these templates rather than copying formulas when analyzing long lists. We’ve also included videos demonstrating how to use many of the available templates.