Christmas List Template for Parents: Every Kid, Gift and Grandparent

Why parents need a Christmas list template of their own

A Christmas list template for parents solves three problems a kid's letter to Santa never will: memory, money, and coordination. Kids name dozens of things between Halloween and Christmas. Parents need one place that records each wish, what it costs, who is buying it, and where it is hidden, so nothing gets forgotten or bought twice.

You know the moment. It is a Tuesday in November, you are in the toy aisle with a cart of paper towels, and your 6 year old points at a box: "I want THAT." You say, "Maybe Santa will bring it." By Thursday you cannot remember if it was the blue one or the purple one.

According to the National Retail Federation (2025), shoppers planned to spend $890.49 each on the holidays, and $627.93 of that was for gifts for family and friends. Families with children planned to raise their gift budgets by more than $30. Timing adds pressure too. In NRF's 2026 holiday survey, 43% of shoppers planned to start before November, and half of those early starters did it to spread out their budget. Starting early only helps if you remember what you already bought. Our guide on when to start Christmas shopping covers the calendar side.

What columns a Christmas list template for parents needs

A Christmas list template for parents works best with one row per gift and ten columns: person, group, the wish in the kid's words, a photo, a store link, the price, a bought checkbox, who is buying, where it is hidden, and a wrapped checkbox. Each child, grandparent, teacher, or neighbor gets as many rows as they need.

• Write the wish in the kid's words. "The unicorn that changes color" is easier to find later than "plush toy," and it tells grandparents exactly what to look for.
• The photo column is the one you will thank yourself for. The same toy comes in different sizes and colors, and a picture of the real box ends the "was it this one?" problem.
• "Where it is hidden" sounds silly until December 23. Every parent has found a gift in March.

For more ways to capture what kids ask for, see our Christmas list hub and the guide to a picture Christmas list.

How to build the Christmas list template in Google Sheets

You can build this Christmas list template in Google Sheets in about 20 minutes with two tabs and no add-ons. The Gifts tab holds one row per gift, using the columns above. The People tab holds one row per person with a budget, and five short formulas show what is planned, spent, and left, plus how many gifts each person has.

1. 1

   Fill in the People tab

   Type each name and budget, add the formulas in row 2, then copy row 2 down for every person. Planned adds up all of Maya's gifts. Spent adds up only the ones checked as bought.

2. 2

   Add dropdowns on the Gifts tab

   Select column A, then Insert > Dropdown > Dropdown from a range, and point it at People!A2:A20. Every name is then spelled the same way, so the formulas keep working. Do the same for Group and Who is buying, typing the choices yourself.

3. 3

   Add checkboxes

   Select columns G and J, then Insert > Checkbox. A checked box reads as TRUE, which is what the Spent and Bought formulas count.

4. 4

   Add photos

   For a phone photo, click the cell and use Insert > Image > Image in cell. For a store picture, right-click the product photo, copy the image address, and type =IMAGE("that address"). IMAGE does not work with Google Drive links or SVG files.

5. 5

   Turn on the early warning

   Select the Left column, open Format > Conditional formatting, and set cells less than 0 to turn red. A red cell means that kid's budget is already gone.

For a family total, add =SUM(B2:B20) under the Budget column and =SUMIF(Gifts!G:G,TRUE,Gifts!F:F) for everything bought so far.

How to keep a Christmas list hidden from kids in Google Sheets

Hiding a tab in a family Google Sheet does not keep a Christmas list hidden from kids. Google's own help page says spreadsheet viewers can still access content in hidden sheets, and all editors can unhide them. The safe setup is a separate file for the parent list, shared only with the adults who need it.

• Keep the parent list in its own file, outside any shared family folder.
• Share it only with the adults who need it, using their own email addresses.
• Check which Google accounts are signed in on the family tablet or laptop. If your account is signed in there, your Drive is open there too.
• Give the file a boring name. "Q4 receipts" gets fewer clicks than "CHRISTMAS GIFTS DO NOT OPEN."
• If you use a phone app instead, pick one that locks the list behind a PIN or Face ID, not just a hidden menu.

