To-Do List Template with Checkboxes (Excel)
Last updated June 2026
Type a task, set a priority and a due date, then tick the Done column with a ✓ from its drop-down — finished items gray out and strike through, while anything past due that isn't done turns red on its own. A side panel counts done, open, and overdue tasks. The whole tracker lives on one Tasks sheet in a free .xlsx workbook.
To-Do List Template with Checkboxes (Excel)
todo-list.xlsx · free · no signup
Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).
SHA-256: 1677d94a501dd492877b84a11f5758125e3a23056eb6fab69d917422f3dc25b9
| A | B | C | D |
|---|---|---|---|
| Task | Priority | Due | Done |
| Email signed contract to client | High | 6/1/2026 | |
| Schedule dentist appointment | Medium | 6/8/2026 | ✓ |
| Prepare slides for team meeting | High | 6/15/2026 | |
| Order printer ink | Low | 6/22/2026 |
What's inside
Sheets
TasksThe whole template: 50 entry rows (2–51) with a Priority drop-down, a Due date column, a ✓ Done column, and anAt a glancecount panel off to the right.
Columns
- TaskWhat needs doing — one row per task.
- PriorityA drop-down limited to High, Medium, or Low so priorities stay consistent and sortable.
- DueThe deadline, formatted as an
m/d/yyyydate (e.g.6/15/2026). Once it passes, an unfinished row turns red automatically. - DoneA drop-down that inserts a
✓. Marking it done grays the row out and strikes it through.
Formulas that do the work
The Done count in the side panel tallies every row marked with a ✓ across all 50 task rows.
The Overdue count adds up rows that have a due date in the past and are not yet marked done — the same logic that turns those rows red.
The % complete cell divides done tasks by total logged tasks, guarding against a divide-by-zero when the list is empty.
How to use it
Type your tasks
Replace the four sample rows in the
Taskssheet with your own. Put one task per row in column A — there are 50 rows ready, and you can insert more.Set a priority
Click a Priority cell and pick High, Medium, or Low from the drop-down. Keeping to the three values lets you sort the list by priority later.
Add a due date
Enter the deadline in the Due column. Once that date passes and the task isn't done, the entire row turns red so it stops getting missed.
Tick tasks off
When a task is finished, click its Done cell and choose the
✓from the drop-down. The row grays out and strikes through, and the side panel counts update.Watch the At a glance panel
The panel to the right of the list shows Done, Still open, Overdue, and % complete — a live read on the whole list without scrolling.
Compatibility
- Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
- LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
- Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.
The priority and ✓ drop-downs and the gray/red row formatting survive Google Sheets import — click any Priority or Done cell after importing to confirm the drop-downs came across.
Frequently asked questions
- How do the checkboxes work in this template?
- The Done column is a drop-down that inserts a
✓character rather than a clickable form control, so it survives Excel, LibreOffice, and Google Sheets without breaking. Pick the✓to mark a task complete. - Why do finished tasks turn gray and overdue tasks turn red?
- Two conditional-formatting rules do it:
=$D2="✓"grays and strikes a done row, and=AND($C2<>"",$C2<TODAY(),$D2<>"✓")reds a row whose due date has passed and is not yet done. - Can I add more than 50 tasks?
- Yes. Right-click a row number inside the list and choose Insert, or select the bottom row and drag the fill handle down. The drop-downs and formatting extend to the new rows automatically.
- How do I sort tasks by priority or due date?
- Select any cell in the list, open Data → Sort, and sort by the Priority or Due column. Because priorities come from a fixed drop-down, sorting groups them cleanly every time.
- Does this to-do list work in Google Sheets?
- Yes. Go to File → Import → Upload and choose the file. The drop-downs, the ✓ marks, and the gray and red conditional formatting all carry over into Sheets.