The correct format to upload a mailing list file.

Here is a step-by-step article showing how to upload your mailing list file using the correct format.

1. On your computer, open your file and enter your information.

*NOTE: Make sure that you complete the correct format:

  • NO blank columns.
  • NO blank fields.
  • NO blank spaces. 
  • All columns must have information added.

Correct format example: (no empty or blanck spaces on columns/fields)
Screenshot 2024-08-26 at 12.31.23 p.m.


Incorrect format example: (empty or blanck spaces on columns/fields)
Screenshot 2024-08-26 at 12.32.49 p.m.

2. Once you have your file with the correct format, proceed to create your print order by clicking on the print button on the top menu. 

Screenshot 2024-08-26 at 2.06.10 p.m. copy

3. On the print shop window, select the options for your order.  When you get to the "How would you like your product mailed?" section, select the mail to list option. Then click on the button that says "upload your .csv or .xls file" 

Screenshot 2024-08-26 at 2.06.45 p.m. copy

4. A window will pop up, you must make sure that all the columns headers have the correct information (first name-last name-address-city-state-zip). 

Screenshot 2024-08-26 at 2.07.14 p.m.*NOTE: If you encounter with empty columns headers, you must manually add them. 

Screenshot 2024-08-26 at 2.14.03 p.m.

To add them, click on the dropdown arrows to display the headers options on each column like shown below: 
Screenshot 2024-08-26 at 2.45.13 p.m.

Screenshot 2024-08-26 at 2.46.03 p.m.

Screenshot 2024-08-26 at 2.46.13 p.m.

Screenshot 2024-08-26 at 2.46.25 p.m.

Screenshot 2024-08-26 at 2.46.38 p.m.

5. Once you have all the columns headers ready, click on the blue proceed button to continue with your order. 

Screenshot 2024-08-26 at 3.01.46 p.m.