Kitchen Prep List Excel Template: Build a Clear Sheet

How-to basics · Updated November 20, 2026

A kitchen prep list Excel template is a task table for tracking what must be prepared, in what quantity, by when, and by whom. In Excel for Microsoft 365 on Windows, create a sheet with columns for the prep item, station, quantity, due time, owner, and status, then format it as a filterable table; the layout and formulas below provide a practical starting point.

What a kitchen prep list should include

A useful prep list turns a menu or service plan into specific, assignable jobs. “Prepare vegetables” is too broad to manage well; separate tasks such as “wash romaine,” “dice onions,” and “portion tomato sauce” are easier to assign, check off, and hand over between shifts. A list should answer the basic operational questions without making staff search through several documents.

  • What: a clear prep item or task, written as an action.
  • How much: a quantity and unit, such as 3 kg, 24 portions, or 2 trays.
  • Where: the station or work area responsible.
  • When: a date or service deadline, and a due time if timing matters.
  • Who and progress: an assigned person and a consistent status.
  • Useful notes: recipe reference, cut size, batch details, or a handoff instruction.

The right level of detail depends on the kitchen. A small café may need one sheet for the day, while a larger operation may need separate station views or lists for different services. The goal is not to record every action in the kitchen; it is to make planned work visible and verifiable.

Build the workbook in Excel

Start with a blank workbook and name the first worksheet “Prep List.” Put one heading in each cell of row 1. A sensible starter order is: Date, Station, Prep Item, Quantity, Unit, Due Time, Assigned To, Status, and Notes. Enter each prep task on its own row beneath the headings. Avoid merged cells and blank spacer rows inside the list, since they make sorting and filtering less reliable.

Select a cell in the list and choose Insert > Table, confirm that “My table has headers” is selected, and choose OK. A table automatically extends its formatting and formulas as new rows are added, and its header controls let staff filter by station, owner, or status. In Table Design, give the table a short name such as PrepList so formulas can refer to it clearly.

Make the sheet readable at a glance. Use a date format for Date and a time format for Due Time; set practical column widths; and turn on wrap text for long notes. On Windows, use View > Freeze Panes > Freeze Top Row to keep the headings visible while scrolling. Excel for Mac has Freeze Panes on the View tab as well, though exact ribbon arrangement can vary by window size. Keep print layout in mind if the kitchen uses paper: use Page Layout to choose orientation and scaling, then check Print Preview before relying on a printout.

A practical column layout and example

Here is a sample of how a few rows might look. The quantities are examples, not standard recipe amounts; use the quantities specified by your own menu, recipes, and forecast.

Date Station Prep Item Quantity Unit Due Time Assigned To Status Notes
Nov 3 Cold line Wash and spin romaine 3 kg 10:00 AM Sam To do Check leaves; follow produce procedure
Nov 3 Sauce Portion tomato sauce 12 portions 11:00 AM Lee In progress Use current recipe and portion size
Nov 3 Bakery Label dessert trays 4 trays 12:00 PM Jo Done Confirm labels against ingredients

Use a single, consistent status vocabulary, for example “To do,” “In progress,” and “Done.” A separate “Blocked” status can help when a task is waiting on an ingredient or equipment, but define what it means so it is not used as a vague substitute for a note. If a task needs to be repeated for multiple services, make the date or service explicit rather than assuming everyone knows which batch the row refers to.

Add status choices and simple counts

A dropdown reduces spelling differences such as “Complete,” “completed,” and “Done,” which otherwise make filtering and counting inconsistent. Select the cells in the Status column, then choose Data > Data Validation. In the settings, choose List and enter the allowed values separated by commas, such as To do,In progress,Done. Apply the rule to the task rows, and extend it when you add rows if the table does not automatically carry it forward. Excel for Mac also provides Data Validation from the Data tab; menu placement can differ slightly.

For a simple progress summary, place a label and formula above or beside the table, outside its data rows. With the table named PrepList and task records in its Status column, this formula counts rows marked Done: =COUNTIF(PrepList[Status],"Done"). If the example list contains one completed task, the result is 1. COUNTIF is available in Microsoft 365 Excel and accepts the table column reference shown.

With the same PrepList table and three example tasks, this formula counts items still marked To do: =COUNTIF(PrepList[Status],"To do"). The result for the sample is 1. Keep the label beside each count clear, such as “Done” or “To do”; a number without a description is easy to misread during a busy shift. These counts describe recorded statuses, not whether a task has actually been completed correctly, so the person responsible still needs to verify the work.

Use the list during a shift

A prep list works best when it is treated as a working handoff document rather than a one-time checklist. Build the day’s rows from the menu, expected volume, recipes, and established kitchen routines. Assign ownership and a realistic deadline before work begins. During the shift, update status when work starts or is finished, and add a short note when something changes, such as a shortage, a changed quantity, or a task transferred to another station.

  1. Plan: enter tasks, quantities, units, station, and required completion time.
  2. Assign: give each task one accountable owner, even if several people help.
  3. Review: filter the table by station or status to see what needs attention.
  4. Verify: check the completed prep against the recipe and the kitchen’s procedures before marking it done.
  5. Reset: archive or clear the prior service’s rows according to the operation’s recordkeeping practice, then prepare the next list.

