PM Through ConsensusA Project Management Course
Module 6 · Tools: free, underutilized, and good enough 6.1 Spreadsheets are your friend
Subsection 6.1

Spreadsheets are your friend

~6 min

Reading

Spreadsheets are your friend. Every PM tool you have ever paid for was, underneath, a spreadsheet with opinions. You can run a real project on Google Sheets.

A working PM spreadsheet has six columns: Task, Owner (one human), Due date, Status (Not Started / In Progress / Blocked / Done), Notes, and a Link to wherever the actual work lives. That is the whole tool. You can sort by owner, filter by status, color-code blocked rows, and share it with the whole team for free.

Three tabs is plenty for most projects. Tab 1: Tasks (the live working list). Tab 2: Decisions Log (date, decision, who decided, why). Tab 3: KPIs (the weekly numbers from Module 3). Some projects add a fourth tab for the budget. That covers it.

Why spreadsheets work for community projects: free, no learning curve, everyone has Google access, no per-seat fees, easy to export, easy to back up. The downsides — no native automations, no nice mobile UI, no built-in reminders — can be patched with calendar invites and one Monday morning ritual.

When to graduate beyond a spreadsheet: when the team is over ten people, when you need automated dependencies between tasks, or when you have an external funder requiring a specific tool. Until then: stay simple. The tool is not the project.

ANATOMY OF A FREE PM SPREADSHEET TASK OWNER DUE STATUS NOTES LINK Write project scope Rosa 8/1 DONE signed by team ↗ doc Assign MOCHA roles Rosa + team 8/3 DONE every task has 1 owner ↗ chart Multilingual survey draft Naomi 8/15 IN PROGRESS awaiting ES + VI review ↗ draft Schedule listening sessions Marco 8/22 IN PROGRESS venues confirmed for 3 of 5 ↗ cal Analyze survey results Sam 9/5 NOT STARTED blocked: needs final survey ↗ — Final report to leadership Rosa 9/20 NOT STARTED ED + board chair to review ↗ — what · concrete verb who · one human when · real date where · color-coded why · context for next week's you link · the actual artifact Six columns. No tool can save you from a project sheet missing any one of them.

Learner action

Start a Google Sheet for your project with the three tabs above. Pre-fill 10-15 tasks. Share it with the team with "anyone with the link can edit". You now have a working PM tool.

Action: Complete the learner action above, then slide to continue.