Best way to Create a Checklist in Google Sheets in 2023

Looking for information on how to create a checklist in Google Sheets? You’ve come to the right place! 

Whether you need to add one item or make a whole checklist, Google sheets make it easy. This article explains how to make a checklist in google sheets step by step.

In this blog post, we’ll take a closer look at how you can create a checklist in Google Sheets in a simple and easy way.

How to create a checklist in Google Sheets

Google Sheets is a free alternative to Microsoft Excel that you can use from your browser without having to download anything. It’s a powerful tool, although perhaps not as powerful as Excel.

How to create a checklist in Google Sheets

Google Sheets is a great tool for organizing and analyzing data. With its many features, it can rival even the Microsoft Office suite. One great feature it has is the ability to add a checklist. 

This can be really useful in a variety of situations.

Let’s get started!

Create a checklist in Google Sheets

First, let’s open a new spreadsheet in Google Sheets. We’ll prepare the spreadsheet with the data we need to create a list. Then, we’ll select the column and rows to the right of the list where we want the checkboxes to appear.

How to create a checklist in Google Sheets

After selecting the column and the rows, we will have to click on “Insert” in the toolbar at the top, from here we will have to choose Checkbox.

How to create a checklist in Google Sheets
google spreadsheet checkbox

We only need to do this and we can see the checkboxes appearing where we selected them. All we have to do is press the checkboxes to mark or deselect them. 

If we want more users to be able to select checkboxes, we need to make sure to update the sharing settings to allow full edit access to the spreadsheet. 

Although this checklist is quite basic, we’re pleased to see that Google is still working on improving this interesting and useful tool – especially since it’s free and can be accessed from any device.

As you can see, it’s extremely easy to add a checklist in Google Sheets. Likewise, remember that if you have any kind of doubt about this guide, you can leave it in the comment box that you will find a little further down and we will be happy to help you with anything you need.

Video Guide: Create a Checklist in Google Sheets

How to Insert a Checkbox and create a Checklist in Google Sheets.

Source: Youtube / Ajay Anand – Create a Checklist in Google Sheets

Conclusion: Google sheets checklist

Creating a checklist in Google Sheets is a useful (if basic) feature, and we’re glad to see Google continue to update Google Sheets to add features like this.


How do I make a tick box in Google Sheets?

On your computer, open a spreadsheet in Google Sheets. Select the cells that you want to have tick boxes for. Data validation. Next to ‘Criteria’, choose Tick box.

How do I add a conditional Checkbox in Google Sheets?

To use conditional formatting on checkboxes, select the cells with the checkboxes and go to Format > Conditional formatting. Set up the conditions in the sidebar, under Criteria > Format cells, then choose the format you want to apply under those conditions.

How do I make a checkable checklist?

Open your sheet and Make your list
1. Create your list.
2. Place your cursor at the start of the first line.
3. Go to the Developer tab, and then click Check Box.
4. If you want a space after the check box, press Tab or Spacebar. …
5. Select and copy (⌘ + C) the check box and any tabs or spaces.

How do I put a tick in the box?

Place your cursor at the spot where you want to insert the symbol. Go to Insert > Symbol. Select More Symbols. Scroll up or down to find the checkmark you want to insert.