DEV Community

Label Peel
Label Peel

Posted on

Printing address labels for holiday cards from a spreadsheet

Holiday cards are a list problem more than a printing problem. If each household is one row, the addresses are current, and you test one page on plain paper, the labels are the easy part.

Disclosure: I make LabelPeel, so I'm not neutral. Every step below also works with other tools, and the tips apply whichever one you pick.

Collect the addresses, one row per card

Start a spreadsheet in Google Sheets or Excel. You want one heading row and one row for each envelope, not one row for each person who lives at the house.

Useful columns:

  • Name — the line on the envelope, such as The Smith Family, or Mr. and Mrs. John Smith
  • Address, and Address 2 for an apartment or unit
  • City, State, ZIP
  • Country — fill this in for international cards; leave it blank for domestic ones
  • A notes column for a move, a "skip this year," or a photo card

Put each part of the address in its own column. A whole address in one cell is hard to rearrange later. Format the ZIP or postal-code column as Plain text (Text in Excel) before you type or paste codes, so 01234 stays 01234 and alphanumeric codes are not "corrected."

If last year's list is still around, copy it to a new file and walk down the rows. Ask people who have moved to confirm the new address before you print. Keep the file; next year you only add, remove, and correct.

Clean duplicates and households

This step prevents two cards to the same house, or a card meant for a whole family going to only one person.

  • Merge people who share an address into one row. The name column is the greeting, not a contact database: The Rivera Family is often clearer on a card than two identical addresses with different first names.
  • Delete true duplicates. Sort by address or by last name and look for the same street twice.
  • Delete blank rows, which can produce blank labels, and unmerge any merged cells, which copy badly.
  • For international mail, put the country on the last line of the label. An empty Country cell simply leaves that line out, which is what you want on a domestic envelope. Longer foreign addresses may need a wider sheet, covered below.
  • Keep postal codes as text, including leading zeros and codes that mix letters and numbers.

Sort the list in an order you can check, such as by last name or by postal code, before you print.

Choose the label sheets

Read the code printed on the pack, and match the paper size to your printer.

  • US Letter, recipient addresses: Avery® 5160 is the usual choice: 1" × 2⅝", 30 labels per sheet, 3 across and 10 down.
  • A4, recipient addresses: sheets whose codes start with L, such as L7160 (63.5 × 38.1 mm, 21 labels per sheet, 3 across and 7 down).
  • Return addresses: a smaller sheet such as Avery® 5167 (½" × 1¾", 80 labels per sheet) for the back flap of the envelope, or the top-left corner on the front.
  • Long names or international lines that feel cramped on 5160: a wider address sheet such as 5161 or 5162.

If the pack is from another brand, many print the matching Avery® code. For anything else, a custom size with the measurements from the pack will do. Buy one box and test it before you stock up.

Preview, then test-print

Copy the list including the heading row, or save a spreadsheet or CSV, and load it into a label tool. In LabelPeel, paste the rows or drop in the file, then type the sheet code from the pack. It guesses which columns belong on the label; you can tick or untick them, or type your own wording with placeholders such as {Name} and {Address}. Include the Country column when the list has international rows. Click a label if you need to fix a typo.

Check that the longest name and the longest address fit in the preview.

To be clear about accounts: previewing is free. Printing, or downloading the PDF, needs a free LabelPeel account. The account is free while the tool is in beta, and no card is needed.

Print one page on plain paper first, with the same settings you will use for the real sheets. Hold it against a label sheet in front of a window or a lamp. If the text sits in the wrong place, you have lost a sheet of paper, not a sheet of labels.

Printer settings that matter:

  • Scale at 100%, or "Actual size." Turn off "Fit to page" and "Shrink to fit." This is the usual cause of labels drifting down the page.
  • Paper size: Letter for US sheets, A4 for the L-codes.
  • If the page is slightly off, use a small nudge if your tool has one, rather than rescaling.
  • On a half-used sheet, start at the first free label so the rest of the sheet is not wasted.

Then print on the real sheet. Let the ink dry for a few minutes before you peel anything, and check that the stock matches your printer (inkjet or laser).

Print the return-address labels on the same day, in the same font, so the two labels look like a set. Type the return address once and print that same text on every label of the smaller sheet.

Timing

The list is what takes time, not the printer. Start early enough to confirm moved addresses and to run a test page. A short list can be cleaned in an evening; a long one needs more than one sitting. Once the test page lines up, print the rest and keep the spreadsheet for next year.

Avery® is a registered trademark of Avery Products Corporation. This article is not affiliated with or endorsed by Avery.

Top comments (0)