Updated November 2026

A free Excel chore chart gives you a weekly grid for tracking who does what, without buying anything. In this guide you will build a simple chart in Excel or a free spreadsheet app, add checkboxes so kids can mark tasks done, and set it up to repeat every week. Expect the whole process to take about 30 minutes.

Step 1: Plan Your Columns and Rows

Start with a blank workbook and decide what you need to track. Most families do best with one row per chore and one column per day, though you can flip that if you have many kids. Keep the list short at first: five to eight chores per child is plenty. If you want a printable version later, the same structure works for a weekly chore chart template layout.

Shopping for one? See our guide: Free Printable Chore Chart with Money: 5 Best Options for Busy Families.

  • Column A: Chore names (for example, “Make bed,” “Feed pet,” “Empty dishwasher”)
  • Columns B–H: Monday through Sunday
  • Row 1: Headers, with the day names in bold
  • One separate sheet or block per child

Step 2: Add Checkboxes and Dropdowns

Checkboxes make the chart fast to use. In Excel, go to the Developer tab, choose Insert, and select the checkbox control under Form Controls. If the Developer tab is hidden, enable it under File, Options, Customize Ribbon. Copy the checkbox down each row and across each day column.

Dropdowns work well if you want more than a yes or no. Select the day cells, go to Data, then Data Validation, and set the list to “Done, Partly, Skipped.” Kids can pick a status without typing, and you get a clear record at a glance.

Step 3: Build a Weekly Reset and Score

A chart that never resets gets ignored. Duplicate the sheet at the end of each week, rename the tab with the date, and clear the checkboxes on the new copy. This also gives you a running archive if you want to review habits over several months.

For a quick score, add a total row under each child’s chores. Use a formula such as =COUNTIF(B2:B9,TRUE) to count completed checkboxes for a day. Then total the week in a final cell. Many families tie the total to an allowance or privilege, but keep the rules simple and agree on them before the first week begins.

Step 4: Set Up a Layout Your Kids Can Read

Younger children read pictures and colors faster than rows of text. Use cell fill to give each child a color, and add a simple icon or emoji in front of each chore name. Keep fonts large and avoid cramming more than eight tasks into one view. If your child is very young, a visual chore chart built around pictures may be easier to start with, then move to Excel as they learn to read the grid.

Checklist: What You Need

  1. A computer with Excel, or a free spreadsheet app such as Google Sheets or LibreOffice Calc
  2. A list of 5 to 8 chores per child, sorted by time of day
  3. A printer or a shared screen if the chart will be used in a common area
  4. Five minutes at the start of each week to reset the sheet

Common Mistakes to Avoid

  • Making the chart too big. Long lists get skipped, so start with fewer chores.
  • Forgetting to reset. Duplicate the sheet each week rather than clearing the only copy.
  • Mixing kids’ tasks on one sheet. Separate tabs keep scoring clean.
  • Changing the rules midweek. Post the expectations next to the chart and stick with them.
  • Skipping the visual check. Print the chart or pin it where everyone can see it.

A few basic supplies make a spreadsheet chart easier to use around the house.

  • Dry-erase or magnetic chart board: Useful if you print the weekly grid and want a reusable surface on the fridge. View on Amazon
  • Dry-erase markers in several colors: Each child can have a color, which keeps the chart easy to scan. View on Amazon
  • Clear sheet protectors: A printed chart in a protector can be marked and wiped clean each week. View on Amazon

FAQ

Can I make a chore chart in Excel without knowing formulas?

Yes. A basic grid with typed names and day headers needs no formulas. Add a COUNTIF total only if you want automatic scoring.

Do I need Excel, or will a free app work?

A free app such as Google Sheets handles checkboxes, dropdowns and formulas in much the same way. Choose whichever you already have access to.

How do I share the chart with the whole family?

Save the file to a shared cloud folder or print a copy each week and post it on the fridge. Kids can update a printed version with a marker if they cannot reach a device.

Conclusion

A free Excel chore chart takes about half an hour to build and needs only a few columns, checkboxes and a weekly reset. Start with a short list of chores, keep the layout readable for your youngest child, and copy the sheet each week to keep things fresh. Once the routine settles, adjust the chores as your kids take on more responsibility.

Emily Parker

About Emily Parker

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