To-Do List · Free · No account
List tasks and see the next three by priority and due date.
The workbook includes a Tasks sheet and a Focus sheet. Type each task once with its category, status, priority and due date. Focus picks the top three open tasks, lists what is due today and this week, and shows what you finished.
- Excel 2016 and later
- Calculations checked in LibreOffice and Google Sheets
- Name your categoriesGive the list a name and type your categories, one per line. Choose extra columns: Completed on, Assignee, Start or Tag.
- Add tasksDownload the workbook and type each task on the Tasks sheet with a category, priority and due date. A task with no date still counts.
- Open the Focus sheetFocus is worked out from the Tasks sheet. It lists the top three, what is due today and this week, and high-priority work.
Build your workbook
Preview: Household jobs. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
Top three
Open tasks sorted by priority, then the earliest due date. Waiting and deferred tasks stay out of the way.
Due today and this week
● Overdue, ◐ Due today and ◐ Due soon beside each task, and listed on the Focus sheet.
Six statuses
Not started, In progress, Waiting, Complete, Deferred and Cancelled. Finished tasks turn grey.
Recently completed
Type the date a task was done and it appears on the Focus sheet, most recent first.
The Household jobs example
Six categories: Kitchen, Garden, Repairs, Bills, Shopping and Children, with an Assignee column for who is doing each job. The Focus sheet shows the top three, what is due this week and Recently completed.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- TasksEvery task, once. Start typing in row 6.
- FocusThe top three, what is due today and this week, high-priority work and what was finished recently. Worked out from the Tasks sheet.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Google Sheets
- Calculations matched Excel in our testGoogle Sheets removes sheet protection and repeated print headings.
- Apple Numbers
- Some calculations do not workMany calculations on the Focus sheet and the Tasks sheet do not work in Apple Numbers. Numbers converts list-based dropdowns to plain cells and removes colour markers, sheet protection, frozen headings and number and date validation. Use Excel for these calculations and features.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Examples
Household to-do list
Families and housemates who share the jobs and want one list showing what is due and whose it is.
Work actions list
Employees and team leads who need a short, dated list of actions with a name beside each.
Study to-do list
Students managing coursework deadlines and revision alongside reading, who need to see what comes first.
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
How are the top three chosen?
From open tasks, by priority first, High before Medium before Low, then by the earliest due date. Waiting and Deferred tasks are left out.
Can I print the list?
Yes. The Focus sheet prints as a one-page list for the day, and the Tasks sheet repeats its header row on every page.
Can I change the status names?
No. Not started, In progress, Waiting, Complete, Deferred and Cancelled are fixed, because the Focus sheet reads them by name. Categories are yours to change.
What happens to finished tasks?
Set the status to Complete and type the date under Completed on. The row turns grey, and the task appears under Recently completed on the Focus sheet.
Related Due Form edition
DF.035 The Working Notebook
In production
A numbered notebook for notes you may need again.
For plans too long for a task row: write them by hand on numbered pages.
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the To-Do List builder.