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
- Save as CSV File
- Upload to LetterStream
- Optional: Use the Address Book
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.