Hiding the actual boxes is its own puzzle. Our guide on where to hide Christmas presents has spots kids rarely check.

How to coordinate Christmas gifts with grandparents

The easiest way to coordinate Christmas gifts with grandparents is to give every gift one buyer before anyone shops, then send grandparents only the open items with a price range. One parent keeps the master list. Grandparents text when they buy, and that parent checks the box, so two people never buy the same toy.

1. 1Go down the Gifts tab and fill in Who is buying. Leave it blank only for gifts that are still open.
2. 2Filter to the open items: Data > Create a filter, then filter column H by values and keep only (Blanks).
3. 3Select the Person, Wish, and Price cells, then File > Download > PDF with Export set to Selected cells. Hiding spots and budgets stay off the page. You can also paste the rows into a text.
4. 4Give a price range, not just an item. "Anything on this list from $20 to $40" lets Grandma choose without guessing your budget.
5. 5Ask grandparents to text you when they buy. One person updating the list works better than four people editing it.

Leo's open list (age 4): dump truck with lights, about $35. Dinosaur pajamas, size 4T, about $20. Bath crayons, about $8. Text me what you pick so I can cross it off!

Gift cards are a safe backup. According to NRF's 2026 holiday survey, gift cards were the most wanted gift at 47%, ahead of clothing at 44%. For more ideas, read our guide to gifts from grandparents.

How many Christmas gifts per kid: what the research says

Research does not set a number of Christmas gifts per kid, but two studies help parents set a limit. A Stanford and Harvard study found people value gifts they asked for more than surprises. A University of Toledo study found toddlers played longer with 4 toys than with 16. Together they point to fewer gifts, chosen from the list.

Francis Flynn of Stanford and Francesca Gino of Harvard ran five experiments, published in the Journal of Experimental Social Psychology (2011). Recipients valued requested gifts more and saw them as more thoughtful, while givers guessed the opposite. In one experiment, recipients built a wish list of 10 products priced $20 to $30, and gifts picked from that list were rated more thoughtful and personal. The wishes you write down in the aisle are often the better gift.

According to the University of Toledo (study published in Infant Behavior and Development, 2018), 36 toddlers aged 18 to 30 months each played once with 4 toys and once with 16. With 4 toys, they played about twice as long with each toy. The study only covered toddlers, so do not stretch it to a 9 year old.

When there were fewer toys, they played with them in more ways.

• Set a gift count for each kid next to the budget. Many families use want, need, wear, read, which is 4 gifts, and the Gifts column counts them for you.
• Add a "Top" option to the Group dropdown so the one gift they keep talking about never gets lost.
• For toddlers, buy what you planned, but put a few toys away and bring them out in January.
• Keep budgets fair, not equal. One video game for a 9 year old can cost more than three toys for a 4 year old.

Catching Christmas wishes in the store aisle with Santa Wishlist

The hardest part of any Christmas list template is getting the wish onto the list while you stand in the aisle with a cart and a kid. Low-tech fixes work: snap the box into a phone album called "Christmas ideas," text yourself the name and store, or keep a shared note, then move everything into the sheet on Sunday night.

Santa Wishlist was built for that moment. When your kid says "I want THAT," you send a photo or a quick message to Santa, and Santa writes back in seconds using your child's name and words that fit their age. The elves quietly save the item to a hidden list for that kid: the photo, the name, an estimated price, and the store when it can tell. The list is locked behind your PIN or Face ID, each item has a "got it" checkbox, and you can export a plain text list for grandparents.

Santa's replies are written by AI, and you hold the phone the whole time. Co-parents and grandparents can join your family in the app (up to 4 people) and see the same list, and you can export it as text. Keep the spreadsheet for budgets and hiding spots. See how it works for the full flow.