Laundry List Template in Excel: Build and Use One

How-to basics · Updated November 20, 2026

Yes. A laundry list template in Excel can track clothes or household laundry tasks by date, load, person, status, and optional cost. In Microsoft Excel for Microsoft 365 on Windows, create a header row, turn the range into a table with Insert > Table, then add filters and dropdowns so the list is easy to update and sort.

What a laundry list template can track

A laundry list is not limited to a checklist of garments. People use one to remember which items need washing, organize loads among household members, track trips to a laundromat, or divide recurring laundry tasks. Before building the sheet, decide which job it should do. A short list for one person needs fewer columns than a shared household log or a record of paid laundry services.

For a basic household list, each row can represent one item or one load. An item-based list might record a clothing item, its owner, and whether it is dirty, being washed, or ready to put away. A load-based list might record a date, load description, cycle, and completion status. Pick one meaning for each row and use it consistently; mixing individual garments and whole loads in the same rows makes counts and summaries harder to interpret.

Useful optional details include a wash temperature, special-care note, stain reminder, detergent needed, or cost. Do not collect information just because there is a blank column available. More fields take longer to fill in, and unused fields can make a simple list feel like work.

Set up the worksheet in Excel

Start with a blank workbook and rename the first worksheet to something clear, such as Laundry Log. Put a short title above the list if it helps identify the household or tracking period, but keep the actual column headings together in one row. For example, begin the table in cell A1 with these headings: Date, Person, Load or Item, Quantity, Cycle or Service, Status, and Cost.

  1. Enter one heading in each cell across the first row. Avoid merged cells in the table area; merged headings can interfere with sorting and filtering.
  2. Enter a few sample records beneath the headings, with one load or item per row. Use real dates in the Date column and numbers in Quantity and Cost.
  3. Select a cell in the range and choose Insert > Table. Check that My table has headers is selected, then choose OK.
  4. Use the filter arrows in the headings to show, for example, only a particular person’s items or rows that are not done.
  5. Save the workbook with a recognizable name and add new records below the table as they arise.

Excel tables are useful here because they keep the header filters available and normally extend when you type directly below the table. They also make it easier to apply a consistent style. In Excel for Mac, the Insert > Table command is also available from the ribbon; ribbon placement and appearance can vary slightly by release. Excel for the web has table tools too, though some ribbon controls may be arranged differently.

Choose columns that fit your routine

A template works best when its columns answer practical questions quickly: what needs doing, who is responsible, and what remains unfinished? A compact list could use Item, Owner, Priority, and Status. A family load log could use Date, Person, Load, Cycle, Status, and Notes. For a laundromat record, add a service or machine field and a cost field if you want to compare spending over time.

Here is a sample load-based record. The details are illustrative, not a recommended washing instruction for every fabric:

  • Date: 11/03/2026
  • Person: Sam
  • Load or Item: Towels
  • Quantity: 1 load
  • Cycle or Service: Household wash
  • Status: Ready to fold
  • Cost: blank, if no cost is being tracked

Use a Notes column for exceptions that matter, such as an item needing a separate wash or a stain that needs attention. Keep notes brief and specific. If instructions are important, follow the garment label and the detergent or appliance guidance rather than treating a spreadsheet note as a substitute for care directions.

Decide whether dates mean the day an item was added, the day it was washed, or the day it is due. Label the column accordingly if confusion is likely. Likewise, define quantity: it could mean number of garments, number of loads, or number of service bags. A clear unit in the heading, such as Garments or Loads, avoids misleading totals.

Add status dropdowns and filtering

A dropdown helps everyone use the same status wording. Without one, entries such as done, finished, complete, and washed can split what should be one category. In Excel for Microsoft 365 on Windows, select the cells in the Status column, choose Data > Data Validation, set Allow to List, and enter a short comma-separated list in the Source box, such as To wash, Washing, Ready to fold, and Done. Confirm the dialog to apply the list. If the list is long or shared across multiple sheets, put its choices in a separate range and use that range as the source instead.

Keep status choices mutually understandable. For example, Ready to fold means the wash is complete but the task is not fully put away, while Done means the whole task is finished. If you only need a yes-or-no checklist, use simpler choices such as Open and Done. Make sure the choices match the steps your household actually uses; unnecessary stages make updates slower.

Once the list is a table, use its heading filters to focus on a person, status, or date. This is often more useful than creating separate worksheets for each family member, because a single table can be filtered without duplicating records. To see unfinished tasks, open the Status filter and select the relevant values. Clear the filter when you want to return to the full list.

Track optional costs and totals

For most household laundry, cost tracking is optional. It can be useful when recording laundromat visits, wash-and-fold orders, or shared expenses. Enter costs as numbers in the Cost column and apply a currency format using Home > Number Format. Leave a cell blank when no charge applies, rather than typing words such as free into a numeric column; text can complicate calculations.

