An example of this follows:įor a two column file format, you should enter the street address in the first column and the City State, Zip code in the second column as shown below. The format is Address, City, State and Zip. DO NOT USE HEADERSįor Excel files all data can be included in a single column. You can enter your address list using either 1, 2 or up to 4 columns. Please note that individual and business names are not supported. Secondary address data (such as suite or apartment) should be included with the address. We support both Excel and CSV file formats. One of the header row values above is required to first identify the main street addressĪ single column of optional data can be included in the output file by labelling the first column in your input file with the header "ID"
#Look up zip code software
Our software supports the following header row values to identify the Secondary Address column:
With secondary address information placed directly after street address. If your file contains both street address AND secondary address columns, they must be in squential order Here is an example showing how your data file should look for four column formatting:įor files containing header rows, our software supports the following header row values to identify the Street Address column: Street Address, City and State ARE REQUIRED. Here is an example showing how your data file should look for two column formatting:įor files with three, four or five columns of data, your data should be split out into the approprate number of columns following the two column example above Include as much information as you have available in the second column (The Zip code is optional) Here is an example showing how your data file should look for one column formmating:įor a two column file format, you should enter the street address in the first column and the City State, Zip code in the second column The format is Street Address, City, State and Zip (The Zip code is optional) Click Here For Help if you wish use column headers.įor Excel files all data can be included in a single column. PLEASE NOTE: Header values are optional as the tool will attempt to find the proper columns. Street Address, City and State ARE REQUIRED to verify an address. Please review what formats our software expects below. Your upload file can contain up to 6 columns. Simply drag & drop or select your data file below to begin! This alternative report contains information such as address best match, latitude, longitude, postal code and other key location information. You can also choose to immediately select columns by clicking the check box below.įor worldwide lookups or having only partial address information we recommend our Location Data Batch Report. If our software can't identify the input format a screen will be presented allowing you to match columns to the expected address fields. Optional data such as a name or reference number can be included by specifying headers with the first column name set to 'ID' as in the following file example. The output data file is in exactly the same row order as the input file including blanks and errors. These inputs will produce the following output data file. A multi-column input file is available at this link.
#Look up zip code how to
Click here for further instructions on how to format your address list.Īn example of an single column input file can be downloaded here. Be sure to include address data (address, city, state) in consecutive columns. Upload your input address file in csv or Excel. For a quick review of how to use this tool check out this Youtube video. Up to 20,000 address can be processed in a single report.
Use your existing CDXStreamer account or pay $.0.01 per address using your credit card or PayPal (minimum charge of $9.95). Check your list of US addresses and add Zip+4 data using this Bulk Address Correction tool from CDX Technologies.
0 kommentar(er)
