Workforce Planning Template (Excel + Google Sheets, Free)
What's inside the workforce planning template
The template is one Workforce Plan sheet with 30 rows, enough for most departments to list every role separately. Each row holds a role, its department, current FTE, and your planned headcount for Q1, Q2, Q3, and Q4, so you can see a full year of hiring plans without switching tabs.
Because current headcount and each quarter's plan sit side by side, you can spot exactly which quarter a role needs to be filled by, rather than working from a single end-of-year hiring number that doesn't tell anyone when to actually start recruiting.
What calculates automatically: year-end gap and net hires needed
The Year-end gap column compares each role's current FTE against its Q4 plan and computes the gap automatically — positive means you're hiring, negative means you're planning to reduce that role. You don't build this formula yourself; enter current FTE and the Q4 plan and the gap appears.
The summary rolls every role up into three totals: current FTE across the company, year-end plan, and net hires needed. That last figure is the number leadership usually asks for first, and it's already computed from the role-level detail instead of requiring a separate calculation.
Why this beats a blank spreadsheet
Building a workforce plan from scratch means deciding on a column structure, writing the gap formula for every role, and then re-summing it every time a plan changes. This template has the structure and the formulas already built, so entering numbers is the only step left.
It also keeps the quarter-by-quarter view and the annual summary in the same file, so HR and finance are working from one set of numbers instead of reconciling separate quarterly spreadsheets against a year-end headcount plan built independently.
How to use it
- List every role and its department down the Workforce Plan sheet.
- Enter current FTE for each role.
- Enter your planned headcount for Q1, Q2, Q3, and Q4 per role.
- Check the Year-end gap column and the summary totals — both update automatically as you fill in FTE numbers.
Download the free Workforce Planning Template (Excel + Google Sheets, Free)
No spam — template updates and new free templates only. Unsubscribe anytime.
PTO & Leave Tracker — with Automatic Accrual
Once headcount is planned, the PTO Tracker handles the leave side: it calculates PTO accrual automatically per pay period or month, across up to three leave policies with tenure tiers and capped carryover, with no macros required.
See the full versionTracking PTO for a whole team?
Planning capacity gets easier when time off tracks itself. LeaveSheet handles PTO requests, approvals and a shared team calendar for $1.50 per employee per month.
See LeaveSheet — $1.50/employee/moFrequently asked questions
Does this workforce planning template work in Google Sheets?
Yes. Upload the file to Google Drive, open it, then choose File > Save as Google Sheets. The gap and summary formulas calculate the same way.
Is the template free?
Yes. You give an email address to receive the download link, and the file itself has no cost.
Can I add more than 30 roles?
Yes. Insert additional rows above the summary section and the formulas extend to cover them.
Does this template track PTO or leave accrual for the roles I plan?
No. It tracks headcount planning by role and quarter only. For automatic PTO accrual across up to three leave policies, see the PTO Tracker.
What license comes with the free template?
It's licensed for personal use or use within one business. Reselling or redistributing the file itself isn't covered.