LineUp Labels Open the editor

Christmas cards · Excel, Google Sheets, CSV

Free Christmas card list template that prints your labels

One row per household, with columns for the cards you sent last year, send this year and get back. Download it for Excel or as a CSV file, fill it in, then paste the rows marked Yes below to print the address labels.

Print labels from it

  • No upload. No account.
  • ZIP codes keep their zeros
  • Labels from the same list
christmas-card-list-2026.xlsx NAME ON ENVELOPEZIPSENT 2025SEND 2026 2The Harper Family05401YesYes3Aunt Carol & Uncle Jim45409YesYes4Dr. Priya Raman02138YesYes5The Castillos85716YesNo6Ben & Maya Feld07030Yes7Mrs. Edith Lowe04101YesYes COPY THEYES ROWS The Harper Family12 Juniper LnBurlington, VT 05401Aunt Carol & Uncle Jim340 Sycamore DrDayton, OH 45409Dr. Priya Raman27 Hawthorne St, Apt 4CCambridge, MA 02138Ben & Maya Feld14 Orchard StHoboken, NJ 07030Mrs. Edith Lowe6 Wharf StPortland, ME 04101Sam Whitaker & Jordan Lee2200 Larimer St, Unit 512Denver, CO 80205The Moreau Family88 rue des ÉrablesMontréal, QC H2Y 1H5Canada

The template

Twelve columns: seven for the envelope, five for you.

Eight made-up households show how each one is filled in. Delete them, add yours, and keep the file for next year.

  1. AName on envelopeLine 1, in bold
  2. BStreetLine 2
  3. CApt / UnitLine 2, after a comma
  4. DCityLine 3
  5. EStateLine 3
  6. FZIPLine 3 · text, keeps its 0
  7. GCountryLine 4, outside the US
  8. HGroupFamily, work, church…
  9. ISent 2025Last year's cards
  10. JSend 2026Who gets one: Yes or No
  11. KReceived 2026Cards that came back
  12. LNotesMoves, news, reminders

Prints on the labelStays in your list, never printed

Excel

The workbook (.xlsx)

Opens with the header row frozen. The ZIP column is text, so a ZIP you type keeps its zero: 05401, not 5401.

Google Sheets

The .xlsx, imported

Open a sheet, click File > Import, choose the .xlsx and pick Create new spreadsheet. To print, copy the cells back here: labels from Google Sheets.

Google's steps

Anything else

Plain text (.csv)

Plain text for Numbers or an address book. Excel drops the zero a CSV's ZIP starts with; the labels put it back for US addresses.

Microsoft on leading zeros

Both files are made in your browser. Nothing is uploaded.

Do it here

Your Yes rows, ready to print.

Copy the header and the rows marked Yes under Send 2026 and paste them here, or open the whole file. The sample is the template's own seven Yes rows.

Cells copied from Excel, Google Sheets or Numbers, header row included, or addresses with a blank line between them.

The number on your box

Open the full editor

The sheet shows the sample: the template's 7 Yes rows. Paste your list or open a file, and it shows yours.

Your list stays on this device. Nothing is uploaded.

The Harper Family12 Juniper LnBurlington, VT 05401Aunt Carol & Uncle Jim340 Sycamore DrDayton, OH 45409Dr. Priya Raman27 Hawthorne St, Apt 4CCambridge, MA 02138Ben & Maya Feld14 Orchard StHoboken, NJ 07030Mrs. Edith Lowe6 Wharf StPortland, ME 04101Sam Whitaker & Jordan Lee2200 Larimer St, Unit 512Denver, CO 80205The Moreau Family88 rue des ÉrablesMontréal, QC H2Y 1H5Canada
Sample list · 7 labels on 5160

Worked example

Five rows in, four labels out.

The No row stays in your list and off the sheet, and nothing from Notes or the year columns prints.

In your spreadsheet

christmas-card-list-2026.xlsx

Name on envelopeStreetApt / UnitCityStateZIPSend 2026Notes
2The Harper Family12 Juniper LnBurlingtonVT05401YesBaby Rose arrived in May
3Aunt Carol & Uncle Jim340 Sycamore DrDaytonOH45409Yes
4Dr. Priya Raman27 Hawthorne StApt 4CCambridgeMA02138Yes
5The Castillos905 Mesquite LnTucsonAZ85716NoMoved in July: ask for the new address
6Ben & Maya Feld14 Orchard StHobokenNJ07030YesNew this year, from book club
On the 5160 sheet, as listed
  1. The Harper Family12 Juniper LnBurlington, VT 05401
  2. Aunt Carol & Uncle Jim340 Sycamore DrDayton, OH 45409
  3. Dr. Priya Raman27 Hawthorne St, Apt 4CCambridge, MA 02138
  4. Ben & Maya Feld14 Orchard StHoboken, NJ 07030
  • 05401 keeps its zero: the template's ZIP column is text.
  • No under Send 2026: the Castillos stay in the list and off the sheet.
  • Apt 4C joins the street: 27 Hawthorne St, Apt 4C.
  • Notes and the year columns never print.

