How to manage projects in a spreadsheet
A spreadsheet is a legitimate project tracker for a small team, and it is free. This is the structure that actually works, plus an honest look at the point where it stops working.
1.Set up one row per task, one tab per project
Columns that earn their place: Task, Owner, Status, Priority, Due date, Effort (S/M/L), Notes, and a Link column for the doc or asset. Resist adding more; every extra column is something someone forgets to fill in.
2.Use a five-value status convention
Not started, In progress, Blocked, In review, Done. Add a data-validation dropdown so nobody invents their own statuses, and conditional formatting so Blocked turns red and Done turns green. Consistency here is what makes filtering and counting work later.
3.Make dates real
Format the Due date column as an actual date type, then add a helper column with a formula like =IF(AND(status<>"Done", due<TODAY()), "OVERDUE", "") and conditional formatting on it. Overdue work that is visible gets handled; overdue work in someone's head does not.
4.Build a dashboard tab
One tab with COUNTIF summaries: tasks per status, tasks per owner, overdue count. A pivot table over the task rows gives you per-project rollups. This is the tab you screen-share in the weekly meeting.
5.Add a weekly hygiene ritual
Spreadsheets do not remind anyone of anything. Book 15 minutes weekly where each owner updates their rows before the meeting. The tracker is only as truthful as its last sweep.
Where spreadsheets stop scaling
The system above holds up to roughly one team and a dozen active projects. The failure modes past that are predictable: nobody gets notified when a status changes, so people work from stale rows. Dependencies live in the Notes column, so nothing warns you when a slipped task pushes three others. Two people edit the same cell in a meeting. The dashboard tab formula breaks the week someone inserts a column. And the file quietly forks into v2_FINAL_actualfinal.
Every dedicated project tool is, at heart, this same spreadsheet plus the missing parts: notifications, real dependencies, per-cell permissions, and views that stay wired together. ClickUp's table view is deliberately spreadsheet-shaped, it imports from Excel and Google Sheets, and its Free Forever plan means the migration costs nothing to try. If your tracker has started forking, that is the signal.
Import your spreadsheet into ClickUp free ↗