Batch Address Check
This free Lookup will verify and correct up to 1000 U.S. and Canadian addresses from a spreadsheet. In addition, it can append U.S. Carrier Route, County Name, County FIPS Code and Delivery Point Code. Columns can be delimited with tabs, commas or vertical bars.
|
New Features in Error Field |
|
Vacant Indicator |
An address has been vacant for 90 days or more |
|
Apartment Number Append |
Appends a missing apartment number. Full or Last name field is required. |
|
Suite Number Append |
Appends a missing suite number. Company name field required. |
|
Alternate Delivery |
Indicates a user receives mail via a PO Box |
|
LACS Indicator |
Changes a address from a Rural Route to a city type |
Description:
Copy from 2 to 1000 rows of names, addresses and emails from a spreadsheet to the Input Box. The first row must have Column Data Type names. They indicate the type of data in each column. The acceptable Column Data Types are listed below.
Click on Submit and the results are displayed in a browser table.
Click on Excel and the results are displayed in a spreadsheet.
Click on Text and the results are displayed in a text box.
Click on Clear to clear the screen.
Column Data Types:
|
Address |
Required |
Input |
|
City |
Required |
Input |
|
State |
Required |
Input |
|
Zip |
Required |
Input |
|
Email |
Optional |
Email address for input |
|
First |
Optional |
First name for input. |
|
Last |
Optional |
Last name for input. |
|
Fullname |
Optional |
Combined first and last name for input. |
|
Company |
Optional |
Company or firm name for input. |
|
Address2 |
Optional |
Second line of address, input & output. |
|
Suite |
Optional |
Suite or apartment number, input & output. |
|
Plus4 |
Optional |
Last four digits of the ZIP+4 Code for output. If not used, the plus4 is appended to the Zip column. |
|
Cart |
Optional |
Carrier Route Code (Cart) for append. |
|
County |
Optional |
County name for append. |
|
CountyFips |
Optional |
County FIPS code for append. |
|
Dpc |
Optional |
Delivery Point Code (DPC) with check digit for append. |
It's easy to append data to your addresses. At the end of the first row of your data set, add one or all of the Column Data Names: Cart, County, CountyFips or DPC and the data will be appended to each of the data rows.
Click here and tell us how to improve this program. |