Skip to main content

Bring the neighborhood in this holiday season. To mail before the holidays, approve your design by Tuesday, December 15. See holiday designs

L&B Printing

Help · Addressed Mail

What should be in my mailing list CSV?

Street address and ZIP code are required. Put one address per row, with the column headings in the first row.

Open the list uploaderStep-by-step, with the real screens, below.

In short

Include columns for:

  • Name, when applicable
  • Company, when applicable
  • Street address
  • Address line 2, when applicable
  • City
  • State
  • ZIP code

The uploader recognizes common column names. If it cannot find an address field, it asks you to pick the column. Repeat addresses are removed before your count and price.

Getting it out of a spreadsheet

  1. Put your column headings in the first row.
  2. Remove any title rows, totals or blank rows above the headings.
  3. Upload it as CSV or Excel (.xlsx). Other formats (.xls, .numbers, .ods): save as CSV first.
  4. Upload it — we check it and tell you what we found before you pay.

The columns

ItemNeeded?ExampleHeadings the uploader recognizes
Street addressRequired — a row without one is not counted100 Example StreetStreet Address · Address · Address Line 1 · Addr
ZIP codeRequired — a row without a usable one is not counted08876, or 08876-1234Zip · ZIP Code · Postal Code · Post Code
CityInclude itBranchburgCity · Town
StateInclude it, as the two-letter codeNJState · ST · Province
NameWhen applicableSample RecipientFirst Name · Last Name · Name · Recipient · Contact
Apartment, suite or unitWhen applicableSuite 2Apt / Suite / Unit · Apt · Suite · Unit · Ste · Address Line 2

Before you start

  • Your list in a spreadsheet: one address per row, the column headings in the first row, nothing above them.
  • A street address and a ZIP code for every row. These two columns are required; a row without both is not counted.
  • A way to save or export as CSV. Excel, Numbers and Google Sheets all offer it from the File menu.
  • No sign-in is needed to upload and see the count. Nothing is charged until you pay at checkout.

