Peelstack Label Maker docs
All Peelstack Label Maker docs

More3 min read7 sections

Free Christmas card list template for Google Sheets™ and Excel

Keeping track of who gets a card, whose address changed and who sent one back is easier in a spreadsheet than on the back of an envelope. This template is a ready made Christmas card list: one row for each person or household, with columns for the address, whether you sent a card and whether you got one.

Download the template

The .xlsx file has three tabs. "Read me" holds short instructions, "Cards" holds the list and "Several years" tracks cards over time (see below). The three example rows are made up: delete them before you start.

What each column is for

Name lineThe name as it should print on the envelope or label, such as "The Hart Family" or "Grandma Ruth".
Address line 1, Address line 2Street and number, and an apartment or suite if there is one.
City, State, ZIPThe rest of the address. Use Town and Postcode if that is how you write it. The ZIP column is plain text, so codes like 02134 keep their leading zero.
CountryOnly for cards going abroad. Leave it empty for domestic addresses.
HouseholdA short word that groups the rows of one home, such as "Hart". Sort by it to see everyone from the same address together, and use the same Name line on those rows if you want one card for that home.
Card sentChoose Yes when the card is in the post.
Card receivedChoose Yes when theirs arrives, so you can see who to expect next year.
NotesAnything else: a new address, a baby's name, "send a photo card".

Keep track over several years

The "Several years" tab copies the name lines from the "Cards" tab, so you type each name only once. Next to them it has a Sent and a Received column for 2026, 2027 and 2028. Choose Yes in the column for the year, and you can see at a glance who sent you a card each year and who to ask for a new address.

Import it into Google Sheets™

  1. Download the .xlsx file.
  2. Open Google Sheets™ and choose File, Import, Upload, then pick the downloaded file.
  3. Choose Create new spreadsheet and then Import data.
  4. Open the "Cards" tab and delete the three example rows.

Using the .csv file instead? In the import window, switch off "Convert text to numbers, dates, and formulas", so a ZIP code such as 02134 keeps its leading zero.

Open it in Excel

Double click the .xlsx file. The Yes lists for "Card sent" and "Card received" work in Excel too.

Use it year after year

Keep one list and update it in November: fix the addresses that changed, add new friends, clear the two Yes columns and start again.

When the list is ready, print it as address labels or envelopes

Once your addresses are in, you do not have to write them out by hand. Peelstack Label Maker, an add-on for Google Sheets™, prints a list like this one on label sheets such as Avery® 5160 or on envelopes, with one label for each household. The steps are in Christmas card address labels from a Google Sheet™, and you can find the add-on on the Peelstack Label Maker page.

Avery® is a trademark of Avery Products Corporation. Taskivator is not affiliated with Avery.

English