Checking tasks off your to-do list feels pretty awesome, right? If only everything in life gave you that instant sense of accomplishment!
A task list earns its keep by helping you schedule, assign and track all the work that needs to be done for a project. You can also use it to give stakeholders and team members at-a-glance updates on project progress.
With TeamGantt’s free task and to-do list template, you can keep up with all the tasks you need to knock out—whether you’re focused on an important work assignment or just want to finish up a few projects around the house. We’ve done all the hard work so you can have all the fun marking things done.
Ready to get started? Download your free task checklist template, and we’ll show you just how easy it is to take your task list from to-do to ta-da!
Let's take a look at what we'll cover on this page:
- How to use your Excel to-do list template
- Customizing your task list template
- How task checklists are quicker with TeamGantt
At TeamGantt, we know how important it is to ensure projects get done on time and on budget. That's why we created this Excel project task list template to make tracking progress a breeze.
Make this task tracker template your own by adding to-do list items and tasks, assigning task owners, and tracking task status, budgets and costs. Here’s how.
First, find the Task Name column on your worksheet, and enter a descriptive name for each task you want to track for a particular day of the week.
This sample to-do list template features four different status options—with icons as easy visual cues—so you can see where each task is at a glance: Not Started, In Progress, Complete and On Hold.
To assign a status to a task, click on the status dropdown menu in that task’s row, and choose the status that applies to the task you’re working on.
Delivering work on time is one sign of project perfection. Set clear expectations for your team by entering the deadline for each task in the Due Date column.
Every task deserves someone special to call its own. Otherwise, it’ll never feel complete.
Start by specifying which team or department will carry out the work using the Task Type column. Then pair each task with its rightful owner by entering the team member’s name into the Assigned to column.
Staying on budget is just as important as finishing a project on time. Use the Hours Budgeted column to let team members know how much time has been budgeted for each task.
Once a task is complete, log the time spent on it in the Actual Hours column.
We’ve designed this project task template to track your weekly to-do list. But you can create additional task lists for monitoring daily and monthly to-dos.
Click Insert > Sheet > Blank Sheet to add a new worksheet. Then give each row and column a header label, and use the formatting tools to design your own daily or monthly task tracker
Once you’ve got the basics squared away, feel free to customize your Excel to-do list template to ensure it fits your project needs. You can add a title, switch up the colors, add or delete new rows and columns, or even dress your to-do list up with your company logo. The possibilities are endless!
We’ve titled this checklist template “Weekly Task List.” As exciting as that moniker may be, we bet you’ll want to give your to-do checklist your own snazzy (and specific) name.
1. To add or edit the title of your project task list template, double-click your cursor into cell A-2.
2. Enter a new title for your task list. Feel free to include the project name and date range in your title so there’s no doubt what this to-do list tracker covers.
3. Format the header text using the same formatting tools you’d use to format any other text in the worksheet.
Want to apply your own brand colors to your task list? Or make it easy to tell Tom’s tasks from Bill’s? No problem!
1. Click to highlight the cell, row, or column you want to change.
2. Go to Format > Cells, and select the Fill tab.
3. Click on the Background Color dropdown, and choose the new color you want to apply to the cell, row or column you’ve highlighted.
We’ve outlined a few basic to-do list categories to get you started. But there may be other details you need to track along the way. For example, you might want to add a priority column. Or maybe your Monday has a lot more to-dos than the other days of the week.
1. To insert a new row, click Insert > Rows. A new row will be added above the one you currently have selected, using the same formulas and formatting of the row above.
2. To insert a new column, go to Insert > Columns. A new column will be added to the left of the one you currently have selected, using the same formulas and formatting of the column to the left.
We may have included details you simply don’t need to track. That’s okay! Deleting extra info won’t hurt our feelings a bit.
1. To delete an existing row, click on the row you want to remove. Go to Edit > Delete, and choose Entire Row.
2. To delete an existing column, click on the column you want to remove. Go to Edit > Delete, and choose Entire Column.
Want to give your project task list template some personal flair? Add your company logo to the worksheet.
1. Right-click on the TeamGantt logo/header image in row 1, and select Change Picture.
2. Choose the image file you want to add to the worksheet, and click the Insert button.
By the time you finish customizing your to-do list template, it’ll be so pretty you just might want to print it out and pin it to the wall—and we don’t blame you.
1. First, let’s set the print area. Simply click and you're your cursor to highlight all the cells you want to print out. Then go to File > Print Area > Set Print Area.
2. If you want to adjust the scale of the checklist to fit on a single page, click on the Page Layout tab. Then go to Margins > Custom Margins and select the Page tab.
3. Once you’ve set the print area and adjusted the scale of your checklist, you’re ready to send your task list to the printer. Click File > Print.
Want to take the tedium out of to-do lists? Give TeamGantt’s online gantt chart software a try, and create customized task lists in minutes.
With TeamGantt, it’s easy to collaborate on work and streamline workflows. Here are just a few of the handy features you—and your team—will have at your fingertips:
And because it’s live and web-based, everyone on the team can update tasks in real-time. No more juggling a million different spreadsheets or scrambling to capture last-minute updates before a big meeting!
Sign up for your free account and get started. (No strings attached, we promise!) Once you’re in, here’s a sneak peek at just how easy it is to create and manage task lists in TeamGantt.
1. Before you can set up tasks, you’ll need to create a new project. Once you log in, click My Projects in the sidebar.
2. Click New Project.
3. Enter a descriptive name for your project.
4. Then choose a template to use (or start from scratch with a blank project).
5. Finally, select which days of the week you want to assign and track work for this project.
6. Once you’ve made your choices on this screen, click Create New Project to save your changes.
1. Now that you have a project, it’s time to set up your task list! We chose the Basic Template for our example, which gives us two task groups to start out.
2. Simply click on each task group placeholder to rename it.
3. If you need to add more task groups, click +Group of Tasks, and enter the name of your new task group in the blank that appears below.
4. Click on each task to give it a new name and assign it to a team member. Use the drag-and-drop features to adjust the timelines for each task.
5. To add a new task, click +Add Task and enter a name in the blank that appears below.
6. To delete a task, click the X that appears to the right of the task name.
Dependencies enable you to control the order of tasks if one task has to wait for another to get done before it can begin. For example, a designer may not be able to design a landing page until the content’s been written.
1. To add a dependency, click on the gray dot to the right of the first task in the gantt chart.
2. Then drag the dependency line to connect it to the dependent task below.
To change the color of a task, hover over the task, and choose a new color by clicking on the colored square that appears to the right of the task.
This is just a preview of all the fun you can have with task lists on TeamGantt—but there’s so much more to see! Sign up for your free TeamGantt account today to learn all about the project management possibilities you could have at your fingertips.