How to Set Up a Holiday Gift List Spreadsheet
A gift list spreadsheet keeps holiday shopping from scattering across notes apps and receipts. Start with one row per person, a budget column, and columns for the gift idea, where you bought it, price paid, and status such as idea, ordered, shipped or wrapped. Add a total at the top that compares spending to your overall budget. Updating it each time you buy something makes it easy to see who is done and where you are running over before it is too late.
Practical tips
- Set your overall holiday budget before listing gifts.
- Give each person a per-person budget.
- Track status: idea, ordered, shipped, received, wrapped.
- Record actual price paid, including shipping.
- Note order numbers or tracking links for online orders.
- Add a return-by date column for gifts that might be exchanged.
- Review totals weekly in November and December.
Frequently asked questions
What columns matter most?
Name, budget, gift, price paid and status cover most needs.
Should I include stocking stuffers?
Yes, small items add up; give them their own row or category.
Google Sheets or Excel?
Either works; pick whichever you already use on your phone.