Important Notice Register Sign In

Upload Your Customer List

Step 1 - Upload Your File 

It's easy! Choose any Excel (xlsx only), csv, or delimited text file containing your addressed list and add it to the box below. You can drag and drop the file into the box below or just click it to browse the files on your computer.

Once you upload your custom list, we will validate it.

 
File Requirements
  • Do not include commas within your data fields. For example: "John, Q" for the First Name. This will cause issues with CSV and TXT files.
  • xlsx, csv, or txt files are accepted
  • Text and CSV files must be comma delimited
  • Worksheet name in xlsx should not contain special characters
  • Place apartment, suite, and lot numbers in a Address 2 column. USPS will not recognize that as a valid street address.
  • File size cannot exceed 4MB
  • Download a sample Excel (.xlsx) file.
Need Help?

Have questions about how to use this? Questions about the results? No worries - please feel free to ask for help!

 FAQ's

 Call Us 888-748-5121

 support@pbdirectmarketing.com

 

Step 2 - Identify Your Fields

Great! Now identify each column for the file you uploaded. Your file must contain these required columns: First Name, Last Name, Address, City, State, and Zip Code. Additional columns such as Address 2 and Company Name are optional. Additionally you may have a column named Company Name or Full Name in place of the First Name and Last Name columns.

Shown below is a preview of your data file which contains the first 10 rows of data.

 

 

Results Summary

Results Quantity Description
Detected Addresses Addresses detected in your file prior to USPS validation
Valid Addresses Addresses that we can mail to
Invalid Addresses
Addresses invalid for the following reasons
  • Invalid addresses
  • Missing secondary number
  • Unconfirmed secondary address
  • Vacant address

 

 

 Total Certified Prospects

 
Name and save your list.

When you are ready, please provide a name for your list and click Save & Continue.

Save & Continue
Need Help?

Have questions about how to use this? Questions about the results? No worries - please feel free to ask for help!

 FAQ's

 Call Us 888-748-5121

 support@pbdirectmarketing.com