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

My mailing list upload was rejected.

The file usually needs to be a readable CSV with a header row and usable address records.

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

In short

Check these first:

  • Is the file a CSV?
  • Does it have a header row?
  • Is there a street-address column?
  • Is there a ZIP-code column?
  • Are there address rows below the header?

Some issues can produce a warning without rejecting the whole file. Read the message shown by the uploader before changing the data.

If the file still fails, contact L&B rather than repeatedly uploading sensitive recipient data into an unknown state.

What usually causes it

  • The file is a .xls, .numbers or .ods file rather than a CSV or .xlsx.
  • There is no header row, so the columns cannot be identified.
  • Title or summary rows sit above the headings.
  • There is no address column — a list of names and emails cannot be mailed.
  • The file is empty, or every row is blank.

Step by step

  1. Step 1: Read the message under the upload area

    The uploader says what it could not find, and nothing is added to your cart. The message names the column it is missing, says that no row had both a street address and a usable ZIP code, or tells you the file had no addresses it could read. Find it in the list under If something goes wrong for what to change.

    After uploading a CSV with no ZIP column: the upload area shows missing-zip-column.csv, and a red message beneath it says "We couldn’t find a ZIP-code column in the header row. Add it and upload the list again. Nothing was added to your cart."
    1. A: The file you uploaded
    2. B: What the uploader could not find
    After uploading a CSV with no ZIP column: the upload area shows missing-zip-column.csv, and a red message beneath it says "We couldn’t find a ZIP-code column in the header row. Add it and upload the list again. Nothing was added to your cart."
    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: What the uploader could not find
    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.

    What you should see. A red message under the upload area, with your file’s name above it.

  2. Step 2: Check the file type

    The uploader reads a CSV or an Excel workbook (.xlsx). A .numbers, .xls or .pages file is not read: export it as CSV from your spreadsheet program (in Excel: File › Save As › CSV) and upload that.

    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. A file whose name ends in .csv or .xlsx.

  3. Step 3: Check the headings and the rows

    The first row must be the headings, with a street-address column and a ZIP-code column; the addresses go on the rows beneath, each with its street address and a usable ZIP code. A file with only a heading row, or nothing in it, is refused — and so is one in which no row has both.

    After uploading an empty file: the upload area shows empty.csv, and the red message says "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."
    1. A: The file you uploaded
    2. B: No rows could be read
    After uploading an empty file: the upload area shows empty.csv, and the red message says "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 same rejection of an empty file on a phone.
    1. A: The file you uploaded
    2. B: No rows could be read
    The same rejection of an empty file on a phone.
    Counts and prices in the screen are an example; yours are calculated live.

    What you should see. A heading row with Street Address and Zip, and at least one address row with both filled in.

  4. Step 4: Upload the corrected file

    Click the upload area again and choose the fixed CSV. The count replaces the message, and the mailing service step appears beneath it.

    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.

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