Skip to content
Priority To-Do List cover: a sample sheet with tasks, open and done and a doughnut chart, beside the Dashboard and Tasks tabs

Priority To-Do List

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Priority To-Do List suits anyone who juggles work and home tasks and wants the most important items at the top. The Tasks tab gives every task a line showing its area, priority, due date, estimated hours, status and notes. Overdue tasks turn red until they are done. The Dashboard counts tasks, open and done items and high priority work still to finish, with breakdowns by priority and by area.

The sample list mixes work, home, admin, errands and health tasks, with a few already done and a few past due, so the colors and counts show what the sheet does. Keep the list short, with no more than about twenty open items at a time. Check priorities each week, and mark a task Done as soon as it is finished rather than deleting it, so the counts stay honest.

Useful for

  • Ranking the week's tasks by how urgent they are
  • Keeping home and work errands in one list
  • Seeing which high priority items are still open

What's included

  • 3 tabs: Dashboard, Tasks, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Tasks: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Tasks tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I sort the list by priority?

Turn on the filter on the header row of the Tasks tab, then sort by the Priority column. In Excel, use Sort and Filter. In Google Sheets, use Data and then Create a filter. Sorting changes the order of the rows, but the Dashboard counts stay the same.

Why did a task turn red?

Red means the deadline is behind you and the status is not Done. Mark the task Done when you finish it, or push the deadline out if the plan moved. The highlight follows the current day, so it refreshes whenever the file opens.

Does the Priority To-Do List suit one day's tasks?

It works best for tasks that run over days or weeks. For a daily list, clear the Done rows every evening, or move the week's open items into a new file.

  • #project-tracker
  • #to-do-list
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More project tracker templates

See all 8

Also in Project management

All project management templates
Get this template

Preparing your template…