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 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.
Compile your data in one of these file formats: Excel, CSV, or tab-delimited text.
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
For ZIP Codes: city | state | zipcode city | state zipcode
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)
200 River Terrace
Hainichener Strasse 64
21 Allée Pierre Loti
ул. Фурштатская, д. 13
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.
Once you have selected the data, press Control-C (Command-C on a Mac) to copy the data.
Go to the page for the SmartyList Web Interface. Note that, when you are not logged in, this tool offers you only 10 free lookups, but when you are logged in, it draws lookups from your account subscription.
("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."
("Step 2") Click in the box, then type Control-V (Command-V on a Mac) to paste in your input data.
("Step 3") Press the pretty button.
("Step 4") After the output appears in the output box, click once in the box to select all the data, then type Control-C (or Command-C) to copy the data to your clipboard.
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.
Type Control-V (or Command-V) and voila! Your original data is on the left; ours is on the right, with column titles in brackets.
I pasted the output data into my spreadsheet, and now it's a mess.
Excel sometimes makes the wrong assumption when deciding whether to delimit your data by tabs or commas. If this happens:
Check if the pasted output data ended up in a single column. If so, go to the Data menu and choose "Text to Columns." In the dialog box that opens, experiment with choosing to delimit by tabs or commas. Getting the delimiter right will usually solve the problem. If the data did not end up in a single column, proceed with the steps below.