Google Sheets To Do List Template — Free, Simple, Actually Works

A Google Sheets to do list template gives you a sortable, filterable task list with priority, due date, status, and category columns — everything you need to manage tasks without a dedicated app, a subscription, or a learning curve. Most to-do apps add more friction than they remove: time spent learning features, syncing between devices, managing notifications. A spreadsheet skips all of that and gives you exactly what you need.

The real advantage of Google Sheets over a dedicated app is flexibility. You can add any column you need, filter by any field, sort by priority or due date, and share it with anyone who has a Google account. No app gives you that level of control without a paid plan. This guide walks through how to build a to-do list template in Google Sheets that is actually useful — not just a place to park tasks and forget them.

Why Google Sheets beats most to-do apps for a lot of people

Dedicated to-do apps are optimized for speed of capture. Sheets is optimized for visibility and flexibility. If your problem is that tasks pile up and you lose track of what matters, Sheets wins — because you can sort, filter, color-code, and view everything in one grid without clicking through menus.

Sheets is also where a lot of people already live. If your budget, your meal plan, and your schedule are all in Google Sheets, having your task list there too means one fewer app to open. Context switching between tools is a real productivity cost, and a unified workspace reduces it.

The cases where a dedicated app wins: when you need reminders and push notifications, when you are capturing tasks on the go from your phone constantly, or when you are managing tasks across a large team with dependencies. For personal task management and small team coordination, Sheets is hard to beat.

The columns every to-do list template needs

A useful to-do list in Google Sheets has six columns. More than this becomes maintenance overhead. Fewer than this and the list lacks enough structure to be sortable and actionable.

The most important of these is Status. A to-do list that does not distinguish between done and not done is just a list. Status is what makes it a task management system — you can filter to show only active tasks, hide completed ones, or review what you finished this week.

Building the template step by step

Open a blank Google Sheet. Row 1 is your header row. Type the six column labels: Task, Priority, Due Date, Status, Category, Notes. Bold row 1 and freeze it (View → Freeze → 1 row) so the headers stay visible when you scroll.

Set up dropdowns for Priority, Status, and Category. Select the entire Priority column (click the column letter to select all of it, then deselect row 1). Go to Data → Data validation → Add rule. Under Criteria, choose "Dropdown" and enter your options: High, Medium, Low. Repeat for Status (To Do, In Progress, Done) and Category (Work, Personal, Home, Finance — adjust to your own categories).

Add conditional formatting to Priority. Select the Priority column. Go to Format → Conditional formatting. Add three rules: cells equal to "High" get a red background, "Medium" gets yellow, "Low" gets green. Now priority is visible at a glance across the whole list.

Add conditional formatting to Status. Select the Status column. Add a rule: cells equal to "Done" get a grey background and grey text. This visually fades completed tasks without hiding them — you can still see what you finished while keeping focus on what remains.

Freeze and sort. With the header frozen, you can sort the sheet by any column at any time: Data → Sort range → sort by Due Date (ascending) to see what is coming up next, or sort by Priority to see what matters most. These sorts are non-destructive — you can re-sort any time without losing data.

Filtering to see only what matters right now

Sorting shows you the full list in a new order. Filtering shows you only the rows that match a condition. Both are useful — but filtering is what makes a long to-do list manageable on a busy day.

Turn on filters by clicking the filter icon in the toolbar (or Data → Create a filter). A dropdown arrow appears in each header cell. Click the Status dropdown and uncheck "Done" — now you only see active tasks. Click Priority and show only "High" — now you see only your high-priority active tasks. That is your daily focus list.

You can also filter by Category to separate work tasks from personal ones when you need to be in a specific mode. Filter to "Work" on a work day, "Personal" on the weekend. The tasks do not move — you are just choosing what to see.

One useful filter view setup: create a named filter view (Data → Filter views → Create new filter view) called "Today's Focus." Set it to show only tasks where Status is not Done, Priority is High or Medium, and Due Date is on or before today. Save it. Now one click gives you exactly the list you need to start each morning.

The weekly reset habit

A to-do list that is never cleared becomes a guilt archive. Tasks pile up, the list grows unmanageable, and the system stops being useful. The weekly reset prevents this.

Every Sunday (or Friday afternoon if you prefer to end the week clean), spend ten minutes on the list:

Archive completed tasks. Create a second tab called "Done." Move any rows marked Done from the main list to the Done tab. This keeps the active list short and gives you a searchable record of completed work without cluttering the main view.

Review what did not get done. Any tasks that carried over from last week — why? Are they genuinely lower priority than they seemed? Do they need to be broken down into smaller steps? Are they blocked on something? A task that carries over three weeks in a row is either not a real priority or is too vague to action. Either remove it or rewrite it as a specific, doable step.

Add next week's tasks. Anything you know is coming up — meetings to prepare for, deadlines, errands — goes on the list now with a due date and priority. Starting the week with a pre-populated list is a different feeling than starting with a blank sheet and trying to remember everything.

Pair the to-do list with a time blocking template for a complete weekly system: the to-do list holds everything that needs doing, the time block schedule shows when you will do it. Tasks without scheduled time tend not to get done.

Writing tasks that actually get done

The format of a task determines whether it gets done. Vague tasks get deferred. Specific tasks get completed.

The most common mistake is writing a project as a task: "Website redesign," "Tax return," "Catch up with Mark." None of these is actionable. You open the list, see the item, feel vague dread, and move on to something else.

Every task should describe a single, concrete action that can be completed in one sitting:

If a task feels too big to write specifically, it is a project — break it into its first two or three concrete steps and add those instead. You do not need the whole project on the list, just the next action.

For a structured daily view that pairs with your task list, a daily planner template gives you a time-blocked schedule alongside your priority tasks — so you are not just tracking what needs doing, but planning when you will do it.