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)

Spreadsheet vs free calculator vs printable PDF

ToolBest forKeeps a reusable file?
Free Christmas dinner timings calculatorQuick turkey / crown roast and rest times from serving timeNo (on-screen only)
DIY Excel / Google SheetsMenu, shopping list, prep ticks and your own time columnsYes
Ready Christmas Dinner Planner & Cooking Timer (£2.99)Auto start times for up to 30 dishes, running order, scaled shopping list + A4 PDFYes
Printable fridge sheetChristmas Day jobs in time orderPrint 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:

Excel vs Google Sheets

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:

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)

How to make your own Christmas dinner spreadsheet (DIY)

  1. Create a workbook in Excel or Google Sheets with tabs: Header & guests, Dishes, Running order, Shopping, Prep checklist.
  2. Fix serving time and guest count on the Header tab.
  3. 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.
  4. 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.
  5. Copy jobs into a Running order tab, sort by time, add tick boxes (or a Done column).
  6. 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 roastOvenExample figures onlyUse packaging / calculator
Example roast potatoesOvenExample figures onlyDuring rest window
Example vegetablesHobExample figures onlyChristmas Eve peel OK
Example gravyHobExample figures onlyBase made ahead
Example dessertFridgeExample figures onlyMade day before

DIY vs ready template vs Christmas bundle

What is (and is not) in the Christmas Dinner Planner & Cooking Timer

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

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.