Workforce Planning Template: Excel Layout, Example and 12-Week Plan

9 min read ยท 2026-10-25

A workforce planning template is a spreadsheet or document that compares the people and skills you have today with the people and skills you will need to meet your business plan, then turns the gap into actions: hires, internal moves, training, contractors or role changes, with dates and owners. A good one links headcount to budget and to the business goals finance and leadership have already agreed.

Below you will find the exact layout to build in Excel or Google Sheets, with the tabs, columns and formulas, a filled-in example and a 12-week process to complete the plan with department heads and finance. The template works for an annual plan, a mid-year refresh or a single department planning its next 12 to 18 months.

The roadmap at a glance

Goal: An approved workforce plan for next year, with current and future headcount by team, the skills gaps, the actions to close them and a hiring timeline linked to the budget. Duration: 12 weeks

  1. Scope and business inputs (Weeks 1-2)

    Anchor the plan in the business strategy and budget.

    • Get the business plan, revenue targets and key projects for next year from finance and the executive team.
    • Agree the scope: whole company or selected functions, and the planning horizon.
    • Agree the planning assumptions with finance, such as expected attrition and time to fill by role family.
    • Name the HR business partner and finance partner who will own the template.

    Milestone: Scope, horizon and planning assumptions signed off by the CFO and the CHRO or Head of People.

  2. Current workforce baseline (Weeks 2-4)

    Get one clean picture of the workforce today.

    • Export headcount from the HRIS: employee ID, team, role, level, location, employment type, start date and cost center.
    • Add open roles, approved but unfilled positions and known leavers.
    • Add contractors and agency staff from finance or procurement records.
    • Reconcile the totals with payroll and fix mismatches.

    Milestone: A baseline tab that matches payroll headcount, with every person mapped to a team and role family.

  3. Demand forecast (Weeks 4-7)

    Estimate the roles and skills each team needs to deliver the plan.

    • Send each department head the demand tab with their current headcount filled in.
    • Ask them to list the roles needed per quarter and the business driver for each, such as a new product line or higher ticket volume.
    • Use simple ratios where they exist, such as customers per account manager or tickets per support agent.
    • Collect skills needs that change existing roles, such as data skills for analysts.

    Milestone: Demand tab completed by every department head, with a business driver for each new role.

  4. Gap analysis and actions (Weeks 7-9)

    Turn the gap into a plan of actions.

    • Calculate the gap per team and role family: future need minus current headcount, adjusted for expected attrition.
    • Choose an action for each gap: hire, promote or move internally, train, use contractors or redesign the work.
    • Mark critical roles where a vacancy would block a key project and plan successors.
    • Add start dates and cost estimates for each action with finance.

    Milestone: Action tab with an owner, a quarter and a cost estimate for every gap.

  5. Review and approval (Weeks 9-11)

    Align the plan with the budget and get it approved.

    • Compare the total cost of the plan with the people budget and agree trade-offs.
    • Review the plan with each department head and the executive team.
    • Agree what happens if revenue comes in above or below plan, such as which hires move forward or wait.
    • Lock the approved version and save a copy as the baseline for tracking.

    Milestone: Workforce plan approved by the executive team and reconciled with the approved budget.

  6. Launch and tracking (Weeks 11-12)

    Turn the plan into hiring and development work and track it monthly.

    • Share the approved hiring timeline with talent acquisition and open the first quarter's requisitions.
    • Share the training and internal move actions with managers and learning teams.
    • Set up a monthly tracking view: plan against actual headcount, hires and leavers by team.
    • Book a quarterly review with finance and department heads to refresh the forecast.

    Milestone: First month's tracking report shared and quarterly reviews on the calendar.

Template layout: the five tabs

Build the template as one workbook with five tabs. Keep inputs and calculations apart, so department heads only touch the cells they own. Use one color for input cells, such as light yellow, and leave calculated cells white.

Every tab uses the same keys: team, role family and quarter. That lets you sum and compare across tabs without manual copying. Keep the list of teams and role families on a hidden Lists tab so everyone picks from the same names.

  • Assumptions: planning horizon, attrition rate by role family, time to fill, average cost per level, and the business drivers from finance.
  • Baseline: one row per person or open role. Columns: ID, team, role family, role title, level, location, employment type, status (filled, open, leaving), cost center, and leaving date if known.
  • Demand: one row per team and role family. Columns: current headcount (calculated), needed headcount for Q1, Q2, Q3 and Q4, business driver, and skills notes.
  • Gap and actions: one row per gap. Columns: team, role family, gap size, action type, quarter, owner, estimated cost, critical role flag and status.
  • Summary: headcount today, planned headcount at year end, hires planned per quarter, total cost and the top five critical gaps.

How to build it in Excel or Google Sheets

Start with the Baseline tab, since every other tab reads from it. Paste the HRIS export, then select the range and use Home, then Format as Table in Excel, so formulas expand as rows are added. In Google Sheets, keep the data in a plain range with a header row and freeze it with View, then Freeze.

