Christmas card list planner spreadsheet Excel is the phrase I typed into Google last November, after I found three cards in a drawer that never got posted. They were written, stamped and sealed. They just never left the house, because my list lived in three places at once: a notebook, a phone note and my head. That year I missed my aunt, a neighbour who always sends us one, and a colleague I had promised a card to. I decided a paper list was not going to cut it again.

I am not someone who sends five cards. My list runs to about 25 households, and every year it grows by one or two names and loses one. Friends move house. Someone gets married and two households become one. A neighbour I used to send to stops sending back, and I have to decide whether to keep them on. A plain list of names cannot hold all of that, so I built a proper file for it: a Christmas Card List Planner Spreadsheet that keeps addresses, sent and received tracking, mailing deadlines, address labels and a card budget in one workbook. It costs $6.99 on Gumroad and works in Google Sheets and Excel.

Christmas Card List Planner Spreadsheet cover showing the evergreen and gold workbook with tabs for Card List, Mailing Deadlines and Budget

My old card list failed in the same four places every year

First, addresses. I had my cousin's old flat in the notebook and her new house in my phone, and I posted to the old flat. The card came back in January. Second, the sent column. I ticked people off in my head and then could not remember who I had actually posted to, so two people got a second card and one got none. Third, the deadlines. I posted the overseas cards on the same day as the local ones, which meant the overseas ones arrived after Christmas. Fourth, the money. I bought cards in three separate trips, never wrote any of it down, and had no idea what the whole thing cost until I added up the receipts in January and wished I had not.

None of that is a big drama on its own. Together it turns a nice tradition into a small mess that follows you into January, and it is the reason I stopped trusting a notebook for this job.

What a card list needs to hold if it is going to work

A name and a tick box is not a system. The file I use now has a Card List tab with the household name, the group they belong to (family, friends, neighbours, work), the full address split into street, town, postcode and country, the card type (normal card, photo card or e-card), a priority, and the delivery type. Delivery type matters more than people think. A card I hand over in person has no deadline at all. A local post needs a few days. One going abroad needs weeks. If the list does not know how each card travels, it cannot tell you when to post it.

The Sent and Received tab is where the year actually happens. It records the date I posted each card, the date one arrived back, and whether I have sent a thank you. It also flags the awkward cases: who sent us a card last year but is not on this year's list, and who I sent to last year without getting one back. That second flag is not about keeping score. It is about deciding, with the facts in front of me, whether a name stays on the list or comes off.

The deadlines work themselves out, which is the whole point

The Mailing Deadlines tab is the one I would miss most if I went back to paper. It takes the delivery type and the Christmas date and works out a send-by date for every household on its own. If a date passes and the card has not gone, the row flags it. I can see at a glance how many days are left for the overseas batch and how many for the local one, instead of guessing and then rushing to the post office on the 22nd with a bag full of cards.

I set the Christmas date once and the year selector handles the rest, so the same file works next year without rebuilding it. I am not a fan of tools that need rebuilding every December. A card list that only works for one Christmas is a chore, not a system.

The budget tab stopped the January surprise

Cards are cheap one at a time and not cheap at all in a pile. The Card Budget tab records the card, the stamp and the postage for each household, then shows planned cost against what I actually spent and what is left. My example file has 25 households filled in, with real numbers, so you can see the budget working before you type a single name of your own. The first year I ran the numbers properly, the total was higher than I had guessed, and that is exactly why the tab exists. I would rather know in November than find out in January.

There is also an Address Changes tab, which is the boring one that saves the most trouble. Old address next to new address, and the date it changed, so next year's cards go to the right door. And a Thank You Log, because cards and small gifts arrive from people I had forgotten to thank, and a short note in January is worth more than a card in December.

Labels straight from the list, no retyping

The Address Labels tab builds the full address for each household from the Card List, ready to print or copy. I used to retype addresses onto envelopes and get one wrong every year. A label built from the same list that holds the address cannot disagree with it, and that is the only reason I trust it. There is a return address box on the sheet too, which matters more than it sounds when a card comes back and you need to know which address failed.

What is inside the pack, honestly

The pack is a 10-tab workbook in Google Sheets and Excel, with no macros: Start Here, Dashboard, Card List, Sent and Received, Mailing Deadlines, Address Labels, Card Budget, Address Changes, Thank You Log, and Notes for Next Year. The Dashboard pulls it together: how many households, how many cards still to write, how many posted, how many received, what is left of the budget, and the next mailing deadline. Next to the workbook there is a blank file and an example file with 25 households filled in, plus a 12-page printable pack in A4 and US Letter for anyone who still likes paper for the checklist pages.

It is $6.99. That is the whole price, and the file is yours to reuse every year. If you send a handful of cards, you do not need this. A notebook will do, and I would tell you so. If you send 20 to 100 cards a year and you are tired of the drawer full of unposted cards, the missed names and the January adding-up, this is the file I built for that exact problem, because it was my problem first.

If you want to see it, the Christmas Card List Planner Spreadsheet is on Gumroad, and the listing shows what each tab looks like before you buy. That is the whole idea behind a christmas card list planner spreadsheet excel file: one place where every name, date and cost lives until the last card is posted.