We support both Excel and CSV file formats.
Your upload file can contain up to 6 columns. Please review what formats our software expects below.
Street Address, City and State ARE REQUIRED to verify an address.
PLEASE NOTE: Header values are optional as the tool will attempt to find the proper columns. Click Here For Help if you wish use column headers.
One Column Example: |
For Excel files all data can be included in a single column. Use commas to separate the data items.
The format is Street Address, City, State and Zip (The Zip code is optional)
Here is an example showing how your data file should look for one column formmating:
|
|
Two Column Example: |
For 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
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 two column formatting:
|
|
Processing Files With Header Rows: |
For files containing header rows, our software supports the following header row values to identify the Street Address column:
- ADDRESS
- ADDRESS1
- ADDRESS 1
- ADDRESS ONE
- STREET ADDRESS
- STREET ADDRESS1
- STREET ADDRESS 1
- STREET ADDRESS ONE
If your file contains both street address AND secondary address columns, they must be in squential order
with secondary address information placed directly after street address.
|
|
Our software supports the following header row values to identify the Secondary Address column:
One of the header row values above is required to first identify the main street address
- ADDRESS2
- ADDRESS 2
- ADDRESS TWO
- STREET2
- STREET 2
- STREET TWO
- STREET ADDRESS2
- STREET ADDRESS 2
- STREET ADDRESS TWO
A 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"
|