To-Do List Template (Excel)
A free Excel task list with priority, status and due dates. Overdue tasks turn red and the Summary sheet counts what is open and done.
What is in the To-Do List template
This workbook is a task list that tells you what is late, what is due today and what can wait. It has three sheets: Tasks, Summary and How to use. Nothing needs a macro, so it works in any recent version of Excel and opens in Google Sheets.
The Tasks sheet
Each row is one task with ten columns: number, task, category, priority, status, due date, owner, days left, flag and notes. Category, Priority and Status are drop-downs. Priority is High, Medium or Low. Status is Not started, In progress, Blocked or Done. The number, days left and flag columns are formulas that are filled down to row 104, so you only type in the blue cells.
The Flag column compares the due date with the as-of date and shows one of six values: Overdue, Due today, Due soon, Upcoming, Done or No date. Conditional formatting does the rest. Overdue rows turn red, Due today is amber, High priority is bold red and Blocked tasks get a red fill. When you set a task to Done, the whole row greys out with a strikethrough so finished work stays visible without cluttering the list.
The Summary sheet
The Summary sheet has two yellow input cells: the as-of date and the “due soon” window in days. Type the date by hand for a stable report, or type =TODAY() to follow the calendar. Below them you get tasks by status, open and done tasks by priority, the completion rate, the number of overdue tasks, tasks due today and soon, and the number of High-priority tasks still open. A bar chart shows tasks by status. The chart has no data labels, so it stays clean when you resize it.
The sample data
The file opens with 16 sample tasks for a small business owner, from sending invoices to renewing insurance. The as-of date is set to 6 November 2026. On that date the sample list shows 3 overdue, 2 due today, 2 due soon and 3 done. Delete the sample rows and type your own.
Everything uses plain formulas such as IF, COUNTIF and COUNTIFS, so you can read how each number is built and change it. Nothing is hidden or locked, which means you can add columns, rename categories or change the colors to suit how you work.
How to use it
- Open the Tasks sheet and type one task per row.
- Pick the category, priority and status from the drop-downs and enter a due date.
- Set the as-of date on the Summary sheet.
- Start each day with the red and amber rows.
- Change Status to Done when you finish. The row greys out.
The Tasks sheet is frozen so the header row and task name stay visible as you scroll, and it prints landscape on one page wide with the header repeated. If you manage projects with several steps, the project tracker template is a better fit. For routines that repeat, use the checklist template, and plan your days with the weekly planner template. To build the list from scratch, read how to make a to-do list in Excel.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
Does the to-do list update the overdue flag by itself?
Yes, once you set the as-of date on the Summary sheet. Type =TODAY() in that cell and the flags follow the calendar. Otherwise change the date by hand.
How many tasks can I add?
The formulas and drop-downs are filled down to row 104, which gives you 100 tasks. Copy the last row down if you need more.
Can I change the categories or statuses?
Yes. Select the drop-down cells, open Data Validation and edit the list. If you rename Done, also update the formulas that look for it.
Does it need macros?
No. It uses ordinary formulas, drop-downs and conditional formatting, so it works without enabling macros.
Can I use it in Google Sheets?
You can upload the file to Google Sheets. Formulas and drop-downs carry over, though formatting may differ slightly.
Need a custom calculator or spreadsheet built for your business?
Talk to usMore free tools: All free calculators · Project tracker template · Checklist template · Weekly planner template


