Updated November 2026
A roommate chore chart template in Google Sheets gives everyone in a shared home one place to see who owns which task and when. In this guide you will set up a simple sheet with a task list, a weekly rotation and a shared view that every roommate can check from their phone. The whole setup takes about 30 minutes.
Step 1: Set up the sheet and list every recurring task
Open a new Google Sheet and name it something clear, such as “House Chores – Weekly.” Start with one tab for the schedule and a second tab for the task list. Write every recurring job in column A of the task tab: dishes, trash, bathroom, vacuuming, kitchen counters, recycling and so on. Group the tasks by frequency (daily, weekly, monthly) in separate columns so nothing gets lost.
Shopping for one? See our guide: 5 Best Google Sheets Chore Chart Options for Busy Families (2026).
Step 2: Build the weekly rotation
On the schedule tab, put the days of the week across the top row and roommate names down column A. Use the task list to fill each cell with one job per person per day or per week. The simplest method is a rotating shift: each week, every roommate moves down one row, so no one gets the same job every time. For a two- or three-person home, rotating weekly is usually enough. For larger households, rotate every two weeks so each person can learn a job before handing it off.
Use a formula to rotate automatically
If you do not want to edit the sheet by hand each Sunday, add a helper column with the formula =MOD(WEEKNUM(TODAY()),3) (change the 3 to match the number of roommates) and use it to offset which name lands on which row. Test it for a few weeks before relying on it, since week-number formulas can shift at the start of a new year.
Step 3: Add fairness and effort weights
Not all chores take the same time. Cleaning a bathroom takes far longer than taking out the trash. Add a column called “Effort” to the task list and score each task from 1 to 3. Then use a SUM formula on the schedule tab to total each roommate’s weekly points. If one person is consistently above the others, move a task to balance the load. Many shared households find that a short monthly check-in works better than arguing over every chore in the moment.
Step 4: Share the sheet and turn on notifications
Click Share, add each roommate’s Google account email, and give them Editor access so they can mark tasks done. Set Viewer access if you want someone to see the chart without changing it. Use a “Done?” checkbox column for each task so progress is visible at a glance. You can also add a reminder through Google Calendar or a phone notification each Sunday to review the upcoming week.
Common mistakes to avoid
- Listing too many tasks. Keep the chart to the recurring essentials and handle one-off jobs separately.
- Skipping the effort scores. Without them, the “fair” rotation often feels unfair within a month.
- Hiding the sheet in a folder no one opens. Pin the link in your group chat or set it as the phone home screen shortcut.
- Changing the rules mid-week. Agree on the schedule first, then review it at the end of each rotation.
- Forgetting to protect formulas. Use Data > Protect sheets and ranges so no one accidentally overwrites the rotation logic.
Recommended gear
A dedicated whiteboard on the fridge can mirror the sheet for roommates who rarely check their phones. View on Amazon
A set of color-coded magnetic clips makes it easy to mark who is on which task at a glance. View on Amazon
A small label maker helps you tag cleaning supply bins by task so the right person always knows where to find what they need. View on Amazon
If you want a starting point with a different layout, see Google Sheets Chore Chart Template: A Practical Guide (2026) and Roommate Chore Chart Google Sheets: A Step-by-Step Setup for Shared Homes. For printable alternatives, Printable Roommate Chore Chart Template: 7 Steps to a Fair Setup covers paper options.
FAQ
How often should roommates rotate chores?
Weekly rotation is the most common choice for two or three people. Every two weeks works well for larger households or for tasks that take longer to learn.
Can roommates edit the same Google Sheet at once?
Yes. Google Sheets supports simultaneous editing, and each person’s changes appear for everyone else in real time. Protecting formula cells helps prevent accidental overwrites.
What if a roommate does not complete their chores?
Raise it at your scheduled check-in rather than in the moment. Point to the sheet as a shared record, then agree on a fix such as swapping tasks or setting a deadline.
Conclusion
A roommate chore chart in Google Sheets works best when it is simple, fair and easy to reach. Build the task list, rotate the schedule weekly and share it with everyone who lives in the home. Review it once a month and adjust the effort scores as your household changes.
