Address Validation for Lists

Got a list of addresses to process? We make it fast and simple.



Verify that each address is valid and complete


Convert addresses into proper USPS address format


Easy copy/paste process


45 metadata points for each address


Latitude and longitude coordinates returned for each valid address

Customer Support

Freakishly helpful customer support

Bulk Address Validation Tool Web Interface

For access to the Full Version of the tool Sign Up or Log In

You have lookups currently available. Purchase more here.

Step 2: Paste your list below. Make sure it is formatted correctly. (Here's an example file.)
Step 3: Geocoding (optional)
Step 3: Process My List (The demo is limited to 10 records at a time.)
0/0 records processed
Step 4: After the output appears, click here to copy it, then paste back into your spreadsheet. The output fields don't line up here, but they will in Excel.

* For complete instructions for using this tool, please see the documentation.

Like the demo? Try the real thing.

Sign up for a free plan now

Get 250 lookups for free every month, or upgrade as needed.


What does all that data mean?

If you need help understanding the many SmartyList output fields, please see either US Address Output Fields, US ZIP Code Output Fields, or International Address Output Fields.

My list failed to process.

Check if your input data has line breaks (two lines in the same cell) or quotation marks. These interfere with the tool's ability to sort the data correctly. Here's the solution:

  1. Save your original Excel file in a different file format: "Tab Delimited Text."
  2. Open the new file in a text editor, like Notepad++ for Windows or BBEdit for Mac.
  3. Copy and paste from the text file into our web page, then continue to follow the instructions above.

My browser crashed, and I lost my processed list.

Click here to load the previously processed list.

I pasted the output data into my spreadsheet, and now it's a mess.

Blame Excel. It occasionally forgets how to place tab- or comma-delimited text into cells correctly. If this happens:

  1. Undo the paste that made a mess.
  2. Open a text editor, like Notepad++ for Windows or BBEdit for Mac.
  3. Paste the SmartyStreets output data into a new window of the text editor.
  4. Save the file.
  5. Go back to your Excel spreadsheet and click on the cell where you want to paste the output data.
  6. From the Excel File menu, choose Import.
  7. Specify "Text file" and click Import.
  8. Navigate to your text file, select it, and click on Get Data.
  9. In the Text Import Wizard, choose the default values.
This site uses cookies for analytics, personalized content, and ads. By continuing to browse this site, you agree to this use.
Consuming raw or undercooked cookie dough may increase your risk of foodborne illness.