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.