How To Create And Upload An Address List

Getting Started

Uploading your recipient list to LetterStream is quick and simple. You just need to prepare an address file in Excel and save it in CSV format. Below are the steps to help you get started.


In This Article


Prepare Your Address List in Excel

  • Download and open the provided CSV file template or start your own spreadsheet.
  • Include the following headers in the first row:
    • First Name, Last Name, Address, Address2, City, State, Zip
  • You can label them differently—LetterStream lets you map your columns during upload.
  • Enter your recipients' data row by row beneath each header.

Save as CSV File

Once your list is complete:

  • In Excel, click File → Save As.
  • In the "Save as type" dropdown, choose CSV (Comma delimited) (.csv).
  • Save the file—this is the format required for uploading.

Upload to LetterStream

During your mailing setup:

  • When prompted to enter a recipient list, select the My Mailing List (CSV) option.
  • Upload your saved CSV file.
  • Map your columns to the correct fields when prompted (e.g., map your column labeled "Street Address" to "Address").
  • Continue with your job setup.

Optional: Use the Address Book Instead

If you send to only a few addresses, you can skip the CSV upload altogether:

  • Add addresses one by one in the Address Book within your account.
  • Use saved addresses for future mailings with just a few clicks.

Still need help? Contact Us Contact Us