On the Demand tab, calculate current headcount per team and role family with a COUNTIFS formula that reads the Baseline tab and counts only filled roles. Leave the quarterly need columns as yellow input cells. On the Gap tab, subtract current headcount from the year-end need, then add the expected leavers using the attrition rate on the Assumptions tab. Build the Summary with a PivotTable from Insert, then PivotTable, using team as rows and quarter as columns.

  • Add drop-down lists for team, role family, action type and status with Data, then Data Validation in Excel, or Data, then Data validation in Google Sheets.
  • Use conditional formatting to color gaps red when need exceeds supply and to highlight critical roles.
  • Protect the calculated columns so department heads can only edit input cells.
  • Add a version cell on the Assumptions tab with the date and the name of the person who last updated it.

Example: a filled-in plan for a growing customer support team

Picture a software company planning for next year. Finance expects the customer base to grow by about a third, with a new product launch in Q3. The support team has 24 agents and 3 team leads today, and handles about 8,000 tickets a month.

The planning ratio here, tickets per agent, came from the team's own history, not from an industry benchmark. Use ratios you can defend with your own data, and note the source in the Assumptions tab.

  • Baseline (owner: HR business partner): 24 agents, 3 team leads, 1 support operations analyst, 2 known leavers in Q1, attrition assumption agreed with finance.
  • Demand (owner: Head of Support): ticket volume forecast from customer growth, current ratio of about 330 tickets per agent per month, need of 32 agents by Q4, a second operations analyst for reporting, and product specialists for the Q3 launch.
  • Gap and actions (owners: Head of Support and talent acquisition): 8 net new agents plus 3 backfills (the 2 leavers and 1 agent promoted to team lead in Q2), 1 operations analyst hired, 2 agents trained as product specialists before Q3, seasonal contractors for the launch month.
  • Summary (owner: finance partner): headcount from 28 to 38, 12 hires, 1 internal promotion, cost within the approved people budget after moving two hires from Q1 to Q2.

Who owns what

Workforce planning sits between HR and finance, and both need to own it. HR owns the people data and the actions. Finance owns the budget and the business assumptions. Department heads own the demand, because they know what work is coming.

Agree these roles at kickoff and write them on the Assumptions tab, so anyone opening the file knows who to ask.

  • CHRO or Head of People: sponsor, final review with the executive team.
  • HR business partner: template owner, baseline data, gap analysis and action plan.
  • Finance partner: business drivers, cost assumptions and budget reconciliation.
  • Department heads: demand forecast, business drivers and action choices for their teams.
  • Talent acquisition lead: hiring timeline, time to fill and recruiter capacity.
  • Learning and development lead: training actions for skills gaps.

How to present it to leadership

Use one slide built from the Summary tab. On the left, show a simple bar per department with headcount today and at year end. On the right, list the hires per quarter, the total cost against budget and the top three critical gaps with the action for each. Add one line on the main assumption, such as the attrition rate, so leaders know what the numbers depend on.

Leave the person-level baseline out of the meeting entirely. It contains personal data and distracts from decisions. Ask for two decisions: approval of the hiring timeline for the first two quarters, and agreement on what moves if revenue is above or below plan.

Workforce planning vs headcount planning

Headcount planning answers how many people and at what cost. It is usually a finance exercise tied to the budget. Workforce planning goes further: it asks which skills you need, which roles are critical, and whether to hire, build, borrow or redesign the work.

The template above covers both. If you only need a headcount budget, you can stop at the Baseline, Demand and Summary tabs. If you face skills shifts, such as new technology changing roles, keep the Gap and actions tab and add a column for the skills each gap requires.

Common mistakes to avoid

  • Starting from last year's headcount plus a percentage ignores what the business will do differently, so build demand from business drivers each department can explain.
  • Planning only for net new roles misses backfills, so add expected attrition from the Assumptions tab to every gap.
  • Letting each department use its own team and role names breaks every formula, so use shared drop-down lists from one Lists tab.
  • Treating hiring as the only answer to every gap raises cost and time, so consider internal moves, training, contractors and work redesign for each gap.
  • Building the plan without finance leads to a second round of cuts, so involve the finance partner from week one and reconcile with the budget before review.
  • Approving the plan and never opening it again makes it useless by Q2, so track plan against actual monthly and refresh the forecast every quarter.

Frequently asked questions

What should a workforce planning template include?

It should include planning assumptions, a baseline of current headcount and open roles, a demand forecast by team and quarter, a gap analysis with actions and owners, and a summary of headcount, hires and cost against budget.

How do you create a workforce plan in Excel?

Create five tabs: assumptions, baseline, demand, gap and actions, and summary. Paste the HRIS export into the baseline, count current headcount with COUNTIFS, let department heads fill the demand tab, calculate the gap with attrition, and summarize with a PivotTable.

What are the steps of workforce planning?

Set scope and business inputs, build a baseline of the current workforce, forecast demand, analyze the gap, choose actions such as hiring, training or internal moves, get the plan approved against the budget, and track it every month.

How often should you update a workforce plan?

Build it once a year with the budget, track plan against actual every month and refresh the demand forecast every quarter. Update it sooner when the business plan changes, such as a new product launch or a reorganization.

Who is responsible for workforce planning?

HR usually owns the process and the template, finance owns the budget and business assumptions, and department heads own the demand for their teams. The executive team approves the final plan.

Generate this roadmap with AI