Free Address Correction and Zip+4 Lookup Template

CDX Technologies now offers a free template that uses our CDXGeodata service to correct and parse address lists and perform Zip+4 lookup.  The template can be downloaded here and will work on Windows and Mac versions of Excel.

CDXGeodata is a set of spreadsheets apps and web service APIs that work with a variety of software platforms including Windows, the Apple Mac and Linux.  It was developed for use by standard business professionals as well as programmers to develop custom desktop or web based applications.  A free account which renews each month is available that allows 200 address requests.  Additional requests that are good for up to one year are also available for purchase.

To use the template, you will first need to get a free CDXGeodata API key from CDX Technologies.  This key will need to be entered into the CDXGeodata template by pressing the “Settings” button on the first spreadsheet tab.


Then just paste your address list into the template, and press the “Verify Addresses” button as shown below.

Note how the input data fields contain mixed instances of single line and multi line addresses.  Instances with and without zip codes are also supported.

The template automatically compares each address to the US Postal Service databases on CDXStreamer servers.  Addresses are returned to the template with correct spellings, abbreviations, and formatting.  ZIP+4 codes are also returned.  Here is an example of the returned output.

Inputted address can be in either single-line or parsed formats.  Input should include as much information as possible, but incomplete address information (e.g. with missing ZIP codes) can also be used.  Secondary addresses such as “Suite” or “Apartment” can be included in the address such as “2 W Hanover Ave Ste 212”.  Do not use a comma or other delimeter between the primary and secondary address.  For single line entries the recommended format should be address, city and state separated by a comma and followed by a space and a zip if available.

The verification process will correct misspellings, add omitted data (such as ZIP+4 codes) and use standardized formatting defined by the postal service.  The verified addresses are displayed in both single line format, as well as parsed into separate columns for street, city, state, and ZIP+4 codes.  If an address cannot be found in the postal database, or if not enough data was provided, an error message is returned.

Additional data items are returned which included the county name, state FIPS, county FIPS and timezone and DPBC (Data Processing Bar Code).

The template also allows the user to restart the verification process from the last verified address if the process was interrupted.

As with most address verification systems, CDXGeodata verifies whether the address is valid, not whether the location or residence physically exists.  For example, if a street number for a house is potentially valid based on the allowed range and numbering system of the specified street, the address is considered valid as a whole.

CDXGeodata is not licensed on a per user basis like CDXZipStream.   Any number of users can access the CDXGeodata service with a single API key.  Tokens are used to access CDXGeoData with different levels for each service request.  Simple requests like zip code lookups only require 1 token while more complex analysis address verification will require 5 tokens per request. Each free CDXGeodata account comes with 1000 tokens per month. Additional tokens can be purchased on an as needed basis with the following pricing.  The tokens are good for up to one year. 

Please feel free to take advantage of this service.  It’s easy and risk free to get started with our free account.

CDXGeodata - Apps and Web Services for Location Analysis

We’ve just introduced CDXGeodata to expand our offering of location analytics software.  CDXGeodata is a set of spreadsheets apps and web service APIs that work with a variety of software platforms including Windows, the Apple Mac and Linux.  We’ve designed this product so it can be used by standard business professionals as well as programmers to develop custom desktop or web based applications.   Currently our CDXZipStream and CDXStreamer products only work with Windows versions of Microsoft Excel.  CDXGeodata dramatically expands this coverage

Our initial release includes API web services that support address correction, Zip and Zip+4 lookup, distance, lists and radius calculations.   The CDXGeoData Web Services API uses REST (REpresentational State Transfer), which is used to build web services that are lightweight, easy to maintain, and scalable.  We’ve also created a set of 7 Excel spreadsheet apps that work with these services.   The apps automate bulk requests to the services and can create reports such as filtering an address list by radius distance and analyzing demographics within a radius.  These templates have been designed to work both with Excel for the Mac and well as Excel for Windows.  Just enter your key and paste in your data to get the reports you need.

CDXGeodata is not licensed on a per user basis like CDXZipStream.   Any number of users can access the CDXGeodata service with a single API key.  Tokens are used to access CDXGeoData with different levels for each service request.  Simple requests may only require 1 token while more complex analysis like radius analysis will require more.  A free account is available that supports up to 1000 tokens each month for development, evaluation and non-profit use.   Additional requests can be purchased in blocks that start at $29.95 for 5000 requests.  These tokens remain available for up to 1 year.

If you have one of our current products you might ask why you might need this service.  Not all customers have every feature available and might need to do a one-time radius analysis or demographic report.  CDXGeodata allows you to purchase this data at a much lower price when compared to upgrading your software.  That being said, CDXZipStream and CDXStreamer provide an unlimited number of request for users who regularly produce such reports.   You might also want to distribute a radius analysis to a wide variety of users in your company.  CDXGeodata would allow you to produce a custom Excel template or intranet site that could be distributed without requiring any additional software to be deployed.  Using CDXZipStream would require each user to own and install a license, CDXGeodata would not.  You just pay for the number of token requests you need.

You can develop custom apps yourself using the portal or contact us to do the work for you at   If you are familiar with VBA, an excellent resource for developing with REST based services is to use a template called VBA-Web.  Both the documentation and the template itself are available at the link given.  The template is available for use under MIT license. 

