Updated November 2026

A daily chore chart in Excel gives you a simple grid where each family member’s tasks appear by day, with a box to check off when the job is done. In this guide, you’ll build one from scratch in six steps, then add a checkbox, a completion counter and a color cue so progress is visible at a glance. The whole setup takes about 20 to 30 minutes.

Step 1: Set Up the Layout

Start with a blank workbook. In cell A1, type “Chore” and in B1 through H1, type the days of the week, Monday through Sunday. Column A holds the chore names and each row after that is one task. Keep the headers bold and freeze the top row (View, then Freeze Panes) so the days stay visible when you scroll.

Shopping for one? See our guide: 6 Best Chore Charts for Autistic Adults: Visual Picks for Daily Routines.

Step 2: List Chores by Person

Group chores by family member, not by room. Leave a blank row between people so the sheet is easy to scan. A typical layout for a child might look like this:

  • Make bed
  • Unload dishwasher
  • Feed pet
  • Pick up toys before dinner

Keep each chore short and specific. “Clean room” is vague; “put clothes in hamper” is something a kid can finish and check off.

Step 3: Add Checkboxes and Counters

Insert checkboxes

Select the day cells (B2 through H5, for example), then go to Insert and choose Checkbox in newer versions of Excel. If your version lacks this option, use the Developer tab’s form controls, or simply type a “Y” or a check mark (ü in the Wingdings 2 font) and format the cells as needed.

Add a daily completion count

Below the last chore row, use a formula such as =COUNTIF(B2:B5,TRUE) to count completed tasks for each day. Divide by the total number of tasks for a percentage, formatted as a percent, so the progress is clear.

Step 4: Add Color Cues

Use Conditional Formatting (Home, then Conditional Formatting) to color cells that are done. Create a rule that applies green fill when a cell equals TRUE or “Y.” Red or gray for missed tasks can help too, but keep the palette small. Too many colors make the sheet harder to read.

Step 5: Set a Routine for Updating

Decide when the chart gets updated: right after breakfast, after school, or before bed. Save a fresh copy each week by duplicating the sheet and renaming it with the start date. This keeps old data for reference and avoids editing a file that’s already full of checkmarks.

Step 6: Test and Adjust

Run the chart for three days before judging it. If a chore is never finished, it may be too big or too vague. Split it into smaller tasks, or move it to a different time of day. Adjust the sheet, then keep it for at least two weeks before making major changes.

Common Mistakes

  • Listing too many chores per person. Five to seven daily tasks is a workable range for most kids.
  • Using vague chore names that don’t tell anyone what “done” looks like.
  • Forgetting to freeze the header row, which makes the sheet hard to read on a phone.
  • Skipping the weekly reset, so the sheet fills up and stops being useful.
  • Changing the layout every few days. Consistency matters more than perfection.
  • Dry-erase magnetic board: A printed copy of your Excel chart on a magnetic board lets kids move a token instead of clicking a box. View on Amazon
  • Laminating sleeves: Print the weekly grid, slide it in a sleeve and use a wipe-off marker so the chart can be reused. View on Amazon
  • Wipe-off markers: Fine-tip markers are easier to use on a printed grid than thick ones. View on Amazon

FAQ

Can I make a daily chore chart in Excel without checkboxes?

Yes. Typing “Y” or “X” in each cell works, and conditional formatting can color those cells automatically. The checkbox is a convenience, not a requirement.

How many chores should each child have per day?

Most families find five to seven daily tasks manageable, with a few larger jobs on weekends. Adjust based on age and how the first week goes.

Should I use a daily chart or a weekly one?

Daily charts work well for younger kids who need quick, visible wins. Weekly charts suit older kids who can plan ahead. Many families start daily and move to weekly as habits form. For more ideas, see Weekly Chore Chart Excel: 6 Steps to a Tracker Your Family Will Use.

Conclusion

A daily chore chart in Excel takes about half an hour to build and can run for months with a short weekly reset. Start with a clean layout, keep chore names specific and use one color cue for done tasks. Once it’s working, you can add weekly or monthly views.

Audrey Hayes

About Audrey Hayes

Audrey Hayes is part of our editorial team and reviews and edits our busy-mom life guides, checking product details against manufacturer specifications and owner feedback.