Reviewed & updated by WordNExcel Team — Updated November 10, 2026
A task list is a simple way to write down everything you need to do, decide what matters most and track it until it is done. Whether you are organising your own day, a small team or a project, a good task list keeps work visible and stops important jobs from slipping. On this page you can download five free task list templates in Excel: a to-do task list with priorities and overdue flags, a project task tracker with owners and progress bars, and a daily task checklist for repeating weekly routines, plus a team shared task list and a recurring task checklist.
Each file is a real, editable .xlsx spreadsheet. Drop-down menus, formulas and colour rules do the tracking for you, so you can see at a glance what is overdue, what is due soon and how much is complete.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Task List?
A task list, or to-do list, is a list of actions with enough detail to get them done: what the task is, when it is due, how important it is and whether it has been finished. A spreadsheet task list adds useful features that paper cannot, such as sorting by due date, filtering by status and automatic warnings for late tasks.
Task lists help you:
- Get tasks out of your head so you can focus.
- Prioritise the work that matters most.
- Meet deadlines with clear due dates and warnings.
- Share work with a team and see who owns what.
- Track progress and feel the satisfaction of finishing tasks.
Download Free Task List Templates
The templates open in Microsoft Excel, Google Sheets and LibreOffice Calc.
1. To-Do Task List

A clean list with twenty-five numbered rows. Each task has a priority (High, Medium or Low from a drop-down), a due date and a status (Not started, In progress or Done). The Flag column compares the due date with today’s date and shows “OVERDUE” in red for late tasks, or “Due soon” for tasks due within two days. A summary panel counts total tasks, done, open and overdue tasks and shows the percentage complete.
2. Project Task Tracker

For small projects and teams. Each row has the task, owner, start date, due date, percentage done and notes. A green data bar fills the % done cell so progress is easy to see. The Days left column counts down to the due date and goes blank once a task reaches 100%. At the bottom, the sheet shows overall progress as an average of all tasks and how many tasks are complete.
3. Daily Task Checklist

For routines that repeat every day, such as opening a shop, office admin or household jobs. List each task with a time and owner, then tick it off under Monday to Sunday. The sheet counts how many tasks were done each day and shows the week’s completion percentage. Print a fresh copy each week or clear the ticks and reuse the file.
4. Team Shared Task List

The list a team reviews in a stand-up: each task has one owner, a due date, a priority, a status and a note. Blocked rows highlight, and the header counts work that is not yet done. Personal daily tasks can stay on a daily checklist; this sheet is for work that other people need to see. Change a blocked task the same day. One owner per row is kinder than a shared “we” that nobody starts.
5. Recurring Task Checklist

