Google Sheets Chore Chart Template: Build a Shared Schedule

A Google Sheets chore chart template is a shared spreadsheet for listing household tasks, assigning them, and marking when they are done. Start with a blank sheet, add columns for chores and days, then use Insert > Checkbox to create clickable completion boxes; you can adapt a template from the Sheets template gallery if one suits your needs.

What a Google Sheets chore chart can do

A spreadsheet makes a chore plan visible and adjustable. Unlike a paper chart, a shared Google Sheet can be updated by more than one person, viewed on different devices, and kept for later reference. It can also show whether a job is finished without requiring a separate conversation or a search through messages.

The chart does not need to be elaborate. For a small household, a weekly grid with names, tasks, and checkboxes may be enough. A family with recurring jobs, rotating assignments, or rewards may want extra fields for due dates, frequency, points, or notes. The useful measure is whether people can understand the plan quickly, not how many spreadsheet features it uses.

Google Sheets may offer templates in its template gallery, but the available choices can change and a dedicated chore chart may not appear. A blank spreadsheet is a dependable starting point, and the layout below can be created with standard Sheets features in a web browser.

Choose a layout that fits the household

Decide first how you want to represent work. A weekly grid is easy to scan: chores go down the rows and days of the week run across columns. Each cell can hold a checkbox, so the person responsible can mark the task on the day it is completed. This arrangement works well when tasks recur on particular days.

A task list is a better fit when jobs have different deadlines or happen only once. It can have columns for chore, assigned person, due date, status, and notes. A simple status field can use values such as Not started, In progress, and Done. This format avoids filling a wide grid with empty boxes for tasks that are not scheduled every day.

Before building, settle a few practical details:

Whether assignments belong to individuals, shared household groups, or both.
Whether the chart resets weekly or records completion over a longer period.
Which chores need a specific day and which can be done any time during the week.
Whether points or rewards are genuinely useful, or would add unnecessary administration.
Who is allowed to edit the chart and who only needs to view it.

For example, a two-person household might track dishes, rubbish, and laundry on a weekly grid. A household with young children might add an adult responsible for checking tasks, rather than treating a checkbox as proof that a job was done to an agreed standard.

Build a basic weekly chart

Open Google Sheets in a web browser and choose Blank spreadsheet. Give the file a clear name, such as Household chores – week of November 9. A dated title helps distinguish one week from another if you decide to keep an archive. Then create a header row with a structure such as:

Column A: Person
Column B: Chore
Column C: Notes or standard
Columns D through J: Monday through Sunday
Column K: Completed days

Put one task on each row. If Alex is responsible for taking out recycling on Tuesday and Friday, enter Alex and the chore name in the first two columns, then use the notes column for a useful detail such as place the bin at the curb. Do not put several unrelated chores into one row: separate rows make assignment and progress easier to follow.

Enter the household members and recurring chores in the first columns.
Choose the day columns for tasks that are expected on particular days. Leave other day cells empty when a chore is not scheduled then.
Select the cells where people should mark completion, for example D2:J20.
Choose Insert > Checkbox. Sheets adds checkboxes to the selected cells.
Freeze the header row with View > Freeze > 1 row if the chart is long, so labels remain visible while scrolling.
Adjust column widths, wrap long notes, and use a clear heading style so the chart is readable on a phone as well as a computer.

Keep the first version deliberately small. A chart with a handful of recurring chores is easier to maintain than a comprehensive inventory of every household responsibility. If the initial layout works for a week, add fields only when a real need becomes apparent.

Use checkboxes and completion totals

Sheets checkboxes are useful because they make a status visible and simple to change. By default, a checked box has the value TRUE and an unchecked box has the value FALSE. That means formulas can count checked boxes without requiring people to type words consistently. If the household needs custom checkbox values, Google Sheets also allows values to be changed through data validation settings, but the default TRUE and FALSE values are usually sufficient.

With Monday through Sunday checkboxes in D2:J2 and a completed-days total in K2, enter =COUNTIF(D2:J2,TRUE) in K2. If Monday, Wednesday, and Sunday are checked, the result is 3. Copy the formula down column K for the other chore rows. It counts checked days, not distinct chores, so explain that meaning in the column heading.

To count all checkmarks in a weekly block, with task checkboxes in D2:J10, enter =COUNTIF(D2:J10,TRUE) in a summary cell outside the block. If 21 boxes are checked, the result is 21. That figure is a count of completed task-days; it is not a percentage unless you also define how many boxes were expected to be completed. Avoid interpreting unchecked boxes as failures when a task was not scheduled or was excused.

For a simple list with one checkbox per task, select the status cells and choose Insert > Checkbox. A single checkbox then represents whether that task is complete, rather than completion on a particular day. Pick one method and label it clearly; mixing a weekly grid with an unexplained done checkbox can make the chart ambiguous.

Make the sheet easier to read