Filtering can make a shared master list easier to use: a station can display only its own jobs, while a lead can review all open tasks. Sorting by due time can expose urgent work, but take care not to sort only one column. Sort the entire Excel table so task details stay together. If the list is printed, designate who updates the master copy; separate paper copies can quickly become inconsistent.

Choose the right level of detail

A template should fit the type and pace of the operation. A small kitchen may need only the nine basic columns, with a short notes field. A production kitchen might add Batch ID, Recipe Reference, or Service. A catering team may need an event name and dispatch deadline. Add a column only when it answers a recurring question or supports a real handoff; too many fields make data entry slower and can encourage staff to leave important cells blank.

Keep quantities and units separate. “5 kg” entered into one text cell is harder to sort or compare than 5 in Quantity and kg in Unit. However, do not assume different units are interchangeable: a spreadsheet will not safely convert a recipe quantity unless a correct conversion method and the right ingredient-specific information have been established. For tasks with several distinct steps, use separate rows when each step has a different owner or deadline. Use one row with a note only when the steps are managed together.

For recurring tasks, a master template can provide a consistent starting structure, but review it against each day’s menu and workload. Copying yesterday’s list without checking can leave obsolete tasks or wrong quantities in circulation. If recipes, production sheets, or ordering systems already hold authoritative quantities, identify which source staff should follow rather than maintaining conflicting figures in multiple places.

Common problems and ways to prevent them

  • Vague task names: replace “sauce” with an action such as “portion tomato sauce,” and include a recipe or batch reference if more than one version is used.
  • Inconsistent statuses: use a dropdown and agree on what each option means. Avoid color alone, since colors may print poorly and do not explain the status.
  • Missing units or deadlines: include the unit beside every quantity and a due time when sequence matters. A quantity without a unit is ambiguous.
  • Overwriting the template: keep a clean master copy and create a dated working copy or reset the table carefully. Protecting a worksheet can prevent accidental edits, but it should not obstruct routine updating.
  • Confusing a plan with a record: a planned quantity or checked box does not prove that the right item was prepared. Add verification steps where the operation requires them.
  • Sorting a partial range: use the table’s header filters or sort commands so an owner, status, and task remain on the same row.

Also decide how to handle changes. If a task is canceled, deleting it may be reasonable for a disposable daily list, but a tracked operational record may need a cancellation note or an archived copy. The appropriate approach depends on the business’s procedures and recordkeeping requirements; an ordinary Excel checklist is not automatically an audit trail.

Food safety, access, and sharing

An Excel prep list is an organization aid, not a food-safety plan, temperature log, allergen-control system, or substitute for training and approved procedures. A note such as “check label” should point to a defined practice, not replace it. Keep sensitive or critical handling instructions in the procedure or system designated by the operation, and make sure staff can access the current version. Follow applicable local requirements and the organization’s food-safety program.

Consider where the workbook is stored and who can edit it. Microsoft 365 can support coauthoring when a workbook is saved in a suitable OneDrive or SharePoint location and users have access, but simultaneous editing should be tested with the organization’s setup. A file stored only on one workstation will not automatically stay current on other devices. Avoid using personal email or an uncontrolled shared link for operational files, and establish a clear owner for the master template.

For a kitchen display, check whether the screen, device, and network are reliable in the work area. A paper backup may be sensible if the team needs a list during a power or connectivity interruption. Whether digital or printed, use a process for replacing outdated copies so staff do not act on yesterday’s version.

Excel template versus other options

Excel is a flexible choice when a kitchen wants to customize columns, filter by station, and keep a straightforward list without adopting a dedicated operations system. It is also familiar to many office users and can be printed. Its limits become more noticeable when many people edit at once, tasks depend on inventory or recipe data, or managers need reliable history across numerous shifts. A spreadsheet needs someone to maintain its structure and check that staff use it consistently.

A paper checklist can be faster to mark in a kitchen with limited device access, but it is harder to filter, summarize, or share changes. A shared task-management or restaurant operations platform may offer user permissions, notifications, and links to other records, depending on the product; those capabilities and costs vary, so compare them against the actual workflow. The best tool is the one the team can keep current, not simply the one with the most features.

Frequently Asked Questions

What should be on a kitchen prep list?
A useful list usually has the prep task, quantity, unit, station, due date or time, assigned person, status, and a notes field. Add recipe, batch, or service references when they prevent confusion.

How do I make a kitchen prep list in Excel?
Put one field in each heading cell, enter one task per row, select the range, and choose Insert > Table with headers enabled. Add a status dropdown through Data > Data Validation and filter the table as needed.

Can Excel automatically count completed prep tasks?
Yes. If your Excel table is named PrepList and its status column is named Status, =COUNTIF(PrepList[Status],"Done") counts rows whose status is Done. The count depends on staff entering the agreed status consistently.

Should each ingredient or prep step get its own row?
Use separate rows when tasks have different owners, deadlines, or completion checks. Keep steps together only when one person manages them as a single job and the combined description remains clear.

Is an Excel prep list a food-safety log?
No. A prep list tracks planned work and progress. It does not replace required safety procedures, temperature records, allergen controls, or other documentation required by the kitchen’s program or local rules.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.