Printable Christmas address labels from your card list
If your Christmas card list lives in a spreadsheet, you don't have to write out every envelope. Load the list from Excel, Google Sheets or a CSV file into a festive Avery 5160 sheet, and each of its 30 labels takes one household. Print it on any home printer that takes US Letter. There is a bigger 5163 sheet and a 5167 return address sheet too. No signup.
How it works
Your Christmas card list, one household per sticker
A Christmas card list with five households, from The Alvarez Family to Uncle Marcus, fills a festive label sheet one sticker at a time. Each sticker has a small tree and star beside the name. The Grandma Rose sticker is peeled off and lands on a red card envelope tied with a gold ribbon.
Address your Christmas cards
Open the Christmas Avery 5160 sheet with a sample card list, then upload your own.
Address your Christmas cards1Examples
Christmas address label examples you can open
These are real renders from the editor. The families and addresses are made up for the examples. Click one and it opens at that Avery size with the sample list loaded, ready for your own.
Each card is a whole US Letter page, the way it comes out of your printer. On the 5160 and 5163 sheets every sticker reads its own row, so one page holds 30 (or 10) different addresses. Five sample households fill the first five stickers; the rest stay blank until your list fills them. The 5167 sheet repeats one return address on all 80 stickers. The fourth card is the same 5160 sheet in plain black type.
2Your card list
Get your Christmas card list ready in a spreadsheet
One household per row, with the column names in the first row. This is the fictional list behind the Christmas sheets:
- Write the Name the way you'd write it on the envelope: "The Alvarez Family", "Grandma Rose".
- Keep city, state and ZIP together in one City column, like the sample. It's one line on the label.
- An apartment number can go at the end of the Street cell. Keep it short so it stays on one line.
If last year's list is in Excel, you can upload the .xlsx as it is. If it's in Google Sheets, download it as CSV (File, Download, Comma-separated values) and upload that. You don't need to publish a list of family addresses to the web.
| Name | Street | City |
|---|---|---|
| The Alvarez Family | 12 Holly Lane | Anytown, ST 12345 |
| Grandma Rose | 3 Mistletoe Court | Springfield, ST 12346 |
| The Okafor Family | 27 Evergreen Road | Riverton, ST 12347 |
| Sam and Priya Shah | 9 Juniper Way | Lakeside, ST 12348 |
| Uncle Marcus | 140 Snowfall Avenue | Hillview, ST 12349 |
3Print the sheet
Print address labels for Christmas cards on an Avery 5160 sheet
The Avery 5160 sheet opens in One sheet mode, where sticker 1 reads row 1 of your list, sticker 2 reads row 2, and so on down the page.
Prefer plain black type? The plain Avery 5160 sheet (the fourth card) works the same way. More on whole sheets, including 5163 and 5164, is on Avery labels from Excel or Google Sheets.
- Open https://app.mylabelmaker.com with the Christmas Avery 5160 sheet. No signup. The five-household sample list is already loaded.
- Click Data, then Upload, and choose your Excel or CSV file. Keep the three columns in this order: Name, Street, City.
- Look over the page. Find the longest name or street. In the Christmas sample that would be "140 Snowfall Avenue". If a line crowds the edge of its sticker, shorten it in your sheet and upload again.
- Stickers past the end of your list stay blank. One sheet holds 30, so if your list is longer, split it into files of 30 rows and load them one at a time.
- Choose This computer in the top bar and click Print. The whole sheet goes to your computer's print dialog. Set copies there: each copy is another full sheet, so leave it at 1 unless you want the same page twice.
4Festive look
Choose a festive look for your address labels
On the Christmas 5160 sheet each sticker has a small green tree and star beside the name. The 5163 sheet is bigger, 4 x 2 in with 10 per Letter sheet, with a green border and a "Season's greetings to" line above the name. Both open with the Christmas card list above, five households on the first five stickers.
To use your own list, click Data and upload it. Keep the columns in the order Name, Street, City: each sticker reads row 1, 2, 3 and so on by column position. Stickers past the end of your list stay blank, decoration and all, so trim the page or print the rest next time.
5Return address
Add a return address on Avery 5167
Your return address is the same on every envelope, so it doesn't need the list. The 5167 card is a festive sheet with a red star: all 80 stickers read the one row in its list, so upload a one-row file with your own name, street and city. Avery 5167 is a small 1.75 x 0.5 in label, 80 per Letter sheet, so keep it to a name and two lines.
The whole 5167 sheet layout is on Avery labels from Excel or Google Sheets. Stick one on the back flap or the top left corner of each envelope, wherever your cards usually carry it.
Christmas address label questions
How do I print Christmas address labels from my card list?
Open the Christmas Avery 5160 sheet, upload your list from Excel or CSV under Data with Name, Street and City columns, check the page and click Print. Each of the 30 stickers takes one row of your list.
Can I use my Google Sheets list?
Yes. Download the sheet as CSV and upload it. The Google Sheet tab also takes a published CSV link, but you don't need to publish family addresses to use the list.
Which Avery labels work for Christmas address labels?
Avery 5160 (30 per Letter sheet) and the larger 5163 (10 per sheet) take your list, one household per sticker. Avery 5167 (80 per sheet) is for one return address repeated. These are US Letter sheets, not A4.
Do I need Word mail merge?
No. The list goes straight into the label in your browser. Each row becomes one address.