Christmas Card List Spreadsheet With Addresses and Postage Cost

It is early December, you are holding a stack of cards, and the address list is in three places: an old envelope, a text thread from last year, and your memory. By the time you have found Aunt Carol’s new apartment number, you have also lost track of who you have already sent to.

A Christmas card list spreadsheet fixes both problems. It stores every address once, remembers who you sent to, who sent back, and tells you what the whole mailing will cost before you buy a single stamp. This guide gives you the columns, a worked cost example and a send-by timeline. It is one tab of the larger Christmas planner spreadsheet for the whole holiday season.

The columns that make the list work

One row per household, not per person. Start with these thirteen columns:

  1. Name or household. “The Alvarez family” is more useful than four separate rows.
  2. Street address.
  3. City, state and ZIP (or city and country for international).
  4. Sending one this year? A Yes or No dropdown. This is the column that lets you trim the list without deleting anyone.
  5. Card sent? Yes or No.
  6. Date sent.
  7. Postage paid. Type the actual stamp cost for that card.
  8. Card cost. What that card cost you, including any photo-print charge.
  9. Spent on this card. A formula, described below.
  10. Card received from them? Yes or No.
  11. Status. A formula that reads TO SEND, SENT or SKIPPED.
  12. Still to spend. A formula for cards you plan to send but have not.
  13. Notes. New address, new baby, moved, name change.

Add dropdown lists (data validation) to the Yes and No columns so the formulas never have to guess whether someone typed “yes”, “Y” or “sent.”

The formulas

Keep them short.

Spent on this card (column I): if the card has been sent, add postage and card cost; otherwise leave it blank.

=IF($A6="","",IF($D6="Yes",$F6+$G6,0))

Status (column K): skipped if you are not sending, sent if the card has gone, otherwise to send.

=IF($A6="","",IF($J6="No","SKIPPED",IF($D6="Yes","SENT","TO SEND")))

Still to spend (column L): for cards you intend to send but have not, use the postage in Settings if you have not typed a postage amount yet.

=IF($A6="","",IF(AND($J6="Yes",$D6<>"Yes"),Settings!$B$8+$G6,0))

At the bottom, sum column I for spent so far, column L for still to spend, and add them for the projected total. Use COUNTIF on the Status column to show how many cards are left to send.

A worked cost example for 60 households

The numbers below are illustrative assumptions. Replace the card price and stamp prices with your real ones.

Total: $96.50 + $19.50 + $4.80 = $120.80 for 60 households, or about $2.01 per household on average.

Now the useful part. Suppose you look at the received column and find that 12 of your domestic households have not sent a card back in three years, and you decide not to send to them this year. Flipping “Sending one this year?” to No for those 12 rows saves 12 x $1.93 = $23.16, and the totals update on their own. You have not deleted anyone, and the addresses are still there.

Compare that with the other direction. If you decide to add a $0.60 photo print to each of the 50 domestic cards, the cost of those goes from $1.93 to $2.53 each, which adds $30 to the total. A sheet that holds card cost per row shows you the effect immediately.

Send-by timeline

Dates are what get cards delivered, so put each one in your task list with a due date rather than keeping it in your head. A sensible order, working backward from the day you want everything delivered:

  1. Early to mid November. Choose the card, count the list (the “Sending one this year?” column does this), and order. Photo cards usually need processing and shipping time.
  2. When cards arrive. Check every address, and update the notes column for anything you are unsure about.
  3. First week of December. Address and stamp. Do the international ones first.
  4. Second week of December. Post domestic cards. Mark Card sent and Date sent as you go, a batch at a time.
  5. After Christmas. Log cards you received. This is the moment to correct addresses that came back.

If you hold a stack of unaddressed envelopes, the Status column tells you in one glance how many TO SEND rows remain.

Five habits that keep the list useful year after year

  1. Reset, do not rebuild. Next year, clear Card sent, Date sent and Postage paid, and keep everything else.
  2. Update the address the moment you learn it. The envelope that comes back is the best address source you will get.
  3. Keep return addresses. When a card arrives, copy the return address into the sheet if it differs.
  4. Mark, do not delete. Use Sending one this year = No so the row is still there if you change your mind.
  5. Budget the card line in your season plan. In the six-category Christmas budget, Cards & Postage is its own cap, so the total here is the number to compare against it.

Skip the setup

The Card List tab in the Ultimate Christmas & Holiday Season Planner has all thirteen columns, the dropdowns and formulas ready, and it feeds the Cards & Postage line of the budget automatically. You type in addresses; the totals, the status flags and the still-to-spend figure update on their own.

The bottom line

A card list is a small spreadsheet that saves a big evening. Store each address once, mark who you are sending to this year, record postage and card cost per row, and let the totals tell you the price of the mailing before you buy. Add dates to the task list and the cards go out on time without any last-minute scramble.

Frequently Asked Questions

What columns should a Christmas card list spreadsheet have?

Use one row per household with these columns: name or household, street address, city and ZIP (or country), sending this year (yes or no), card sent (yes or no), date sent, postage paid, card cost, and card received from them (yes or no). Add a notes column for name changes, new babies or moves. A formula that adds postage and card cost for each row, shown only when the card has been sent, gives you the running total.

How much does it cost to send 60 Christmas cards?

It depends on your card price and current stamp price. In the worked example here, 60 cards at 1.20 dollars each with an assumed 0.73 dollar domestic stamp and 2.05 dollar international stamp, including 4 hand-delivered cards, comes to 120.80 dollars. Check your current postage rate and your actual card price, and change those two cells; the totals update on their own.

When should I mail Christmas cards?

Pick a send-by date and work backward. A common approach is to order cards in mid-November, address them in the first week of December, and post them by the second week so domestic cards arrive well before Christmas. International cards need more lead time, so post those earlier. Put each of those dates in your task list rather than relying on memory.

Should I keep sending cards to people who never send one back?

That is entirely up to you, and many people send regardless. If you are trying to trim the list, a received column makes the decision easy to see: sort by sending-this-year and card-received, then decide which households to keep. Mark anyone you remove as no this year rather than deleting the row, so the address is still there if you change your mind.

Budget the Whole Christmas Season, Not Just the Gifts

The Ultimate Christmas & Holiday Season Planner — One workbook for the whole season: a Dashboard with days to Christmas and projected total, a six-category Budget (Gifts, Food & Hosting, Travel, Decorations, Cards & Postage, Charity & Tips) with an overall cap and status flags, a Gift List, a Holiday Menu & Grocery Planner with cost per person, a Baking Planner, a Card List with postage, Events & Parties, Travel, a Decoration Inventory, a Task Countdown, an Extras Log and a Post-Holiday Payoff Plan. Works in Excel and Google Sheets, no macros and no add-ons.

View on Etsy — $12.99