Christmas Dinner Planner Spreadsheet

Plan Christmas dinner without the math. Type in each recipe once, add your guest count, and this spreadsheet scales every dish, builds your shopping list, plans your ham, turkey or prime rib, and gives you a cooking timeline for the big day.

Works in Google Sheets and Excel. Includes a bonus editable Christmas dinner menu.

━━━━━━━━━━━━━━━━━━
WHAT IT DOES
━━━━━━━━━━━━━━━━━━
✦ Scales every recipe to your guest count (kids count as half, plus extra for leftovers, both adjustable)
✦ Converts units for you: ½ cup butter becomes 8 tbsp, 12 oz cranberries becomes 3 cups
✦ Builds one shopping list, grouped by store section, rounded up to real package sizes, with estimated costs
✦ Subtracts what you already have in your pantry
✦ Add a photo to every recipe right in the spreadsheet
✦ Dishes a guest is bringing stay off your list

━━━━━━━━━━━━━━━━━━
WHAT'S INCLUDED
━━━━━━━━━━━━━━━━━━
✦ Dinner Plan: date, time, budget and your key numbers at a glance
✦ Guests: RSVPs, dietary needs, allergies and who's bringing what
✦ Menu: every dish with a photo, who's making it, make-ahead day and cook times
✦ Ingredients: enter each recipe as written, and it scales automatically
✦ Shopping List: built for you, plus a "don't forget" supply checklist
✦ Roast Calculator: choose ham (5 kinds), turkey or prime rib to get the size to buy, thawing, roasting time, when it goes in the oven and the safe temperature (based on USDA guidance)
✦ Timeline: countdown checklist, make-ahead plan and a sorted cooking schedule with an oven-temperature check
✦ Budget: receipts, other costs and estimated cost per dish
✦ Pantry & Prices: 88 common ingredients with package sizes and typical prices you can edit
✦ Example version filled in with a sample Christmas dinner, plus a blank version
✦ BONUS: editable Christmas dinner menu (Letter and 5 × 7) as a fillable PDF and a Canva template

━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. Purchase and download your files (Purchases > Download files).
2. Open the How to Access PDF and click the Google Sheets link to make your own copy, or open the Excel file.
3. Add your guests, menu and recipes.
4. Shop from your list and follow your timeline.

━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
✦ This is a digital download. No physical item will be shipped.
✦ Works in Google Sheets (free) and Excel. Photos in cells need Google Sheets or Excel for Microsoft 365.
✦ Prices are typical U.S. estimates for planning. Edit them to match your store.
✦ Roasting times follow USDA guidance. Always check the temperature with a food thermometer.
✦ For personal use only. Please do not resell or share the files.

Questions? Send me a message anytime. I'm happy to help!

Muse & Make CoCreated by Muse & Make Co with the help of AI tools.