Spreadsheet Help



Formatting your spreadsheet

You can download the spreadsheet (.csv) template by clicking here or on the button below:

Download Template

This template can be opened and edited using Microsoft Excel. You may type or paste your contacts into the template, or you may just reformat an existing spreadsheet based on the template or instructions below.

There should only be three columns in your spreadsheet, with the headers:

Paperless Post - Headers

Be sure that the header cells do not have any spaces and that the first letter of each word is capitalized.

Once you've typed in your contacts, the spreadsheet must be saved with the extension ".csv" (.txt, .xls, and .xlsx will not work). You can do this in Excel by going to Save As and selecting CSV, Comma Separated Values, or Comma Delimited from the "Format" drop-down menu:

Paperless Post - CSV

Click to enlarge.

Uploading your spreadsheet

To your Address Book:

  1. Navigate to the Paperless Post Address Book interface by going to your account settings at the top right corner of your screen. You will either see your name or your email address here. You can hover your mouse over this menu to see "Address Book" in your drop down menu.
  2. At the top of the page, click "Add New Contacts."
  3. On the left side of the page, click "Add from spreadsheet (.csv)."
  4. Click the "Choose File" button, navigate to where you saved your .csv file, and click "Upload Spreadsheet." This will port the contents of the entire spreadsheet to your Address Book unless you are notified otherwise.

To your Guest/Recipient List:

  1. Navigate to the Delivery page of your mailing (from the Drafts folder of your Post Box, use the menu to the right of your mailing you wish to send out to choose "Go to Delivery." If this option isn't available, you must finish filling out the required information on the Details page - click "Edit the Details").
  2. On the left side of the page, click "Add from spreadsheet (.csv)."
  3. Click the "Choose File" button, navigate to where you saved your .csv file, and click "Upload Spreadsheet." This will port the contents of the entire spreadsheet to your Guest/Recipient List unless you are notified otherwise. You can upload a spreadsheet of up to 5000 recipients at one time.

Couple/family names and salutations

To add a couple/family name to your spreadsheet, split the name up between the First and Last columns however you'd like. See image below for examples.

Paperless Post - Couples, families, salutations

Duplicate or invalid email addresses

The site will automatically de-duplicate your spreadsheet. Any instances of repeat email addresses will be pulled out of the spreadsheet and you'll be asked to choose one to re-upload. Invalid email addresses (e.g., "robertfrost@gmail.cm") will also be pulled out of your spreadsheet and you'll be asked to edit them on the site and re-upload.

Spreadsheet Video Tutorial

Watch this tutorial to learn how to format your spreadsheet.

Formatting correctly is important in order to:

  • Upload the spreadsheet to Paperless Post
  • To make sure you are addressing the envelopes exactly how you would like them to look