The simplest way to make a checklist in Google Sheets

Open a Google Sheet and type your items in column A, one per row. In column B, add a header like "Done" and leave the cells blank. When you finish a task, type an X or a checkmark in the B column next to it. That is a functional checklist.

If you want something slightly more polished, use Google Sheets' built-in checkbox feature instead of typing manually. Click Insert > Checkbox from the menu, then click the cells in column B where you want checkboxes to appear. Google Sheets will add interactive boxes you can click to mark tasks complete — they toggle between checked and unchecked with a single click.

This approach works because Google Sheets stores your list in one place, syncs across your devices, and lets you share it with others if you need to. You do not need to learn formulas or formatting tricks to get your free guide. The trade-off is that Google Sheets is heavier than a dedicated to-do app — it takes longer to open and navigate — but if you are already using Sheets for other work, adding a checklist there keeps everything in one tool.

Key Takeaways

  • The fastest checklist is a column of tasks with a checkbox column next to it, using Insert > Checkbox to add interactive boxes.
  • You can color-code rows or use conditional formatting to highlight completed tasks automatically, making progress visible at a glance.
  • Sorting and filtering let you show only incomplete tasks or group tasks by category, which a straightforward text list cannot do.
  • Sharing a Sheet with others means everyone sees the same checklist in real time, so you do not have to update people manually.

Adding checkboxes that actually work

Select the cells where you want checkboxes — usually column B next to your task names. Go to Insert > Checkbox. Google Sheets will fill those cells with empty boxes. Click any box to check it; click again to uncheck it. The boxes stay checked until you click them again, even if you close the Sheet and come back later.

If you want checkboxes in multiple columns or scattered across your Sheet, select each range separately and repeat the process. You can also delete checkboxes the same way you inserted them: select the cells, go to Insert > Checkbox again, and the option will remove them.

Making completed tasks stand out with color

Conditional formatting automatically changes the color of a row when you check its box, so you can see at a glance what is done. Select the rows that contain your tasks (usually A2 through B100, or however many rows you need). Go to Format > Conditional formatting. Under "Format rules," choose "Custom formula is" and paste this formula into the box:

=ISBLANK(B2)=FALSE

This tells Google Sheets to color any row where column B is not empty — meaning the checkbox is checked. Pick a color from the fill options (light gray or light green works well), then click Done. Now whenever you check a box, that row will automatically turn the color you chose.

If you want checked tasks to move to the bottom instead of just changing color, you can sort by column B. Click the column header, then Data > Sort range. Choose to sort by column B in descending order, and all checked items will sink to the bottom while unchecked tasks stay at the top.

Organizing tasks by category or priority

Add a third column — call it "Category" or "Priority" — and type labels like "Urgent," "Home," "Work," or "This Week." You can then filter your Sheet to show only certain categories. Click Data > Create a filter. Small filter buttons will appear in your header row. Click the filter button in the Category column and uncheck the categories you want to hide. Only the tasks you want to see will display.

This is useful when you have a long list and want to focus on one area at a time. You can also sort by priority: click the filter button, choose "Sort Z → A" or "Sort A → Z," and your tasks will reorder by the labels you chose. The checkboxes and colors will move with them, so your progress tracking stays intact.

Sharing your checklist with others

Click the Share button in the top right corner of your Sheet. Type the email addresses of people you want to add, choose whether they can view, comment, or edit, and send the invite. Everyone you share with will see the same checklist and can check boxes in real time. If one person checks a task, everyone else will see it checked when ready.

This works well for household chores, team projects, or any task list that more than one person needs to track. You can also share a link instead of typing individual emails: click "Change to anyone with the link," copy the link, and send it however you want. Anyone with the link can open the Sheet without needing a Google account, though you can restrict them to view-only if you do not want them editing.

When a checklist in Sheets makes sense, and when it does not

Use a Google Sheet checklist if you are already using Sheets for budgets, inventory, schedules, or other structured data. Keeping your checklist in the same file means you can reference other information without switching tools. It also works well if you need to share the list with others or access it from multiple devices.

Do not use Sheets if you need reminders, due dates, or notifications. Google Sheets does not send alerts when a task is due. If you need those features, a dedicated to-do app like Google Tasks, Todoist, or Apple Reminders will serve you better. Sheets is also slower to open on a phone than a lightweight app, so if you are checking tasks off constantly throughout the day, a phone app will feel faster.

Frequently Asked Questions

Can I add due dates to tasks in a Google Sheets checklist?

Yes, add a "Due Date" column and type dates in it. Google Sheets will not send you reminders, but you can sort by that column to see what is coming up. If you need automatic reminders, you would need to use a different tool or set up a separate calendar event.

How do I move completed tasks to a different sheet?

You can cut and paste them manually, but Google Sheets does not have a built-in rule to move rows automatically. If you need tasks to move automatically when checked, you would need to use a tool like Zapier or write a custom script, which requires technical knowledge. For most people, sorting checked tasks to the bottom is simpler.

Can multiple people edit the same checklist at the same time?

Yes. Google Sheets updates in real time when you share it. If two people open the same Sheet and one checks a box, the other will see it checked within a few seconds. You do not need to refresh or reload the page.

What if I want to print my checklist?

Go to File > Print. Google Sheets will show you a preview. You can choose to print only certain columns or rows, and checkboxes will print as small boxes. The printed version will not be interactive — you will have to mark items off by hand with a pen.

Can I use formulas to count how many tasks are done?

Yes. In an empty cell, type =COUNTA(B2:B100) to count all checked boxes in that range. To count only checked boxes, use =COUNTIF(B2:B100,TRUE). This is useful if you want to see "5 of 12 tasks complete" at the top of your Sheet.