Updated November 2026

A weekly chore chart in Excel gives you one editable grid for every chore, every person and every day of the week. In about 30 minutes you can set up a tracker that lists tasks down the side, days across the top, and checkmarks or completion counts that update themselves. Once it’s built, you only change the names or tasks when your routine shifts.

Step 1: Set Up the Grid

Open a blank workbook and type your days across row 1, starting in column B: Monday through Sunday. In column A, list each chore on its own row, grouped by person if that helps. Widen column A so longer chore names don’t get cut off.

Shopping for one? See our guide: Free Weekly Chore Chart: 5 Best Magnetic and Printable Picks for Busy Families.

Keep one tab for the active week and a second tab as a blank master copy. You’ll duplicate the master tab each Sunday instead of rebuilding from scratch.

Step 2: Add Checkboxes or Simple Markers

You have two easy options for marking chores done:

  • Checkboxes: Go to the Developer tab, choose Insert, then Check Box, and place one in each cell. If the Developer tab is hidden, turn it on under File, Options, Customize Ribbon.
  • Text markers: Type “Y” or “1” in completed cells, then use conditional formatting to shade them green. This is faster to set up and works on any device.

Step 3: Build the Automatic Counts

Add a total column at the far right. For text markers, use a formula like =COUNTIF(B2:H2,"Y") to count completed days for each chore. For a per-person score, put a row beneath each group and total the rows above it with =SUM().

Want a simple percentage? Divide completed chores by total chores and format the cell as a percentage. Many families find that a visible number motivates better than a checkmark alone.

Step 4: Format for Quick Scanning

  1. Select the grid and apply light borders so each row stands out.
  2. Use conditional formatting: highlight cells containing “Y” in green and cells left blank past today’s date in light red.
  3. Freeze row 1 and column A (View, Freeze Panes) so names and days stay visible while you scroll.
  4. Set the print area to fit one page wide so you can post a paper copy on the fridge.

Step 5: Plan Chore Rotation and Weekly Assignments

If the same person keeps getting the worst job, add a “Rotates” column and shift names each week. You can copy the sheet, then reassign names by hand, or use a simple formula to pull the next name from a list. Keep the rotation rule short, such as “swap bathrooms every Sunday,” so the whole family can remember it.

Step 6: Set a Weekly Review Routine

Pick one fixed time each week, such as Sunday after dinner, to duplicate the master tab, rename it with the date range and review the totals. Five minutes is usually enough. Note any chore that never gets done and either reassign it or cut it. If you want more background, see Daily Chore Chart Excel: 6 Steps to Build a Tracker Your Family Will Use.

Common Mistakes

  • Listing too many chores. Start with 5 to 8 per person and add more only if the routine holds.
  • Forgetting to lock the template tab. Protect it under Review, Protect Sheet so no one overwrites your formulas.
  • Using merged cells. They break sorting and copying, so center text across selections instead.
  • Skipping the master copy. Without it, every new week becomes a rebuild.
  • Expecting kids to update the file. Let them mark a printed copy, then update the digital version yourself.
  • Dry-erase magnetic board: Pairs well with a printed Excel chart so the week’s tasks stay visible on the fridge. View on Amazon
  • Laminated sheet protectors: Let you print the Excel grid once and reuse it with a wipe-off marker. View on Amazon
  • Clip-on chore cards: Useful for kids who like to move a card rather than check a box. View on Amazon

FAQ

Do I need special Excel skills to build a chore chart?

No. Basic typing, borders and a simple COUNTIF formula cover most needs. You can add checkboxes or colors later once the grid works.

Can I share the chart with my family?

Yes. Save it to a shared cloud folder, or print the active week each Sunday and post it where everyone can see it.

How is this different from a printed chart?

A printed chart is quick to start, but Excel automatically totals completed chores, tracks trends across weeks and lets you duplicate a clean template in seconds.

Conclusion

A weekly chore chart in Excel takes one grid, a few checkmarks and a simple total column to set up. Duplicate a master tab each week, keep the list short and review it on the same day every Sunday. You’ll spend less time reminding and more time on the things that matter.

For more setups, see Weekly Chore Chart Template: A Step-by-Step Setup for Busy Moms or Chore Chart Excel Template: 7 Steps to Build a Weekly Tracker.

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.