Step by step

  1. Step 1: Put the headings in the first row

    In your spreadsheet, make the first row the column headings and put one address on each row beneath it. Remove any title, note or blank row above the headings. Head the columns Street Address, Zip, City, State, First Name, Last Name and Apt / Suite / Unit — Street Address and Zip are the two the uploader must find, and it recognizes the common variations of each — or download the example list and replace its rows with yours. Other columns, such as Company, can stay; they do not change the count.

    What you should see. One heading row, then one row per address, with a street address and a ZIP code on every row.

  2. Step 2: Save it as a CSV

    Choose Save As or Export in your spreadsheet program and pick CSV (comma-separated values). An Excel workbook (.xlsx) is read too, from its first sheet; a .numbers or older .xls file is not, so save that one as CSV. The file can be up to 25 MB.

    What you should see. A file whose name ends in .csv or .xlsx.

  3. Step 3: Choose “I have a list” on the Addressed Postcards page

    Under Do you already have the mailing list?, choose I have a list. The uploader appears beneath it. If you would rather start from a file, Download a blank CSV template gives you the headings with two example rows.

    The list step of the Addressed Postcards page: "Do you already have the mailing list?" with "I have a list" selected and "I need a list" beside it, a line explaining that L&B counts the accepted address records, the dashed upload area headed "Upload your mailing list." with the columns it needs beneath, and the "Download a blank CSV template" link.
    1. A: I have a list
    2. B: The upload area: click it, or drop the file on it
    3. C: A blank template with the headings and two example rows
    The list step of the Addressed Postcards page: "Do you already have the mailing list?" with "I have a list" selected and "I need a list" beside it, a line explaining that L&B counts the accepted address records, the dashed upload area headed "Upload your mailing list." with the columns it needs beneath, and the "Download a blank CSV template" link.
    The same list step on a phone: the two choices side by side, the explanation, the upload area and the template link beneath.
    1. A: I have a list
    2. B: The upload area
    3. C: A blank template with the headings and two example rows
    The same list step on a phone: the two choices side by side, the explanation, the upload area and the template link beneath.
    Counts and prices in the screen are an example; yours are calculated live.

    What you should see. The upload area, Upload your mailing list, with the columns it needs written under it.

  4. Step 4: Upload the file and read the count

    Click the upload area and choose your CSV, or drag the file onto it. While the file is read, the area says Reading your list…. The count that follows is the number of rows with a street address and a usable ZIP code. An address that appears more than once is counted once, and the result says how many duplicates were removed.

    After uploading example-mailing-list.csv: the upload area now shows the file name, and a card beneath it says "We found 5 addresses we can mail to." with the columns found — First Name, Last Name, Street Address, Apt / Suite / Unit, City, State, Zip — and an "Upload a different file" link.
    1. A: The file you uploaded
    2. B: How many rows can be mailed
    3. C: The columns found in the file
    After uploading example-mailing-list.csv: the upload area now shows the file name, and a card beneath it says "We found 5 addresses we can mail to." with the columns found — First Name, Last Name, Street Address, Apt / Suite / Unit, City, State, Zip — and an "Upload a different file" link.
    The same result on a phone: the file name in the upload area, then the count and the columns found.
    1. A: The file you uploaded
    2. B: How many rows can be mailed
    3. C: The columns found in the file
    The same result on a phone: the file name in the upload area, then the count and the columns found.
    Counts and prices in the screen are an example; yours are calculated live.

    What you should see. We found … addresses we can mail to, with the columns the uploader found in your file.

  5. Step 5: Read any notes about your file

    If some rows could not be counted, or no State column was found, the result lists it under Please check these notes about your file before checkout. The list is still accepted; the notes say what was left out. To include a skipped row, fix it in the spreadsheet — the note names the row numbers, counting the heading as row 1 — and choose Upload a different file.

    After uploading a list with no State column and two unusable rows: "We found 3 addresses we can mail to.", the columns found, then "Please check these notes about your file before checkout:" with two notes — "2 rows have no street address or no valid ZIP code and were not counted (rows 3, 5)." and "No state column detected."
    1. A: The rows that can be mailed
    2. B: Notes: what was left out, and which rows
    After uploading a list with no State column and two unusable rows: "We found 3 addresses we can mail to.", the columns found, then "Please check these notes about your file before checkout:" with two notes — "2 rows have no street address or no valid ZIP code and were not counted (rows 3, 5)." and "No state column detected."
    The same count and notes on a phone.
    1. A: The rows that can be mailed
    2. B: Notes: what was left out, and which rows
    The same count and notes on a phone.
    Counts and prices in the screen are an example; yours are calculated live.

    What you should see. The count, then the notes. Each note says what it found and, for skipped rows, which rows.

  6. Step 6: Continue: choose the mailing service

    Once the list is counted, the mailing service cards appear. Standard (bulk mail) needs at least 200 addresses; with a smaller list it is unavailable and First Class (stamp) is used, which mails any list size. Your price is shown beneath the service, before you pay.

    The step that follows a counted list: "Choose the mailing service." with two cards. "Standard (bulk mail)" is greyed out with the note "Bulk discount needs 200+ addresses"; "First Class (stamp)" is selected. Each shows its postage for the example list.
    1. A: Standard (bulk mail): unavailable for a five-address list
    2. B: First Class (stamp): selected
    3. C: Why Standard is unavailable
    The step that follows a counted list: "Choose the mailing service." with two cards. "Standard (bulk mail)" is greyed out with the note "Bulk discount needs 200+ addresses"; "First Class (stamp)" is selected. Each shows its postage for the example list.
    The same two service cards stacked on a phone.
    1. A: Standard (bulk mail): unavailable for a five-address list
    2. B: First Class (stamp): selected
    3. C: Why Standard is unavailable
    The same two service cards stacked on a phone.
    Counts and prices in the screen are an example; yours are calculated live.

    What you should see. The service, then Your price: print, addressing, postage and the total. Nothing is charged until you pay at checkout.

If something goes wrong

“We couldn't find a street-address column or a ZIP-code column in the header row. Add them and upload the list again. Nothing was added to your cart.”