Both programmers and business users can also interface with the service thru a portal we’ve developed at  You log in with your username (usually your email address) and the API key that received when setting up your account.   With this portal you can track usage, create and download example reports and view programming examples in C#, Javascript and VB.  Programming examples using the VBA-web template are also available at

Here is a screenshot of the  portal interface.


We think that you will find CDXGeodata a powerful and flexible environment for all your location analytics needs.  It’s free to get started with a development account so we encourage you to take advantage of the service.

Free ZIP Code Lookup for City, County, State, and More

Do you ever need to do a ZIP Code lookup to find the correspondent city, county, or state? CDX Technologies now offers a free ZIP Code lookup tool on our website that allows you to input a U. S. ZIP Code and retrieve general data about it. Just press “Generate Report” to get the following output:

Data include congressional district information, elevation, land area and water area, latitude and longitude, as well as the latest population estimate from the U.S. Census Bureau. Click on the printer icon to print, or press “Data Definitions” to get information about each data item.

If you need to do ZIP Code lookup for an extensive list of ZIPs, we also offer a Microsoft Excel add-in, CDXZipStream, that can work with large amounts of data in Excel. CDXZipStream is a multi-purpose tool that can not only perform ZIP Code lookup, but can also calculate distance between ZIP Codes, find driving distance and driving time, perform address and ZIP Code radius analysis, create maps, and do other analysis of location-based data. It also comes in several versions to fit your particular needs. Here is a short tutorial showing how it works:

Pricing begins at $69.95, which includes a one-year subscription to our U.S. ZIP Code database. A free 30-day trial is also available.

Learning Resources for CDXZipStream

CDXZipStream, our Microsoft Excel add-in for location-based and ZIP Code analysis, is a powerful yet easy-to-use tool you can access straight from your worksheet. Here’s some of the functionality it can provide for your Excel data: 

- ZIP Code lookup
- Calculate the distance between ZIP Codes
- Calculate driving time and driving distance
- Address and ZIP Code radius analysis
- Route optimization
- Mapping
- ZIP Code demographics (as well as other geographies such as state, county, city, and census tract)
- Geocode and reverse-geocode

 If you’re new to CDXZipStream or even if you’re an experienced user who wants to explore all of its functionality, we offer a number of learning resources that are available both from within the software and on the web:

Data Feed Examples: After installation of CDXZipStream, a file of data feed examples opens. This covers all CDXZipstream functions, and includes examples of these functions in Excel formulas. This file can be found in the "C:\Users\Public\Documents\CDXTechnologies\CDXZipStream\" folder on your computer, or you can download it directly from the website.

QuickStart Guide: A good place to start, this is a short video tutorial providing an overview of CDXZipStream capabilities. You can access it on our website directly from the CDXZipStream commandbar, from the CDXTech website under “General” tutorials, or from our YouTube channel here.

Help File: A comprehensive guide to all functions, including examples and common troubleshooting issues. It is also accessible directly from the CDXZipStream commandbar, or from the resources area of the website.

Website FAQ: The section for CDXZipStream Frequently Asked Questions covers common questions on how to use the software, from how to get a Bing Maps license key to how to optimize driving routes.

In the CDXZipStream Support area of we also offer

Video Tutorials: Tutorials are available from the website and on our Youtube channel. If you have a Youtube account, you can subscribe to our channel to receive notifications when new tutorials are posted.

Resources: The Resources area for CDXZipStream includes a variety of articles and other information sources, including examples of how CDXZipStream can support the various needs of your business or organization.  Need to find the data source or data fields definition of demographic data provided with CDXZipStream? You can download it from the Resources page under "CDXZipStream Data Fields File PDF File".

Troubleshooting: Troubleshoot installation and operational issues for the current and past versions of CDXZipStream here.  There is also an abbreviated troubleshooting guide in the help file.

Still have questions about CDXZipStream that aren’t answered by any of the above? Contact or give us a call at 973-895-5542.

Finding the Closest ZIP Code Using an Excel Template

CDXZipStream, our Microsoft Excel add-in for location and ZIP Code analysis, includes a function called CDXClosestZIP, which can find the first, second, or third-closest ZIP code to a target ZIP.  It quickly and easily finds the closest stores to customers, the closest hospitals to patients, the closest distribution centers to delivery points, and so on.  It also calculates the straight-line distance between the target and closest ZIP Codes. A detailed description of how to use this function is included in the post How to Get the Closest, Second- and Third-Closest ZIP Codes.

We now also offer a free Excel template that completely automates the use of this function. (Please see here for a list of all downloadable templates.) The template can optionally check the validity of all ZIP Codes included in the analysis, and includes the ability to automatically retrieve data associated with each closest ZIP Code. For instance, if searching for stores closest to a customer, it will identify the store ZIP Code as well as information such as store number, city, state, or any other information provided within the template. Here’s a short tutorial showing how it works:

The template can work with large sets of data, covering thousands of target locations. It is compatible with the CDXZipStream Lite, Basic, and Premium Demographic versions.

Distance calculations for CDXClosestZip are based on the latitude and longitude coordinates of the centroid point of each ZIP Code. If a more accurate analysis is required using coordinates of a specific address, for example, we also offer a Geographic Access Analysis template shown here: