Capacity planning template

A free capacity planning template in plain CSV: one file for the people you schedule (with working hours per weekday), one for your projects (confirmed or tentative). Open them in any spreadsheet, or import them straight into CapacityKit to get a 12-week people × weeks grid.

People template

12 sample people, 13 columns, CSV (UTF-8)

Download people CSV

Projects template

7 sample projects, 7 columns, CSV (UTF-8)

Download projects CSV

People columns

People template columns
ColumnWhat to put in itExample
nameRequired. Unique per person.Ana Ruiz
roleOptional job title, used for filtering.Design lead
skillsOptional, separated by semicolons.Brand;Figma
mon … sunWorking hours that weekday, 0–24 in quarter hours. Empty columns default to 8 h Monday–Friday.8, 8, 8, 8, 6, 0, 0
start_date, end_dateOptional, as YYYY-MM-DD. Outside these dates the person has no capacity.2027-01-04

Projects columns

Projects template columns
ColumnWhat to put in itExample
nameRequired. Unique per project.Website rebuild
clientOptional.Northwind Foods
statusconfirmed (default) or tentative.tentative
probabilityFor tentative projects, 0–100. Defaults to 50.60
colourOptional: Violet, Blue, Teal, Green, Olive, Amber, Orange, Red, Pink, Purple, Slate, Cyan or a hex code.Teal
start_date, end_dateOptional, as YYYY-MM-DD.2026-11-16

A look inside the people file

First rows of the people template
nameroleskillsmontuewedthufrisatsunstart_dateend_date
Ana RuizDesign leadBrand;Figma;Art direction8888600
Ben OkaforDeveloperReact;Node;Accessibility8888800
Chloe MartinDesignerUI;Figma;Illustration7.57.57.57.57.500
Dev PatelDeveloperWordPress;PHP8888000
Ella NovakCopywriterCopy;Content strategy6666600

Import it into CapacityKit

  1. Create a free workspace and save your private link.
  2. Open People, choose the CSV under “Import people from CSV” and press Preview. Every row shows whether it will be added, skipped as a duplicate, or has an error to fix.
  3. Press Import. Do the same for projects on the Projects page.
  4. Open the Grid and allocate hours: drag across a person's weeks, or use “Allocate hours”.

Want to see the result first? Open the sample plan — it uses the same people and projects as these files.

Using it as a spreadsheet only

Add a week_total column with =SUM(D2:J2) (the seven weekday columns) to see each person's weekly capacity, and multiply by your target utilization — say 0.8 — for the hours you can realistically sell. The utilization guide explains how to pick that number.