Free Task List Templates For Excel - Vertex42

≡ Vertex42 Logo

• Excel Templates
  • Budget Templates
  • Invoice Templates
  • Project Management
  • Timesheets
  • Business Templates
  • - More Templates -
• Calendars
  • 2026 Calendar
  • Calendar Template
  • Printable Calendars
  • - More Calendars -
• Calculators
• Gantt Chart
  • Gantt Chart Pro
  • Create a Gantt Chart
• Word Templates
  • Legal Forms
  • Resumes
  • Letters
• Education
  • Excel Tutorials
  • 100+ Excel Tips
  • LAMBDA Library
  • Templates for School
• Blog
• ►

Search Icon Home > Excel Templates > Project Management Templates > To Do Lists > Task Lists Task List Templates Track your tasks using simple spreadsheets, by Jon Wittwer, Updated 12/6/2021

The Excel task list templates on this page demonstrate some of the many ways that you can track tasks using a spreadsheet, from simple to do lists to more advanced Gantt charts. These templates demonstrate using icon sets to display priorities, using conditional formatting to display a progress bar, creating a gantt using using a stacked bar chart, and using a check mark to cross out tasks when they've been completed.

Tell me what you think about these templates: Leave a comment on the related blog article "Add Cool Features to Your To Do Lists."

Advertisement

This Page (contents):

• Project Task List
• Simple Task Tracker
• Task List with Gantt Chart
• Task Checklist Template
• Printable Task List Templates

Project Task List Template

for Excel

Download

⤓ Excel (.xlsx) For: Excel 2010 or later ⤓ Google Sheets

License: Private Use (not for distribution or resale)

Description

This spreadsheet demonstrates the use of conditional formatting to highlight the Priority column, to add a progress bar to the % Complete column, and to create a functioning check box via data validation. It also includes columns for entering budget and hours spent on each task.

Update 9/23/2019: Added the Google Sheets version - replaced the icon sets with in-cell checkboxes. Google Sheets does not yet have in-cell data bars (for the % Complete column).

Advertisement

Simple Task Tracker Template

for Excel

Download

⤓ Excel (.xlsx) For: Excel 2010 or later

License: Private Use (not for distribution or resale)

Description

This task tracker template demonstrates the use of custom icon sets via conditional formatting to show a priority rating of 1-4 with different color circles. It uses a similar technique for the checkbox in the Done column.

Project Task List with Gantt Chart

for Excel

Download

⤓ Excel (.xlsx) For: Excel 2010 or later

License: Private Use (not for distribution or resale)

Description

A gantt chart can be created from a task list using a stacked bar chart in Excel. This is a functional template that can be used for real project management tasks, but the primary purpose is to demonstrate how the data table is set up to create the gantt chart.

Task Checklist Template

for Excel and Google Sheets

Download

⤓ Excel (.xlsx) For: Excel 2010 or later ⤓ Google Sheets

License: Private Use (not for distribution or resale)

Description

This task list template demonstrates how to create a checkbox using a data validation drop-down and how to use simple conditional formatting conditions to display HIGH, MEDIUM and LOW priority values. It also uses conditional formatting to change fonts to a gray strike-through when the checkbox is checked.

► How to Insert a Check Mark in Excel (on youtube)!

More Templates For Tracking Tasks

Action Items Template Gantt Chart Template To Do List Template Homework To Do List

Printable Task List Templates

Multi-Step Task List Prioritized To Do List Daily To Do List

References

• How to Use Conditional Formatting in Excel at vertex42.com
• Create a Drop Down List in Excel at vertex42.com

Follow Us On ...

FB PIN TWEET LI IG YT

Related Templates

Action Items Template Gantt Chart Template Personal Planner Template Critical Path Method Spreadsheet

Project Management

Action Items Template Agile Kanban Board Construction Schedule CPM Template Content Calendar Template Eisenhower Matrix EVM Template FMEA Template Free Gantt Chart Gantt Chart Template Pro Project Budgeting Project Planner Project Schedule Project Timeline Template Project Tracking for Contractors RACI Matrix Risk Assessment Matrix Simple Gantt Chart Task List Templates Timeline Template Timesheet Template To Do List Weekly Time Card Work Breakdown Structure Company About Us Contact Us Support Excel Consulting Products & Services Spreadsheet Templates Word Templates Calendar Templates Excel Articles Education Excel Links Vertex42.com The Guide to Excel in Everything Herriman, Utah Vertex42® is a registered trademark of Vertex42 LLC. Microsoft® and Microsoft Excel® and Microsoft Word® are registered trademarks of Microsoft Corporation. Vertex42.com is not associated with Microsoft. Sitemap | Privacy Policy | Terms of Use © 2003-2026 Vertex42 LLC. All rights reserved.