Address List Template

Getting Started

LetterStream does not provide mailing lists. However, this guide helps you build and upload your own mailing list in a format compatible with LetterStream's system. A properly formatted CSV file ensures smooth importing and accurate mailing.

In This Article

• Downloading a Sample Address File
• File Format Requirements
• Required Columns
• Address Entry Tips
• Name Formatting Best Practices

Downloading a Sample Address File

Use the sample CSV template below as a starting point to format your own list:

sample-address-file.csv

File Format Requirements

• Your list must be saved as a .CSV file (Comma-Separated Values) from Excel
• Use Excel’s Save As function and select CSV (Comma delimited) (*.csv)
• Quotes (" ) should wrap text fields, especially where commas exist in the values

Required Columns

The header row (row one) of your file should include these columns in this order:

Required Columns:

• Name
• Address1
• City
• State (use 2-letter USPS abbreviation, e.g., CA, NY)
• Zip

Optional Columns:

• Name2
• Company
• Address2

You may include additional columns, but they can be ignored during the upload process.

Address Entry Tips

• One recipient per row

  Each address must be a separate row. If a recipient has multiple addresses, list each one on its own line.

• Avoid duplicated data

  Do not repeat suite or unit numbers in both Address1 and Address2 fields.

Name Formatting Best Practices

1. Enter names in order:
   • Provide recipient addresses in the FullName field as the first name first, then the last name.
   • If separating name components, use two separate columns labeled FirstName and LastName.
2. Two name columns max
   • You can include both Name and Name2 if needed (e.g., for spouses or joint recipients)

Note: Keep in mind, we are not aware of delays or undeliverable mail if the last name is printed before the first on your mailing piece, we simply recommend putting the first name first.