Bulk Address Validation Tool: Web Interface

With access to our Web Interface, a person with zero programming experience can process lists of addresses 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 up to 500,000 US or international addresses at once. (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

  1. 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 | zipcode

    street 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
    city state
    Anchorage AK
    Birmingham AL
    Montgomery AL
    Little Rock AR
    Flagstaff AZ
    Bakersfield CA
    For International Addresses:
    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
  2. 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).

  3. Go to the page for the Bulk Address Validation Tool Web Interface.
  4. ("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.)
  5. ("Step 2") Click the data box and upload your properly-formatted file.
  6. ("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.)
  7. 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)
  8. 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.
Ready to get started?