Use formatting to make status easier to see, not to decorate every cell. For example, apply a light fill to the header row, bold the names of days, and use a restrained color to distinguish people or task categories. Freeze the top row for a long schedule and use Format > Wrapping > Wrap for notes that would otherwise disappear beyond a narrow column.

Conditional formatting can highlight completed cells automatically. Select the checkbox range, choose Format > Conditional formatting, and set a rule for cells that are equal to TRUE; then choose a subtle fill color. Check that the rule applies to the intended range, especially after adding rows. Color should be supplementary: the checkbox itself and clear labels should still communicate status if someone cannot distinguish the chosen colors.

For accessibility and legibility, avoid relying on color alone, keep text contrast strong, and do not make the sheet so wide that users must constantly scroll sideways. On a phone, a task-list layout can be easier to use than a seven-day grid. Test the chart at the screen size people will actually use.

Share, maintain, and protect the schedule

Use the Share button in the upper-right area of Google Sheets to invite household members or provide access through a link. Choose access deliberately: an Editor can change assignments and data, while a Viewer can read the chart without editing it. A link should not be treated as private merely because it is hard to guess; review the sharing setting and limit access to the intended people.

Agree on how the chart will be maintained. Decide who adds a new chore, when the schedule rolls over, and whether completed weeks should be retained. To preserve history, duplicate the sheet or create a new dated tab for each week. Keeping old weeks can help reveal recurring bottlenecks, but it can also make the file cluttered, so archive only what the household expects to use.

Shared editing is not the same as a formal reminder system. A checkbox does not necessarily notify someone that a chore is due. If reminders matter, use a calendar or another tool alongside the sheet. Also agree on what counts as done: for a task such as cleaning a bathroom, a short note describing the expected result can prevent disagreements that a checkbox alone cannot resolve.

Common problems and practical fixes

The chart is too complicated: Remove fields that no one updates. A weekly plan should be quicker to check than to explain.
People forget to mark tasks: Put the sheet somewhere easy to reach, such as a saved browser bookmark, and agree on a regular check-in. Do not assume that an unchecked box means the task was ignored.
Assignments feel unfair: Review time and effort, not just the number of rows. One large job may take longer than several small ones. Rotate demanding chores when that makes sense.
Checkbox totals look wrong: Confirm that the formula range includes the actual checkbox cells and that the boxes still use the default TRUE and FALSE values.
The sheet becomes hard to use on mobile: Reduce unnecessary columns, shorten headings, or switch to a task list with due dates instead of a wide daily grid.
Old schedules get overwritten: Make a dated copy before resetting checkboxes if past completion records matter.

A chore chart is a coordination tool, not an automatic solution to household disagreements. It helps make expectations visible, but households still need to discuss workload, standards, and changes in availability. If a task becomes unsuitable or someone is away, update the assignment instead of leaving a misleading record.

Google Sheets, Excel, and other options

Google Sheets is a practical choice when several people need to access one live chart and the household already uses Google accounts. Its browser-based sharing and simultaneous editing can reduce the need to send updated copies. The basic spreadsheet layout can also be used in Microsoft Excel, but menu names and sharing workflows differ; the steps above, including Insert > Checkbox and Format > Conditional formatting, refer to Google Sheets.

A printed chart may be simpler for people who prefer a visible reminder on a refrigerator or do not want to use a device. A calendar is often better when chores are tied to appointments or time-specific reminders. Dedicated household or task-management apps may offer notifications and recurring tasks, but features and prices vary by product. A basic Google Sheets chore chart does not require a special paid template; whether Sheets is available to a particular user depends on their Google account and any applicable organization settings.

Frequently Asked Questions

Does Google Sheets have a chore chart template?
Google Sheets has a template gallery, but a chore-specific template may not be available to every user. You can make a reusable chart in a blank spreadsheet with task rows, day columns, and checkboxes, then save a copy for future weeks.

How do I add checkboxes in Google Sheets?
Select the cells where the boxes should go, then choose Insert > Checkbox. A checked box normally stores TRUE and an unchecked box stores FALSE, which allows functions such as COUNTIF to count completed items.

Can multiple family members edit the chore chart?
Yes. Use the Share button to invite people and assign suitable Viewer or Editor access. Editors can change the schedule, so give that role only to people who should be able to alter assignments as well as mark tasks.

How can I count completed chores?
For a daily grid, count the checkbox cells with COUNTIF and TRUE. For example, if the relevant boxes are in D2:J2, =COUNTIF(D2:J2,TRUE) returns the number checked in that row. Make sure the heading describes whether the result counts days, task-days, or tasks.

Can I use the same chore chart in Excel?
The general layout and common counting formula can be recreated in Excel, but its menus, checkbox controls, and collaboration options differ by version. Follow Excel-specific instructions for those features rather than assuming Google Sheets menu paths apply.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.