A daily cleaning checklist template in Excel is a task-by-task log with columns for the date, area, cleaning task, assigned person, status, and notes. Create a worksheet with those headings, add a status dropdown using Data > Data Validation, and use a completion formula to see how much of the day’s list is finished.
What a daily cleaning checklist should track
A useful checklist makes responsibilities and completion visible without turning routine work into excessive recordkeeping. For a home, workplace, rental property, or small business, start with the information people need to do and verify the work. A practical set of columns is:
- Date: The day the task is scheduled. Include a date on every task row if you plan to filter or sort the log.
- Area: A room or zone, such as kitchen, reception, washroom, or office.
- Task: A specific action, such as wipe the counter or empty the waste bin.
- Frequency: Daily, after use, or another clear schedule. A daily sheet should not make weekly jobs look due every day.
- Assigned to: The person responsible, if work is shared.
- Status: A consistent value such as Not started, In progress, Done, or Skipped.
- Completed at and Notes: Optional fields for a time, exception, supply issue, or brief handover.
For a simple household list, date, task, and status may be enough. For a workplace, assignment and notes can help establish who handled a task and flag a problem for the next shift. Avoid collecting personal or sensitive information that is not needed for the cleaning process.
Set up the Excel template
In Excel for Microsoft 365 on Windows, open a blank workbook and enter the headings in cells A1:H1: Date, Area, Task, Frequency, Assigned to, Status, Completed at, and Notes. Put one task on each row below the headings. For example, rows might list “Kitchen” and “Wipe food-preparation surfaces,” followed by “Washroom” and “Clean sink.” Use action words and describe the expected result so that two people are less likely to interpret a task differently.
- Enter the date and task details for the first day. If the same list is used each day, save a clean master copy and make a dated copy for each shift or day.
- Select the headings and task rows, then choose Home > Format as Table and pick a style. Confirm that the table has headers. A table makes it easier to filter by date, area, assigned person, or status.
- To create a status dropdown, select the status cells, choose Data > Data Validation, set Allow to List, and enter
Not started,In progress,Done,Skippedin Source. Keep the status spellings consistent so formulas and filters work as expected. - Adjust column widths so that task names and notes are readable. To keep the headings visible while scrolling, select cell A2 and choose View > Freeze Panes > Freeze Panes.
Excel for the web has similar table, data-validation, and view controls, though the ribbon layout may vary slightly. On a Mac, the ribbon commands are generally similar; the common shortcut to create a table is Command+T rather than Ctrl+T on Windows. If a menu differs in your version, use Excel’s command search to locate the feature.
Choose a layout that fits the work
There are two common ways to organize the rows. A daily-sheet layout has one worksheet for each day, with the date shown near the top and one row per task. It is easy to print and simple for a small routine, but comparing several days can mean switching between sheets. A running-log layout stores every date in one table and repeats the date on each task row. It takes a little more setup but makes filtering, sorting, and reviewing past work easier.
For a running log, do not merge cells in the data area or leave date cells blank in repeated task groups. Those choices can make filtering and sorting unreliable. Instead, put the date in every row, then use the filter arrows in the table headers to show only a particular day. For a printable one-day sheet, keep the date in a prominent cell above the checklist and print that sheet as a daily form.
Decide whether tasks are assigned to named people or roles. A role such as “closing shift” can be more useful when staff change, while a named person can make handoffs clearer for a small team. Choose one method and explain it in the workbook instructions. Likewise, define what “Done” means for tasks that may have different standards, such as restocking supplies or cleaning a shared appliance.
Add a completion summary with formulas
A small summary can show progress without manually counting marks. In the example below, assume the headers are in row 1, the ten task names are in C2:C11, and status dropdowns are in F2:F11. If seven tasks are marked Done, the count formula returns 7. Enter it in a summary cell:
=COUNTIF(F2:F11,"Done")
To calculate the share of listed tasks marked Done, use the following formula with the same layout. With ten nonblank task names and seven Done statuses, it returns 70% when the result cell is formatted as a percentage:
=IFERROR(COUNTIF(F2:F11,"Done")/COUNTA(C2:C11),0)
The denominator counts nonblank task names, so blank rows do not lower the completion rate. IFERROR returns zero if there are no task names yet, rather than displaying a division error. The summary measures recorded status, not the quality of the cleaning; a supervisor or checklist procedure may still be needed where verification matters.
For a changing task list, convert the range to an Excel table and use table references in summary formulas, or extend the ranges when adding rows. Table formulas can be more readable, but make sure the table’s column names match the formula references exactly. Avoid using a fixed range that silently excludes tasks added below the original last row.
Make statuses and visual cues dependable
Dropdowns reduce inconsistent entries such as “complete,” “finished,” and “done,” which Excel treats as different text. They also make the list easier to use on a phone or shared computer. If people need to record an exception, use Skipped only when the task was intentionally not done, and ask them to explain why in Notes. A blank status should mean that nobody has recorded an update, not that a task was skipped.
Color can make the sheet easier to scan, but it should not be the only way to communicate status. Select the status cells and use Home > Conditional Formatting > Highlight Cells Rules > Text that Contains to apply a distinct format to values such as Done or In progress. Keep the status text visible and use readable contrast, especially if the sheet may be printed in grayscale or viewed by someone with color-vision differences.
Do not treat a colored cell as proof that a task was done correctly. Colors and completion percentages reflect what is entered in the workbook. Where cleaning standards affect health, food handling, or public access, use the applicable written procedure and required checks rather than relying on a spreadsheet alone.
Keep the checklist practical and safe
A list works best when it describes tasks that can be completed during the available time. Separate large jobs into manageable actions, but do not create so many tiny rows that people spend more time updating Excel than cleaning. A task such as “clean the kitchen” is vague; “wipe the worktop and sink” gives a clearer endpoint. Add a separate row for a job that needs a different product, tool, or responsible person.
Cleaning products and equipment require care beyond what a checklist can establish. Follow the product label and the site’s safety instructions, use required protective equipment, and never mix cleaning chemicals unless the product instructions explicitly say it is safe. A spreadsheet should not replace training, safety data, or instructions for handling a spill. If a task involves a hazard, identify the correct procedure in an approved safety document rather than improvising a checklist note.
Limit editing access if the workbook is shared, and keep a dated copy or use the organization’s normal file-history process when records need to be retained. Excel can help organize entries, but a workbook is not automatically a secure or tamper-proof record. Follow the applicable workplace or business rules for retention and access, and avoid putting confidential details in ordinary Notes cells.
Print, share, and maintain the workbook
For a paper checklist, use Page Layout > Orientation to choose portrait or landscape, and review File > Print before printing. A wide sheet with eight columns may fit better in landscape orientation. If the print preview splits the table awkwardly, adjust column widths or set a suitable print area rather than shrinking text until it is hard to read. Keep enough white space for handwriting if staff will mark a paper copy.
For a shared digital workbook, store it in a location where the intended users can access the current version, and agree who maintains the master task list. One person changing task names while another is recording completion can cause confusion. Consider protecting formula cells from accidental edits while leaving the input cells unlocked; worksheet protection helps prevent mistakes but should not be treated as strong security.
Review the list when rooms, equipment, staffing, or procedures change. Remove obsolete tasks, clarify vague wording, and check that frequencies still match the real schedule. A checklist should distinguish daily tasks from weekly or periodic work; one option is to keep a separate schedule for less frequent jobs rather than adding them to every daily sheet. The right review interval depends on how often the work changes.
Excel checklist versus other options
Excel is a sensible choice when the task list is modest, users already have access to the workbook, and filtering or printing is useful. It allows a customized log and basic summaries without requiring a dedicated cleaning app. A paper form may be simpler for a single room or a location where devices are inconvenient, though someone must collect and review completed forms. A shared task-management or facilities system may be more suitable when many sites need permissions, notifications, audit history, or recurring assignments.
Templates found online can save setup time, but inspect them before entering real records. Check that formulas cover all task rows, dropdown values are clear, and any macros or external links are appropriate for your organization. You can also build the basic template yourself using the steps above; a paid template is not required for a simple checklist. Excel features and licensing vary, so confirm that a shared file works for the people who need to open it.
Frequently Asked Questions
How do I make a daily cleaning checklist in Excel?
Enter headings such as Date, Area, Task, Assigned to, and Status; add one task per row; then format the range as a table. Use Data > Data Validation to create a status list, and add a completion formula if you want a summary.
Can Excel automatically create a new checklist every day?
A standard worksheet does not automatically create a fresh dated checklist each day. You can duplicate a clean template sheet or add rows with new dates to a running log. Automation may be possible with tools such as macros or Office Scripts, but it requires setup and should follow your organization’s file and security practices.
How do I count completed cleaning tasks?
If the status values are in F2:F11, use =COUNTIF(F2:F11,"Done"). It counts cells whose value is exactly Done. Keep the dropdown spelling consistent and expand the range if you add more task rows.
Should I use one sheet per day or one ongoing sheet?
Use one sheet per day when printing and simple handoffs are priorities. Use one ongoing table when you need to filter or review several dates together. Repeating the date on every row in a running log makes the records easier to sort and filter.
Can I use checkboxes instead of a status dropdown?
Checkboxes can work for a simple complete-or-not-complete list, but they do not naturally distinguish Not started, In progress, and Skipped. A dropdown is usually clearer when the checklist needs several states or a reason for an exception.
Related
- Clean an Excel Spreadsheet: Steps for Cleaner Data
- Clean Excel File Online: Safe Steps and Best Options
- Clause 34 of Tax Audit Report in Excel: What to Include
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Insert a Row Every Other Row in a ListIn Excel for Microsoft 365 on Windows, select the row header where you want a row inserted and…
- Debt Payoff Spreadsheet Excel Template: Build Your PlanYes. You can build a debt payoff spreadsheet in Excel with columns for each account’s balance, annual interest…
- How to Mail Merge in Word for Personalized Email MessagesTo mail merge in Word for email, prepare a recipient list in Excel, connect it to a Word…
- Excel Header Drop-Downs: Add Filters or Choice ListsTo add a drop-down arrow for sorting or filtering, turn your data into an Excel table: select the…
- Add a Shared Mailbox in Outlook App: Setup StepsTo add a shared mailbox in Outlook, first ask your Microsoft 365 or Exchange administrator to grant your…
- How to Make a Booklet in Word Back to Back PrintingTo make a back-to-back booklet in Word, set the document’s page layout to Book fold, arrange your content…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.