Skip to content
  • There are no suggestions because the search field is empty.

How do I upload my mailing list?

One of the most important aspects of any direct mail campaign, is the recipient data. You can add recipient data to your Stannp account, and to your campaigns, in a number of ways. 

To send your direct mail campaign you'll need a mailing list. You can upload this as part of a campaign setup journey or from your dashboard, at any time. 

Here is a step-by-step guide for uploading your recipient data:


Important points when uploading your data

Single sheet data files

Only single sheet data files can be accepted. CSV is the accepted file type as this only saves as a single sheet document. Stannp.com will convert alternate file types (such as xls or xlsx) to CSV. If your files contains multiple sheets, only sheet one will upload. This means any data or formulas, on others sheets, will not be saved. 

Essential address data

Address line 1 and the zip code must be mapped correctly in order to verify against the USPS database. Addresses that do not match will save as unverified and may incur an additional cost.

Read more about Address Verification here.

Retain zip codes starting with '0'

To ensure Zip codes starting with '0' (zero) are accurately retained in your data file, you should untick the 'Remove leading zeros and convert to a number' (fist image below) option in your Excel settings or convert your cell style from 'General' to 'Text' in the 'Home' tab (second image below)

Screenshot 2025-10-30 152357


View and manage all of your recipient groups in one place

Dash2-How do I upload my mailing list-img1

Click 'View' on your recipient group to view, edit, add to, and manage your recipient data within that group.


Need data?

If you don't have any data yet, you can always buy data from us instead! 

Get in touch


Adding data with custom fields

If your data file contains any custom column headings, these will automatically be uploaded with your data file. You can choose to map these or skip them (click the red 'x').

If you have previously added the custom field, this will appear. Example below: Birthday was previously added and has mapped. 

If the column name is new, you can map this as a 'New Custom Field' in the drop down. Example below: 'Pet name' is new. 

address mapping

When using custom variable fields we always recommend making the variable first in the column settings rather than generating it here.

Read more about creating custom variables here


The final step is to check through your data settings. Give the mailing list a name to easily find later, and decide what you would like us to do with any duplicated entries that could feature in your other recipient groups. If you want to make sure all of your recipients are uploaded, we recommend selecting the "insert all duplicates as unique records" option. 

Data saveOnce uploaded, it will be displayed in your groups. It will give you a breakdown to the verified and not verified recipients along with any international records in your mailing list. 

Select the data when creating a bulk campaign and you're off to go!