The first row has no heading the uploader recognizes as a street address or a ZIP code. Under the message, Or tell us which column is which lets you choose the street-address and ZIP-code columns yourself; choose Use These Columns to send the list. Or name the two columns as in the table (Street Address, Zip) and upload again. When the message names only the street-address column, or only the ZIP-code column, the other one was found.

“We couldn't read that spreadsheet. Save it as CSV from Excel: File › Save As › CSV, then upload the .csv file.”

The file is a .numbers, .xls or other spreadsheet the uploader cannot open, or an .xlsx file it could not read. Open it in your spreadsheet program, save or export it as CSV, and upload the .csv file.

“… rows have no street address or no valid ZIP code and were not counted (rows …).” — an amber note beneath a count

The list was accepted without those rows; the count above the note is the quantity the mailing is priced on. The row numbers count the heading as row 1, as your spreadsheet does. A ZIP needs 3 to 5 digits, with an optional 4-digit extension; letters or spaces make it unusable, while a ZIP that lost its leading zero in a spreadsheet (8876) is still counted. Fix the rows and choose Upload a different file to include them.

“… rows have no street address or no valid ZIP code and were not counted (rows …). Nothing was added to your cart.” — a red message, with no count

No row had both a street address and a usable ZIP code, so the list was not accepted and there is no count. The row numbers count the heading as row 1, as your spreadsheet does. Go down the two columns row by row: the street address cannot be blank, and a ZIP needs 3 to 5 digits with an optional 4-digit extension — letters or spaces make it unusable. Save as CSV, then click the upload area again and choose the fixed file.

After uploading a list whose two rows each lack a street address or a usable ZIP code: the upload area shows all-rows-bad.csv, and the red message beneath it says "2 rows have no street address or no valid ZIP code and were not counted (rows 2, 3). Nothing was added to your cart." — no count, and no Upload a different file link.
  1. A: The file you uploaded
  2. B: Every row was unusable, so the list was not accepted
After uploading a list whose two rows each lack a street address or a usable ZIP code: the upload area shows all-rows-bad.csv, and the red message beneath it says "2 rows have no street address or no valid ZIP code and were not counted (rows 2, 3). Nothing was added to your cart." — no count, and no Upload a different file link.
The same rejection on a phone: the file name in the upload area and the red message beneath it.
  1. A: The file you uploaded
  2. B: Every row was unusable, so the list was not accepted
The same rejection on a phone: the file name in the upload area and the red message beneath it.
Counts and prices in the screen are an example; yours are calculated live.
“No state column detected.”

The list was accepted. Add a State column with the two-letter code (NJ) if you can: checkout uses it to work out sales tax on the mailing, and without it the whole mailing is treated as taxable.

Why am I charged sales tax?
“We found no addresses we can mail to. Export your list as a CSV with a header row, a street-address column and a ZIP-code column.”

The file is empty, or has only the heading row. Check that the addresses are on the rows beneath the headings, save as CSV and upload again.

“Could not read that file. Please upload a CSV (.csv).”

The file could not be read as text. Export it from your spreadsheet program as CSV and upload the .csv file.

“File too large (max 25MB).”

Remove columns the mailing does not need, such as notes or purchase history, and save again. A list that large is also a mailing worth planning with L&B first.

Plan with an Expert — Free
“Too many uploads. Please wait a moment and try again.”

Wait a minute, then upload once more.

“Upload failed. Please try again, or call us at 908.232.7770.”

The connection dropped before the file arrived. Check that you are online and upload again. If it keeps failing, call L&B.

“Mailing-list upload is temporarily unavailable. Please try again shortly.”

Try again in a few minutes. If it persists, contact L&B.

Contact L&B
“This design is already on an order and can no longer be changed. Start a new design to make changes.”

This mailing has already been ordered, so its list is locked. Reload the Addressed Postcards page to start a new mailing, or contact L&B about the order.

“Missing file or design_id.” or “Invalid design_id.”

The page lost track of the mailing it was building. Reload the Addressed Postcards page and upload the list again.

Next