Address List / Farm List / Spreadsheet Template and Information

Address List / Farm List / Spreadsheet Template and Information

Click here for our address list template

Notes about our template

  • We only use CSV files for addressing since csv files removes erroneous formatting. Check your CSV file before sending it to us as extra returns or spreadsheets will not show up correctly.
  • We have extra fields since you can use this template to upload a large address list for UPS/ Fedex/ USPS package shipping as well.
  • If you'd like us to use a specific font, please send it along with your list. 

Recommendations

  • If you want to see a postcard/envelope shipped to your address, put your address in your address list.
  • If you're using a file you have already, convert it to CSV before sending it to us so you can make sure your addresses will load properly. XLS files incorrectly formatted will cause delays. Nonstop Printing does not fix database.
  • If you'd like us to use a specific font, please send it along with your list. 
  • Make sure you have room on your mailing piece for an address. Click for usps spacing requirements.

Explaining the columns in our template

  • Name / Company - Required. Use the name if no company is listed.
  • Attention - Optional. Typically used if Company column is used.
  • Phone - Optional 
  • Address - Required. Place street address here.
  • Address 2 - Optional. This can be used for suite number etc.
  • City - Required
  • State - Required
  • Zip Code - Required
  • R - Optional. This is used to determine if the address is a residential address vs a commercial address. If the address listed is a residential address, place a capital "Y" in the column. This helps determine a more accurate cost for shipping packages as it costs more to ship to a residential address.
  • Email - Optional. Used for shipping fedex packages.
    • Related Articles

    • Guide to USPS Processing Acknowledgement Form (PAF)

      What is a PAF? The PAF (Processing Acknowledgement Form) is required by USPS to verify the ower of mailing address lists. This is the USPS way to track where mail spam is coming from if needed. What do I need to do to submit this? Nonstop Printing ...
    • Mailing Postcard Challenges

      Mail-piece smudging and scratching The smudge you're seeing is from the mail sorting machines. Here's a picture of ours as well (we send one to ourselves). If you look at any mail piece, you'll notice they all have a smudge around the same area on ...
    • How to set up cover files using Nonstop Templates

      Your PDF should look like this when you send it to us. If you followed the tutorial below then your final file should have the same ability and items that you see below. We can do this step for you but if you want more control over your art and a ...
    • How to set up cover files using Nonstop Templates

      This guide is for use during Phase 2 of your file process with us. It's long but if you just go through it step by step, it'll take you about 10 minutes to complete this portion and you'll have the most design and quality control this way. Click here ...
    • Visit Nonstop Printing

      Visiting Hours If you're looking to drop by for a quick question or two it'd be best to visit from Monday-Friday 10:30am-5:00pm. This is when our team is fully staffed and our Customer Service Representatives can help with what questions or concerns ...