For a basic total, suppose costs are in G2:G100, with one cost per record. Enter =SUM(G2:G100) in a cell outside the table. If the example costs are $4.50, $3.00, and $2.50 and the other cells in that range are blank, the formula returns $10.00. SUM ignores blank cells, so the range can include unused rows. If you add more than 99 records, expand the range or place the total below the table and use a table-based total row.

A total is only as meaningful as the records behind it. Decide whether the cost represents a whole visit, a single load, or one person’s share. If a receipt covers several loads, entering the full amount on every load would overstate the total. You could instead make one row per paid visit, or divide the charge among loads using a consistent method and label the field clearly.

Make the list easier to read and print

Use short headings, sensible column widths, and a readable font size. For longer lists, freeze the heading row with View > Freeze Panes > Freeze Top Row so the column labels remain visible while you scroll. Use a restrained table style with clear contrast, and avoid relying on color alone to communicate status; text labels are easier to interpret and more accessible.

Conditional formatting can make outstanding work easier to spot. Select the relevant Status cells and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, then enter a status such as To wash and choose a format. Repeat only for a small number of important statuses. Too many colors can make the sheet noisy, and a rule may not help if users enter inconsistent spellings; dropdowns reduce that problem.

Before printing, check the print preview and page breaks. Choose the worksheet area you need and use Page Layout options to set orientation or scaling if columns would otherwise spill onto extra pages. A wide log may fit better in landscape orientation. If the sheet is a living record, consider printing only the current filtered tasks rather than several pages of completed history. Keep enough space for handwritten updates if the paper copy will be used away from a computer.

Common problems and simple fixes

  • Sorting separates information: Sort using a heading filter or select a cell inside the table. Do not sort only one column, because that can detach names or statuses from their records.
  • Dates sort strangely: Check that entries are actual Excel dates rather than text. A date typed in an ambiguous format can be interpreted differently under different regional settings. Choose a consistent date format for the workbook.
  • Dropdowns are missing on new rows: Confirm that validation was applied to the whole table column, not just one cell. When adding rows, check that the new cells retain the validation rule.
  • The list becomes hard to maintain: Remove columns nobody uses and archive old records if the active list gets unwieldy. If you need to keep a history, move older rows to an archive sheet rather than deleting information you may still need.
  • Several people overwrite changes: Agree on who updates the shared copy and avoid saving separate versions with similar names. If the workbook is shared through OneDrive or SharePoint, use the shared file rather than emailing copies back and forth.

One common misconception is that a laundry list must be an inventory of every garment. That level of detail is usually unnecessary for routine household washing. A load-level log is quicker to maintain; an item-level list is more appropriate when tracking uniforms, delicate garments, a move, or a service handoff where individual pieces must be accounted for.

Excel template, paper checklist, or app?

Excel is a good fit when you want a customizable list, sortable history, or simple totals without adopting a dedicated laundry app. It can be adapted to household tasks as well as garment tracking, and users can add fields as their needs change. Its main trade-off is that someone has to maintain the workbook and keep the shared copy current.

A paper checklist is quicker for a small, fixed routine and does not require a device, but it is harder to search, sort, or total. A household task app may be more convenient when reminders and phone notifications matter, though its features, cost, and sharing options depend on the particular app. Choose based on the job: use Excel for flexible records, paper for a simple visible reminder, and an app when notifications or mobile collaboration are central.

There is no need to build a complicated dashboard for a basic list. Start with a small table and use it for a week or two. If you repeatedly need to answer a question the sheet cannot answer, such as which service costs the most or who has the most unfinished tasks, then add a field or summary that addresses that specific need.

Frequently Asked Questions

Does Excel have a laundry list template?
Excel’s available templates can vary by version and account, so a dedicated laundry template may not appear in every installation. You can make a basic one quickly by entering headings in a blank worksheet and choosing Insert > Table, or search the template gallery for a household checklist that suits your needs.

What should I put on a laundry checklist?
For a simple checklist, use Item, Owner, and Status. Add a date, load or cycle, notes, or cost only if you will use that information. Keep each row consistent as either one item or one load.

How do I make a laundry list with checkboxes in Excel?
A status dropdown is a straightforward alternative that works well for filtering and sorting. Excel for Microsoft 365 also has checkbox features in some builds, but their availability and ribbon placement can depend on the update channel. If using checkboxes, confirm they are available in your Excel version and consider whether a text status will be easier to filter and share.

Can I use the same laundry template for a family?
Yes. Add a Person column and use one shared table, then filter by person or status. Agree on consistent names and status choices, and store one shared workbook if several people need to update it.

How can I total laundromat costs in Excel?
Put numeric charges in one Cost column and use a SUM formula over that range. Keep the meaning of each charge consistent, such as one row per visit, so the result represents the spending you intend to track.

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.