How do I print address labels from my Christmas card list?
- Paste the list. One address after another with an empty line between them, or rows copied straight from a spreadsheet.
- Pick the sheet: Avery 5160 (US Letter) or Avery L7160 (A4). Add a small holly, star or tree if you like, and a return address.
- Print at 100 per cent on the label sheet. Every address lands on its own label, in reading order: left to right, then down.
The preview shows the first sheet as it prints. Long lines get smaller type until they fit the label; a line that still does not fit at the smallest readable size is named under the preview, so you can shorten it.
Which label sheets does it print on?
| Sheet | Paper | Labels | Label size | Layout | Same layout sold as |
|---|---|---|---|---|---|
| Avery 5160 | US Letter | 30 | 2⅝ × 1 in | 3 across, 10 down | 5260, 5960, 8160, 18660 |
| Avery L7160 | A4 | 21 | 63.5 × 38.1 mm | 3 across, 7 down | most 21-a-sheet A4 address labels |
The positions come from the published sheet layouts, checked on 1 November 2026: for Avery 5160 a top margin of ½ inch, side margins of 3/16 inch and a 2¾-inch step from column to column; for Avery L7160 a top margin of 15.15 mm, side margins of 7.21 mm and a 66.04 mm step. Both add up exactly to the paper: 8½ × 11 inches and 210 × 297 mm.
How do I paste a list from a spreadsheet?
Copy the rows from Excel, Numbers or Google Sheets and paste them into the box. Each row is one label and each column one line. A row that ends in a two-letter state and a ZIP code joins those with the city into one line, “Springfield, IL 62701”, the way US addresses are written. A first row of column names (Name, Address, City, ZIP …) is skipped.
How do I check the alignment first?
Tick “Draw the label outlines” and print one page on plain paper at 100 per cent. Hold it over a label sheet against a window: the outlines should sit on the labels. If they do not, the print dialog is scaling the page; set it to actual size and try again. Then untick the outlines and print on the labels.
Questions
How do I print address labels for my Christmas cards?
Paste the addresses into the box, one after another with an empty line between them, pick your label sheet (Avery 5160 in the US, Avery L7160 in the UK and Europe) and download the PDF. Every address lands on its own label in reading order: left to right, then down. Print it at 100 per cent, not fit-to-page, so each address sits on its label.
Can I paste my list from Excel or Google Sheets?
Yes. Select the rows in the spreadsheet, copy, and paste them into the box: each row becomes one label and each column one line. When a row ends in a two-letter state and a ZIP code (Springfield | IL | 62701), the city, state and ZIP join into one line the way the post office reads them. A header row with words like Name, Address or City is skipped.
Which label sheets does it print on?
Avery 5160 and Avery L7160, the two standard address sheets. Avery 5160 is US Letter with 30 labels of 2⅝ × 1 inch (3 across, 10 down); sheets sold as 5260, 5960, 8160 and 18660 use the same layout. Avery L7160 is A4 with 21 labels of 63.5 × 38.1 mm (3 across, 7 down), the size most UK and European address labels share.
How do I check the alignment before I use a label sheet?
Tick “Draw the label outlines”, print one page on plain paper at 100 per cent, and hold it over a label sheet against the light. If the outlines sit on the labels, untick it and print on the label sheet. If they are off, the print dialog is scaling: set it to actual size.
I already used some labels on the sheet. Can I start further down?
Yes. Set “Start at label” to the first free label, counted left to right and then down. The preview greys out the labels it skips, and the next sheet starts at label 1 again.
Is anything uploaded from this page?
No. The addresses and the PDF are made inside your browser, and no request carries anything you type. Addresses are kept in this browser so the list is still there next year; the Clear button removes them.