Action Plan Template in Excel: Owners, Deadlines and Costs with the 5W2H Method
An action plan template in Excel based on the 5W2H method: the columns you need, how to write actions that get done, formulas for progress and overdue items, and an example of an HVAC company cutting repeat service calls.
An action plan turns a goal or a problem into a list of concrete actions, each with one owner, a deadline and a cost. The simplest structure is 5W2H: what, why, who, when, where, how and how much. An action plan template in Excel adds automatic progress tracking and flags overdue actions. This guide covers the columns, how to write actions that actually get done and a worked example.
The 5W2H columns
| Column | Question | Example |
|---|---|---|
| What | What is the specific action? | Add a post-job checklist to every service call |
| Why | Which problem does it solve? | Cut repeat visits for the same issue |
| Who | One accountable person | Service manager |
| When | Deadline | November 15 |
| Where | Team, location or channel | All field technicians |
| How | Main steps | Draft 10 checks, test on 20 jobs, add to the job app |
| How much | Expected cost | $0 |
| Status | Not started, in progress, done | In progress |
Writing actions that get done
- Start with a verb and be specific: “Stock the five most-used parts on every van” rather than “Improve parts availability”.
- One owner, even when several people help; detailed roles can go in the RACI matrix.
- A real date, never “soon” or “next quarter”.
- A way to measure the result: finishing the action is not enough; the problem has to shrink.
Tracking formulas
- Overdue:
=IF(AND([@Status]<>"Done",[@When]<TODAY()),"Overdue",""), highlighted red. - Percent complete:
=COUNTIF(Plan[Status],"Done")/COUNTA(Plan[What]) - Total cost:
=SUM(Plan[HowMuch]); by owner:=SUMIFS(Plan[HowMuch],Plan[Who],A2) - Open actions per person:
=COUNTIFS(Plan[Who],A2,Plan[Status],"<>Done")
Example: an HVAC company cuts repeat service calls
Nine percent of jobs need a second visit for the same problem. Goal: under 4% within three months.
| What | Who | When | How much |
|---|---|---|---|
| Post-job checklist on every call | Service manager | Nov 15 | $0 |
| Follow-up call 48 hours after each job | Office coordinator | Nov 20 | $0 |
| Training on the three most common causes of repeat calls | Lead technician | Nov 30 | $600 |
| Stock the five most-used parts on every van | Operations manager | Dec 5 | $2,400 |
| Track the repeat-call rate every week | Owner | From Nov 15 | $0 |
Total one-time cost: $3,000. The last action improves nothing by itself, but it is the one that tells you whether the plan works: if after six weeks the rate is still above 6%, the team goes back to the causes before adding more actions.
Making the plan part of the week
- Review it in the weekly meeting and record decisions in the meeting minutes template.
- Day-to-day tasks move to the to-do list template or the Kanban board.
- When actions pile up, prioritize with the Eisenhower matrix.
- For a choice between several solutions, score them first with the decision matrix.
More guides are in Project Management.
Frequently asked questions
What is the difference between 5W1H and 5W2H?
5W1H asks six questions; 5W2H adds “how much”, which matters when the plan needs a budget.
How is an action plan different from a project plan?
An action plan is short and focused on one problem or goal; a project plan covers scope, schedule and budget in more detail.
How often should the plan be updated?
Weekly, in a short check-in, until the goal is met.
Does it work in Google Sheets?
Yes. COUNTIF, COUNTIFS, SUMIFS and conditional formatting work the same way.