Christmas dinner spreadsheet UK: Excel, Google Sheets and a printable running order
A Christmas dinner spreadsheet keeps the menu, shopping list, prep jobs and Christmas Day timings in one file you can reuse every year. This UK guide shows which columns to use in Excel or Google Sheets, how a cooking-timer sheet works back from serving time, when a free online calculator is enough, how to print a fridge running order, and when a ready template saves the fiddly formulae. It is practical planning help, not food safety, legal or dietary advice — always follow the label on your bird and the Food Standards Agency's chilling and cooking guidance. For the planning method (what to put on the menu and when to start), see the Christmas dinner planner UK guide. For roast and rest clock times alone, use the free Christmas dinner timings calculator.
What this guide is (and is not)
- Is: a how-to for a Christmas dinner spreadsheet / Excel / Google Sheets file — columns, cooking schedule, shopping list and printable day-of sheet.
- Is not: a substitute for the free timings calculator when you only need turkey in/out times, or the step-by-step method in the dinner planner UK guide.
- Honest note: you do not need to buy anything. A blank Sheets file plus the free calculator covers many households. A ready template helps when you want dish-by-dish auto times, a sorted running order and a printable PDF without building the formulae yourself.
Spreadsheet vs free calculator vs printable PDF
| Tool | Best for | Keeps a reusable file? |
|---|---|---|
| Free Christmas dinner timings calculator | Quick turkey / crown roast and rest times from serving time | No (on-screen only) |
| DIY Excel / Google Sheets | Menu, shopping list, prep ticks and your own time columns | Yes |
| Ready Christmas Dinner Planner & Cooking Timer (£2.99) | Auto start times for up to 30 dishes, running order, scaled shopping list + A4 PDF | Yes |
| Printable fridge sheet | Christmas Day jobs in time order | Print once from your sheet or PDF |
Many households plan in a spreadsheet through November, then print the running order on Christmas Eve. The free calculator is enough if you only need the bird timeline and you keep the shopping list on paper.
Columns that match a real cooking-timer spreadsheet
Build (or buy) a sheet with at least these ideas — they match how the Christmas Dinner Planner & Cooking Timer (£2.99) is laid out, so you can DIY the same structure:
- Header: dinner date (often Christmas Day), serving time, number of guests, dietary notes.
- Dishes table (one row per dish): dish name; where it cooks (oven, hob, microwave, air fryer, slow cooker, fridge/make-ahead); oven temperature if needed; minutes for prep, cooking and resting / keeping warm.
- Worked-out times: start prep, start cooking, out / off heat, serve — usually calculated from serving time working backwards.
- Day-before shading: jobs that fall on Christmas Eve (or earlier) so make-ahead prep is obvious.
- Main joint helper: weight, minutes per kg and extra minutes from the packaging or butcher, feeding into the cooking time for that row.
- Running order: every job sorted by clock time, ending with “Serve dinner”, with a tick column.
- Quantities / shopping: example amounts per person scaled to your guest count — change the amounts to suit your recipes; treat examples as placeholders, not rules.
Excel vs Google Sheets
- Excel: download an .xlsx and open it in Excel 2016 or later / Microsoft 365.
- Google Sheets: upload the .xlsx to Google Drive, open it, then File › Save as Google Sheets (free Google account). Share the file with whoever is cooking so one person is not the only one who can edit.
- PDF: print the day-of pages at 100% / “Actual size” on A4 for the fridge; fill in on a tablet if you prefer not to print.
Shopping list and prep checklist in the same workbook
Keep shopping on a separate tab or section so one person can shop without scrolling the timer:
- Split by meat/main, vegetables, dairy/chilled, bakery/desserts, cupboard/frozen, drinks, and “other” (foil, bin bags, dishwasher tablets).
- Scale quantities from a per-person column × guest count, then override anything that does not match your recipes.
- Add a prep countdown: 4–6 weeks out (order the bird, long-life cupboard items), one week out (fresh that keeps), Christmas Eve (veg prep, gravy base if your recipes allow), Christmas morning (follow the running order).
For the wider Christmas food budget, use the free Christmas budget calculator and the Christmas budget spreadsheet UK guide. Weekly meals around Christmas sit in the weekly meal planner UK guide.
Food safety pointers (not a substitute for the FSA)
- Example cooking times in any template are placeholders to show how the timer works. Always follow the instructions on your packaging or from your butcher, and check meat is cooked through before serving.
- Cool leftovers promptly, refrigerate, and reheat until steaming hot all the way through. See the Food Standards Agency on chilling and cooking.
- List every allergy and preference on the first page of the sheet. If you cook for a mixed group, keep vegetarian mains and gravy paths clearly separate from meat juices.
How to make your own Christmas dinner spreadsheet (DIY)
- Create a workbook in Excel or Google Sheets with tabs: Header & guests, Dishes, Running order, Shopping, Prep checklist.
- Fix serving time and guest count on the Header tab.
- List every dish with prep / cook / rest minutes. For the bird, use the free timings calculator (or the packaging) and type the minutes into the row — do not invent roast times.
- Work backwards for each dish: serve time − rest − cook = start cook; start cook − prep = start prep. In Sheets/Excel you can do this with simple time formulae once you are comfortable; otherwise type the clock times by hand.
- Copy jobs into a Running order tab, sort by time, add tick boxes (or a Done column).
- Build the shopping list from the menu, split by aisle, and print the Running order on Christmas Eve.
Prefer not to wire the formulae? The Christmas Dinner Planner & Cooking Timer (£2.99) does the backwards timing, sorting and scaled shopping list for you.
Illustrative sheet layout (made-up example)
The rows below are a made-up example to show columns. They are not a recommended menu or real cooking times.
| Dish (example) | Where (example) | Prep / cook / rest min (example) | Notes (example) |
|---|---|---|---|
| Example roast | Oven | Example figures only | Use packaging / calculator |
| Example roast potatoes | Oven | Example figures only | During rest window |
| Example vegetables | Hob | Example figures only | Christmas Eve peel OK |
| Example gravy | Hob | Example figures only | Base made ahead |
| Example dessert | Fridge | Example figures only | Made day before |
DIY vs ready template vs Christmas bundle
- DIY: follow the steps above. Costs nothing beyond your time; you maintain the formulae.
- Free calculator only: enough for bird in/out times when the shopping list lives elsewhere.
- Ready dinner planner: the Christmas Dinner Planner & Cooking Timer (£2.99) when you want auto times for many dishes, a sorted running order and a 4-page printable PDF.
- Budget and gifts: the Christmas Budget Planner (£2.99) and Christmas Gift List Tracker (£2.99) (or the free Christmas gift list) so food planning does not mix with present tracking.
- Christmas bundle: the Christmas Planner Bundle (10 templates) (£7.99) includes the dinner planner with the budget, gift list, Secret Santa, party games and other Christmas templates.
What is (and is not) in the Christmas Dinner Planner & Cooking Timer
- Included in the Christmas Dinner Planner & Cooking Timer (£2.99): Cooking Timer (dinner date defaulting toward Christmas Day, serving time, guests); up to 30 dishes with cook location, oven temperature and prep/cook/rest minutes, with start prep, start cooking, out/off heat and serve times worked out; day-before jobs shaded; main-joint helper (weight, minutes per kg, extra minutes); Running Order sorted by time with tick boxes ending at “Serve dinner”; Quantities shopping list with per-person amounts scaled to guests (change to suit); 12 example dishes for a traditional British Christmas dinner including a veggie option; printable A4 PDF (4 pages: dinner plan, shopping list by section, prep countdown from 4–6 weeks before to Christmas Day, Christmas Day timings); Start Here guide. Excel and Google Sheets via .xlsx upload.
- Not included: nothing physical is posted; example cooking times are placeholders — follow your packaging or butcher; not legal, tax, financial or food-safety advice. Personal use / your own organisation only; do not resell or share the files.
More: Christmas dinner planner UK · Christmas dinner timings UK · dinner timings calculator · Christmas budget spreadsheet UK · Christmas to-do list UK · weekly meal planner UK · days until Christmas · Christmas budget calculator
Free tools for this
- Christmas Dinner Timings Calculator
- Christmas Budget Calculator (UK)
- Days Until Christmas 2026: Countdown & Savings Planner
- Christmas Gift List & Budget Tracker
Frequently asked questions
What columns belong in a Christmas dinner spreadsheet?
Header fields for dinner date, serving time, guests and dietary notes; a dishes table with cook location, temperatures and prep/cook/rest minutes; worked-out start and finish times; a running order sorted by clock time with ticks; and a shopping or quantities list you can scale to guest numbers.
Is there a Christmas dinner spreadsheet template for Excel or Google Sheets?
Yes. You can build one with the columns in this guide, or use the Christmas Dinner Planner & Cooking Timer: an editable spreadsheet that works back from serving time, plus a 4-page A4 printable PDF. Upload the .xlsx to Google Drive and save as Google Sheets if you prefer Sheets.
When is a free Christmas dinner timings calculator enough?
When you only need turkey or crown roast and rest times from a serving time, and you are happy keeping the menu and shopping list on paper or in a simple list. Use a full spreadsheet when you want dish-by-dish auto times, a sorted running order and a reusable file.
How do I make a Christmas Day cooking schedule in a spreadsheet?
Fix serving time and the bird minutes first (from packaging or the free timings calculator), list every dish with prep/cook/rest minutes, work backwards to start times, then copy every job into a running-order tab sorted by time with a tick column. Print that tab for the fridge.
Can I use Google Sheets for a Christmas dinner planner?
Yes. Build your own sheet, or upload an .xlsx template to Google Drive, open it and choose File › Save as Google Sheets. Share the file with everyone who is cooking.
Should example cooking times in a template be trusted?
No. Example times only show how the timer columns work. Always follow the instructions on your packaging or from your butcher, and check meat is cooked through before serving. See the Food Standards Agency chilling and cooking guidance.
What is in the Christmas Dinner Planner & Cooking Timer download?
An editable spreadsheet (cooking timer for up to 30 dishes, main-joint helper, sorted running order, scaled shopping list, 12 example dishes) plus a 4-page A4 PDF and a Start Here guide. Nothing physical is posted. It is for personal use or your own organisation.
Is this food safety or dietary advice?
No. This guide and the planner template are planning tools only. Follow packaging, your butcher and Food Standards Agency guidance on chilling, cooking and leftovers.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.