Loading
Is your account outage-proof?

Extract Addresses

This tool finds, extracts, and verifies addresses in text (try sample text). To use the API, see the documentation.

Pasting text...
(may find more addresses, but uses more lookups)
(maintain congruent input/output lines)
Extracted what looks like 0 addresses
Switch to tab output Switch to card view
Only the first 10 matches are shown here. Switch to tab output for everything.

SmartyList US: Web Interface

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

Step 1:  I want to

Pasting text, please wait...

Step 2:  Paste your list below. (Make sure it is formatted correctly.)

Please leave this window open during processing.     Abort

Step 3:Process My List



Step 4:  After the output appears, click here to copy it, then paste back into your spreadsheet

Help

What does all that data mean?

If you need help understanding the many SmartyList output fields, please see either Address List Output Fields or ZIP Code List 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 TextWrangler 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 TextWrangler 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.

You don't have an active subscription...

You'll need to purchase a subscription to process lists.

SmartyList International: Web Interface

Pasting text, please wait...
Step 1: Paste your list below. (Make sure it is formatted correctly.)
Please leave this window open during processing.     Abort


Step 2: Enable geocoding if you would like these addresses to be geocoded
On
Off

Step 3: Process My List



Step 4: Click here to copy it, then paste back into your spreadsheet


Help

  • My browser crashed and I lost my processed list. Click here to load the previously processed list.
  • What kind of file can I use?
  • Output Fields. If you need help understanding the data that we give back, take a look at the docs for output.
  • Additional Data. Any data that you submit (such as name or phone number) will also be included in the output.
    NOTE: Your data will be on the left; ours will follow on the right.

US Lookup Tool




This will only submit 1 request as POST (acts like a GET).

Input Fields


Need help?




Response






International Lookup Tool



This will only submit 1 request as POST (acts like a GET).

Input Fields


Need help?



Response






Website Keys - Only for client-side code (typically mobile apps, web pages, or desktop applications)

Website Key (for website use)Host    (examples: yoursite.com, www.yoursite.com, *.yoursite.com, 122.34.76.2)Created
Create New Key

Secret Keys - Only for server-side code. Do not expose these credentials.

LabelAuth IDAuth Token (for all non-website use)  url-encodeActivatedCreatedDelete

Your Subscription

StatusPlanUsageStartEnd
Auto-Renew
*** The NEXT subscription begins immediately when the CURRENT one is used up or expires, whichever comes first. (Huh?)

Receipts

When you make a credit card purchase, receipts are sent automatically and immediately to every email address listed in your account. If you need us to resend a receipt, please contact customer support.

Credit Cards

Card NetworkMasked NumberExpiration DatePrimaryRemove

New Card

Card Information

Cardholder Name:
Card Number:
Expiration Date:
/
Security Code / CVV:
Security Code Help

Billing Address

Country:
Billing Address:
City:
State:
Postal Code:

Your Info

First name:
Last name:
Position:
Company:
Web site:
Phone number:

Change Username

Email address:

Change Password

Please choose a password you do not use on any other site.

Current password:
New password:
Password again:

Account Contacts

More contacts can be added to your account to receive service and billing notifications. Adding an account contact does not grant the contact login rights.

Add a new contact below: (fields with * are required)







Your Contacts: