Documentation

 

SmartyList: Web Interface

With access to our SmartyList Web Interface, a person with zero programming experience can process lists of addresses in only a few minutes. Using a simple copy and paste 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 50,000 US addresses or 5,000 international addresses at once. (For longer lists of US addresses, try our SmartyList Command-Line Interface.) Additionally, the SmartyList Web Interface has a US ZIP Code mode in which you can put in US ZIP Codes and get back all the corresponding cities and states, or put in cities and states and get back all the matching US ZIP Codes.

You may want to set up a free account to try out your list.

Contents

  1. Quick-Start Video
  2. Step-by-Step Instructions
  3. Help

Quick-Start Video

SmartyStreets - SmartyList: Web Interface (short version) from SmartyStreets on Vimeo.

Step-by-Step Instructions

  1. Compile your data in one of these file formats: Excel, CSV, or tab-delimited text.
  2. Organize your data into columns, using one of the combinations shown below. 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)
    Note: An additional column for secondary (apt/ste/etc.) can be added to any of the first three examples above. (e.g., street | secondary | city | state | zipcode)
    IDBusinessstreetcitystatezipcode
    1Wendy's Anchorage11310 Old Seward HighwayAnchorageAK99515
    2Wendy's Wasilla701 West Parks HwyWasillaAK99654
    3Wendy's - Birmingham3211 Edwards Lake PkwyBirminghamAL35235
    4Wendy's - Montgomery2545 Congressman William L Dickerson DrMontgomeryAL
    5Wendy's - Tuscaloosa5018 Oscar Baxter DriveTuscaloosaAL35405
    6Wendy's - Bentonville814 S Walton BlvdBentonvilleAR72712
    7Wendy's - Little Rock11219 N Rodney Parham RoadLittle RockAR72212
    8Wendy's - Flagstaff4507 North US Highway 89FlagstaffAZ86004
    For ZIP Codes: city | state | zipcode
    city | state
    zipcode
    citystatezipcode
    AnchorageAK
    WasillaAK
    BirminghamAL
    MontgomeryAL
    TuscaloosaAL
    BentonvilleAR
    Little RockAR
    FlagstaffAZ
    PhoenixAZ
    YumaAZ
    BakersfieldCA
    IrvineCA
    Los AngelesCA
    SalinasCA
    For International Addresses:
    country | address1 | locality | administrative_area
    country | address1 | postal_code
    country | freeform
    countryaddress1localityadministrative_areapostal_code
    AUS200 River TerraceKangaroo PointQueensland4169
    JPN46 Hirao Johsui MachiChuo-ku Fukuoka-ShiFukuoka810-0029
    DEUHainichener Strasse 64FreibergSachsen
    PYF21 Allée Pierre LotiPapeete98714
    RUSул. Фурштатская, д. 13Петербург191028
    JPNきみ野 6-1-8大和市神奈川県242-0001
  3. Select the columns that contain your address data, including the column titles themselves. Optionally, you can include columns that contain non-address data (like ID number or business name). All the data that is pasted into the tool will always be returned untouched as part of the output. (If you do include columns of non-address data, be sure to give those columns non-address titles.)
  4. Once you have selected the data, press Control-C (Command-C on a Mac) to copy the data.
  5. Go to the page for the SmartyList Web Interface.
  6. ("Step 1") Leave the drop-down menu set to "validate addresses" unless you want to choose the ZIP Code mode. There is a big difference between the two types of output.
  7. ("Step 2") Click in the box, then press Control-V (Command-V on a Mac) to paste in your input data.
  8. ("Step 3") Press the pretty button.
  9. ("Step 4") Once processing is complete, click "here." (Output data will magically be copied to your clipboard.)
  10. Go back to your spreadsheet and click in the cell that you want to become the top-left cell of the output data. You can choose to paste on top of your original data, or off to the right in the same sheet, or in a new, blank sheet.
  11. Press Control-V (or Command-V) and voila! Your original data is on the left; ours is on the right, with column titles in brackets.

Help

What does all that data mean?

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

Please see the "Help" section at the bottom of the SmartyList Web Interface page.

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.