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)
Projects template
7 sample projects, 7 columns, CSV (UTF-8)
People columns
| Column | What to put in it | Example |
|---|---|---|
name | Required. Unique per person. | Ana Ruiz |
role | Optional job title, used for filtering. | Design lead |
skills | Optional, separated by semicolons. | Brand;Figma |
mon … sun | Working 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_date | Optional, as YYYY-MM-DD. Outside these dates the person has no capacity. | 2027-01-04 |
Projects columns
| Column | What to put in it | Example |
|---|---|---|
name | Required. Unique per project. | Website rebuild |
client | Optional. | Northwind Foods |
status | confirmed (default) or tentative. | tentative |
probability | For tentative projects, 0–100. Defaults to 50. | 60 |
colour | Optional: Violet, Blue, Teal, Green, Olive, Amber, Orange, Red, Pink, Purple, Slate, Cyan or a hex code. | Teal |
start_date, end_date | Optional, as YYYY-MM-DD. | 2026-11-16 |
A look inside the people file
name | role | skills | mon | tue | wed | thu | fri | sat | sun | start_date | end_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Ana Ruiz | Design lead | Brand;Figma;Art direction | 8 | 8 | 8 | 8 | 6 | 0 | 0 | ||
| Ben Okafor | Developer | React;Node;Accessibility | 8 | 8 | 8 | 8 | 8 | 0 | 0 | ||
| Chloe Martin | Designer | UI;Figma;Illustration | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 0 | 0 | ||
| Dev Patel | Developer | WordPress;PHP | 8 | 8 | 8 | 8 | 0 | 0 | 0 | ||
| Ella Novak | Copywriter | Copy;Content strategy | 6 | 6 | 6 | 6 | 6 | 0 | 0 |
Import it into CapacityKit
- Create a free workspace and save your private link.
- 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.
- Press Import. Do the same for projects on the Projects page.
- 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.