Free Google Sheets Project Management Template
Keep every task, owner and due date in one shared sheet. The summary rows show overall completion and how many tasks are still open.
What it looks like
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Owner | Priority | Status | Due | % done |
| 2 | Define scope | Priya | High | Done | 2026-11-04 | 100 |
| 3 | Collect requirements | Sam | High | Done | 2026-11-11 | 100 |
| 4 | Design mockups | Lee | Medium | In progress | 2026-11-25 | 60 |
| 5 | Build first release | Sam | High | In progress | 2026-12-16 | 20 |
| 6 | User testing | Priya | Medium | Not started | 2026-12-23 | 0 |
| 7 | Overall completion | 56 | ||||
| 8 | Open tasks | 3 |
What's included
- Owner, priority, status and due date per task
- Overall completion percentage
- Open task count for stand-ups
How to set up the project management template
- 1.Download the CSV and import it into Google Sheets.
- 2.Select the Status column and add a dropdown (Data → Data validation) with Not started, In progress, Done.
- 3.Do the same for Priority with High, Medium, Low.
- 4.Share the sheet with your team so everyone updates their own rows.
- 5.Add a filter (Data → Create a filter) to see one person's tasks at a time.
Questions
- Is a spreadsheet enough for project management?
- For small teams and projects with fewer than ~50 tasks, yes. Pair it with the gantt chart template when timing matters.
More templates
Gantt Chart Template
A simple project timeline for Google Sheets with start and end dates, durations and status.
Get the templateWeekly Schedule Template
An hour-by-hour weekly schedule for Google Sheets that counts how many hours you've booked each day.
Get the templateCRM Template
A simple sales pipeline in Google Sheets with deal stages, probabilities and a weighted forecast.
Get the template