Christmas Menu Planner & Shopping List
Enter the guests for each meal, the dishes and the quantity per person of every ingredient: the file works out how much you need, how much to buy and what each meal costs, in total and per person.
Real screenshots of the file
Images of the file with example data. Tap an image to enlarge it.
What's inside
Linked sheets, with instructions on the first sheet.
A worked example
In the example Christmas Eve has 8 guests and Christmas Day 10, with roast turkey, stuffing and Brussels sprouts on the list.
Example data in the file, there to overwrite. Meal costs are estimates based on the prices you enter.
| Christmas Eve, 8 guests | 111.20 |
| Christmas Day, 10 guests | 131.50 |
| Cost per person, Christmas Day | 13.15 |
| New Year's Eve, 8 guests | 67.40 |
| Prices missing | 0 |
Getting started
- Settings: the year.
- Top table: guests per meal.
- Shopping list: one row per ingredient with quantity per person, unit and price; tick Bought? as you shop.
Compatibility and limits
Compatibility
- Plain .xlsx file, no macros, standard functions only.
- Tested by full recalculation in Excel for Microsoft 365.
- Calculations also checked in Google Sheets (upload the file to Google Drive).
- Not tested in Apple Numbers or Excel for Mac.
Good to know
- Meal costs are an estimate based on the prices you type in.
- The example uses US spelling and pounds (lb); kg, g and l are in the drop-down.
Questions
How is the quantity to buy worked out?
Quantity per person × guests. Pieces, bottles and packs are rounded up to whole units; weights and volumes keep their decimals.
Can I rename the meals?
Yes, for example Thanksgiving: ingredient rows that still use the old name show a Meal? warning until you fix them.
Will anything be posted to me?
No. It's a digital file you download from Etsy straight after purchase.