From a blank list to labels in four steps.

  1. Download the template

    The .xlsx for Excel, or the CSV for anything else. In Google Sheets, import the .xlsx.

  2. Fill in one row per household

    The name as it goes on the envelope, then the address. Last year's cards go under Sent 2025.

    How to write the names

    “The Harper Family”, “Aunt Carol & Uncle Jim”, “Dr. Priya Raman”: the forms that work, and the plural without an apostrophe, are in the Christmas card guide.

  3. Mark who gets a card

    Yes or No under Send 2026. Notes are yours: a move, a new baby, a card that came back.

  4. Copy the Yes rows into the box

    Paste them in the box above with the header, pick the number on your box and download the PDF. Copying only the Yes rows.

Sheets for a card list

How far a list goes on each sheet, from Avery's own template sizes. The numbers in a row share one layout.

SheetLabel sizePer sheetSame layoutGood for
Avery® 5160 1 × 2-5/8 in 30 8160 · 9160 · 18160 +56 80 households fill three sheets, three lines a label.
Avery® 5161 1 × 4 in 20 8161 · 5261 · 5909 +19 80 households fill four sheets; room for “Sam Whitaker & Jordan Lee”.
Avery® 5162 1-1/3 × 4 in 14 8162 · 5262 · 5522 +8 80 households fill six sheets, with room for a country line.
  • Count the Yes rows, not the whole list: that's how many labels print.
  • Half a sheet left from last year? Set Start at label in the box above to the first free label.
  • Hosting dinner too? The names on your list print as folded cards for the table: Christmas place cards.

Keep the list for next year.

A card list grows a little every December. Four habits keep it right.

  • One row per household

    The name the way it goes on the envelope, then the address. How to write each name.

  • A column for each year

    Next October, add Send 2027 and Received 2027 and keep this year's: you'll see who stopped writing back.

  • Moves and news

    Fix the address when it changes, and say so in Notes. Mark No until a new one comes, as the Castillos' row does.

  • The same family twice

    Two rows for one household print two labels. The full editor marks rows that print the same label and can leave them out.

Print only the ones you're sending.

Copy the header and the rows marked Yes under Send 2026, then paste them in the box above.

In Excel: filter, then copy what shows

  1. Click a cell in the list, then Data > Filter.
  2. Click the arrow on Send 2026, untick (Select All), tick Yes, then OK.
  3. In Excel for Windows, select the list, then Home > Find & Select > Go To Special > Visible cells only > OK.
  4. Copy, and paste above.

Step 3 matters: Excel can copy hidden rows along with the ones you see. Microsoft gives that step for Windows only: on a Mac, sort by Send 2026 instead, as in Google Sheets, so the Yes rows sit together. More on printing labels from Excel.

Microsoft: filter · Microsoft: copy visible cells only

In Google Sheets: sort, then copy the block

  1. Select the list, header row included.
  2. Data > Sort range > Advanced range sorting options, and tick Data has header row.
  3. Sort by Send 2026, Z to A: the Yes rows come first.
  4. Copy the header and the Yes rows, and paste above.

The same sort works in Excel or Numbers.

Google's steps

Three things that keep 5160 labels straight.

Print at actual size

"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.

Feed the right side up

Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.

Test on plain paper

Hold a plain-paper print over a 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.

Questions people ask

Is there a Christmas card list template for Excel?

Yes, free: the .xlsx above. It opens with the header row frozen and the ZIP column set to text, so ZIP codes keep their leading zero.

Can I use it in Google Sheets or Google Docs?

Google Sheets, yes: open a sheet, click File > Import, choose the .xlsx and pick Create new spreadsheet (Google's steps). Google Docs is for documents: keep the list in a sheet and paste its rows here when it's time to print.

Is there a printable Christmas card list?

Print the spreadsheet itself from Excel or Google Sheets to tick names off by hand. What this page prints is the labels: one per household, on Avery® 5160 or a similar sheet.

How do I keep track of cards sent and received?

Yes under Sent 2025 for last year's cards, under Send 2026 for this year's, and under Received 2026 as cards arrive. Next October, add two columns for 2027.

Is there a Christmas card list app?

You don't need one: the list is a spreadsheet you already have, and this page prints its labels with no account and nothing to install.

How do I print address labels from my Christmas card list?

Copy the rows marked Yes, header included, and paste them in the box above, or open the file. Pick the number on your label box, download the PDF and print it at 100%.

Your list is ready? So is the editor.

Open the whole file in the editor to leave rows out one by one, sort by last name or ZIP code, or print copies.

Open the editor with 5160 Calibrate your printer