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

    • Variable Data Template and Info

      Click here for our address list template To print variable date we'll need these things.  A normal print ready file with all the text and designs you'd like printed except the variable data A file that shows where you want the variable data placed. ...

    • 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 ...

    • Notes about our Perfect Binding Style Book Template

      Here are some notes about the settings we put in and the reference layer we have on our templates: Reference Layer - Shows how artwork will be affected by the spine of the book. Imagine looking at a softcover book when you open it up and look at the ...

    • Schedule a Visit to Nonstop Printing

      Thanks so much for learning more about us!  It's best to set an appointment so that we can be a bit more prepared for your visit. You may drop in to get the conversation going about your project, but we don't have dedicated people to manage walk in ...