Bulk Address Validation Tool: Web interface
With access to our Web Interface, a person with zero programming experience can process lists of addresses (either US or international) in only a few minutes. Using a simple file upload process, you can standardize and validate your addresses and enrich them with relevant data like county name, congressional district, latitude, longitude, and more. The tool can process CSV files with up to 500,000 addresses, and it can process Excel files with up to 100,000 addresses. (For longer lists of addresses, try our Command-Line Interface.) Additionally, the Web Interface has a US ZIP Code mode in which you can submit ZIP Codes and get back all the corresponding cities and states, or put in cities and states and get back all the matching ZIP Codes.
You may want to set up a free account to try out your list.
Quick-start video
Step-by-step instructions
-
Organize your data into columns, using one of the combinations shown below. (The more data provided, the
better.) The top row MUST consist of column titles, spelled exactly as you see here.
For US Addresses:
street|city|state|zipcode
street|city|state
street|zipcode
address(entire address in a single column)
If you have secondary information (apartment/suite/etc.) in a separate column, label that column
secondary. Such a column can be added to any of the first three combinations shown above. For example:
street|secondary|city|state|zipcodestreet city state zipcode 11310 Old Seward Highway Anchorage AK 99515 3211 Edwards Lake Pkwy Birmingham AL 11219 N Rodney Parham Road 72212 4507 North US Highway 89 Flagstaff AZ 86004 Still not quite sure? Take a peek at this sample spreadsheet.
For ZIP Codes:
city|state|zipcode
city|state
zipcode
For international addresses:city state Anchorage AK Birmingham AL Montgomery AL Little Rock AR Flagstaff AZ Bakersfield CA
country|address1|locality|administrative_area|postal_code
country|address1|locality|administrative_area
country|address1|postal_code
country|freeform(entire address except country in a single column)country address1 locality administrative_area postal_code AUS 200 River Terrace Kangaroo Point Queensland 4169 DEU Hainichener Strasse 64 Freiberg Sachsen PYF 21 Allée Pierre Loti Papeete 98714 RUS ул. Фурштатская, д. 13 191028 JPN きみ野 6-1-8 大和市 神奈川県 242-0001 -
Save your file in one of these file formats: .xls .xlsx .csv .tsv .psv .txt
Only the first sheet will be processed for Excel files (.xls and .xlsx).
- Go to the page for the Bulk Address Validation Tool web interface.
- ("Step 1") Choose the appropriate item from the drop-down menu. If you want to add ZIP Codes to street addresses, choose "validate US addresses." (Note that, according to the selection you make in this step, the steps below will change a bit. The instructions that immediately follow here assume you have chosen "validate US addresses" in this step.)
- ("Step 2") Click the data box and upload your properly-formatted file.
- ("Step 3") Press the pretty button, then sit back and relax. But don't get too comfy; you won't be waiting for long. (unless you're on 3G, and you should take that up with your IT department.)
- A link will appear below the button from Step 3. When you click it, your squeaky-clean addresses will be downloaded to wherever your browser is configured to place downloads. (Usually this is the appropriately named "Downloads" folder)
- Voila! Open the file and admire the results of your hard work. (OK, even if it wasn't that hard, you might as well be the Barry Allen of address data as far as your stakeholders are concerned!) You will see your original input columns in the file, and then to the right you will see the output columns, with column titles in brackets. If you need help understanding the many output fields, please see either US address output fields, US ZIP Code output fields, or International output Fields.