In this article:

Make a To-Do List in Google Sheets (Easiest Way in 2024)

November 14, 2024

In this tutorial, we will show you exactly how to create a to-do list in Google Sheets. Simply follow the steps below.

todo list google sheets

How to Make a To-Do List in Google Sheets

Follow the steps below to make a to-do list in Google Sheets.

1. Open Google Sheets from the Google Apps Icon

In Google Chrome, click the Google Apps icon (nine dots) in the top-right corner to open the Google Apps menu. Scroll down and select "Sheets" to access Google Sheets.

to do list on google sheets

2. Select the To-Do List Template

Once in Google Sheets, go to the Template gallery. Choose the "To-Do List" template to start with a pre-made list.

how to make a to do list on google sheets

3. Modify the Column Headings to Your Liking

Review and edit the column headings in the template to match your requirements, such as “Task,” “Due Date,” and “Checkbox” for ticking off items.

how to create a to do list in google sheets

4. Input Your Own Tasks and Deadlines

Replace the example tasks with your own. Enter due dates and tick the checkbox for each task completed.

5. Customize and Modify the Template as Needed

Adjust the formatting to your liking by changing colors, fonts, or adding borders. Add or remove elements like checkboxes or extra columns to fit your needs.

6. Access Your To-Do List in Your Google Drive

Your changes are automatically saved in Google Drive. You can access your list anytime from your Google Sheets account.

We hope that you now have a better understanding of how to make a to-do list in Google Sheets. If you enjoyed this article, you might also like our articles on how to use VLOOKUP to find duplicates in Google Sheets and how to make a copy of a Google Sheet without permission.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->