For work that comes back on a rhythm — payroll, a backup test, a fire alarm test, an invoice run. Enter the cadence, when it was last done and when it is next due, and tick the cycle when it is finished; then move the dates forward and set the tick back to N. Overdue rows highlight when you open the file. This stops recurring work from cluttering the main to-do list, and from being remembered only when it has already slipped.
What to Include in a Task List
- Task name: a clear action that starts with a verb, such as “Call”, “Send” or “Book”.
- Priority: how important or urgent it is.
- Due date: when it must be finished.
- Status: not started, in progress or done.
- Owner: who is responsible, for team lists.
- Start date and progress for larger tasks.
- Notes: links, contacts or details needed to finish the task.
How to Use the Task List Template
- Download the template that fits how you work and open it in Excel or Google Sheets.
- Delete the example tasks.
- Write every task you can think of. Do not worry about order yet.
- Give each task a priority and a due date.
- Sort by due date or priority to decide what to do first.
- Update the status as you work. Change it to Done when finished.
- Check the Flag or Days left column every morning for overdue and upcoming tasks.
- Review the list once a week, remove tasks that no longer matter and add new ones.
How to Prioritise Tasks
A long list can feel overwhelming. A few simple methods help you decide what to do first.
- High, medium, low: the method built into the to-do list. Do high-priority tasks first, then medium.
- Urgent vs important: sort tasks into four groups: urgent and important (do now), important but not urgent (schedule), urgent but not important (delegate), and neither (drop).
- Eat the frog: do the hardest or least pleasant important task first thing in the morning.
- Three most important tasks: pick three tasks each day that would make the day a success, and do those before anything else.
- Time blocking: reserve time in your calendar for important tasks so they do not get crowded out.
Tips for Writing Better Tasks
- Be specific. “Plan marketing” is too vague. “Draft three social media posts for the November sale” is clear.
- Break big tasks into steps. Each step should take no more than a few hours.
- Add a due date to everything that has one, and be realistic.
- Keep one list, not notes spread across apps, emails and sticky notes.
- Include the next action. If you are waiting for someone, write “Chase Sara for figures”.
- Celebrate progress. Marking tasks as done builds momentum.
Using a Task List With a Team
A shared task list in Google Sheets or Microsoft 365 keeps everyone aligned.
- Give every task one owner, even if several people help.
- Agree on what each status means, especially “Done”.
- Review the list together in a short weekly meeting.
- Use the notes column for blockers and decisions.
- Filter by owner so each person sees their own work.
The project task tracker is designed for this, with an owner column, start and due dates and an overall progress figure for status reports.
Task List vs Checklist vs Project Plan
A task list collects one-off actions with due dates and priorities. A checklist is a set of steps you repeat the same way each time, like the daily task checklist on this page. A project plan is a larger document that covers goals, phases, timelines, budgets and risks. Many people use all three: a project plan for the big picture, a task tracker for the work, and checklists for routines.
Setting Up Your Weekly Review
A task list only works if you keep it up to date, and the easiest way to do that is a short weekly review. Pick the same time each week, such as Friday afternoon or Monday morning, and spend fifteen to twenty minutes on your list. Mark finished tasks as Done and look at the summary to see how many tasks you completed. Check every open task: is it still needed, is the due date still realistic, and is the priority right? Move or delete tasks that no longer matter. Then look ahead at the coming week, add new tasks from emails, meetings and notes, and choose the few tasks that matter most. Over time, the review shows patterns, such as tasks that are always postponed, which may need to be broken into smaller steps or handed to someone else.
Customising the Templates
Each template is easy to adapt. To add more rows, select the last row, copy it and insert copied cells below so the drop-downs and formulas come with it. To change the priority or status options, edit the list under Data, Data Validation. You can add columns for category, client, estimated time or cost, and filter by them later. If you prefer different warning colours, open Conditional Formatting, Manage Rules and choose new fill colours. In the daily checklist, rename the day columns to dates if you want a dated record for each week, and save a copy each week as a simple history of what was done.
Choosing the Right Task List
Pick the to-do task list for personal or small-team work with priorities and due dates. Pick the project task tracker when tasks have owners, start dates and progress you need to report. Pick the daily task checklist for routine jobs that repeat every day of the week, such as opening and closing duties or cleaning rounds.
Related Templates
You can also check these useful templates like the weekly report templates for reporting progress, and the project plan templates for planning larger pieces of work.
You may also like the daily planner templates and the weekly calendar templates.
Frequently Asked Questions
How do I make a task list in Excel?
Download a free template above, delete the examples and add your tasks with priorities, due dates and statuses. The formulas flag overdue tasks and count progress.
How does the overdue flag work?
The to-do list compares each task’s due date with today’s date. If the date has passed and the task is not marked Done, it shows OVERDUE in red.
What should a task list include?
A clear task name, priority, due date and status, plus an owner, start date, progress and notes for team or project lists.
Can my team share this task list?
Yes. Upload the .xlsx file to Google Drive or OneDrive and share it so everyone can update their tasks.
What is the difference between a task list and a checklist?
A task list tracks one-off actions with due dates. A checklist is a set of steps you repeat, such as daily routines.
