Team Capacity Planner

Compare daily person availability with summed project allocations and report overload hours and utilization.

On-device No sign-up Free to use

Compare team capacity controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

    Drop your CSV file here

    or choose one from your device

    One file · CSV and TSV only

      Processed in your browser. Your inputs stay on this device.

      Result

      Showing an example.

      Compare dated availability with allocations across projects.

      Alex has 8 available hours and 6 + 4 allocated hours on 2026-01-05, giving 10 allocated, 2 overload and 125.00 percent utilization. Sam has 6 available and 4 allocated, with zero overload.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/team-capacity-planner · 20 November 2026

      Was this helpful?

      How to use Team Capacity Planner

      1. Paste or choose an availability CSV with person, date and available_hours headers. Supply one row per person/date, including zero for an unavailable day.
      2. Paste or choose an allocations CSV with person, date, project and hours headers. Several projects can use the same person/date, but each needs a corresponding availability row.
      3. Run the comparison and review available hours, summed allocations, utilization and overload for each person/day.
      4. Download the report and adjust the original plan. Apply leave, holidays and local working rules in the availability source; the tool does not infer them.

      Example: Team Capacity Planner

      Compare dated availability with allocations across projects.

      You add
      Dated availability: person,date,available_hours Alex,2026-01-05,8 Sam,2026-01-05,6 Project allocations: person,date,project,hours Alex,2026-01-05,North,6 Alex,2026-01-05,South,4 Sam,2026-01-05,North,4
      You get
      Alex has 8 available hours and 6 + 4 allocated hours on 2026-01-05, giving 10 allocated, 2 overload and 125.00 percent utilization. Sam has 6 available and 4 allocated, with zero overload.

      Supported inputs and limits

      • Each CSV has up to 2,000 rows, 80 columns and 2 MiB.
      • Availability needs distinct person/date pairs and 0–24 hours.
      • Each allocation is nonnegative and capped at 168 hours; totals may exceed availability and are reported as overload.
      • Every allocation must have an availability row; explicit zero represents an unavailable day.
      • Dates are calendar dates without timezone or workweek inference.
      More details

      Holidays, leave, skill suitability and overlapping clock intervals are not derived.

      No labour-law or staffing assurance is made.

      Where your input is processed

      This tool does not upload your inputs. See the limits for anything saved on your device.

      Questions about Team Capacity Planner

      Will the tool subtract weekends and public holidays?

      Only the entered availability controls the total. Provide the available hours for each date after applying the calendar, leave and work rules relevant to your team.

      How are several projects on one day combined?

      All allocations for the same person and date are summed. The report also lists project subtotals so you can find which assignments contribute to an overload.

      What does unavailable utilization mean?

      A person with zero available hours and a positive allocation cannot have a finite utilization percentage. The report labels that case unavailable and still shows the overload hours.

      Page updated · Project managed by Tony Hines · Report a problem with Team Capacity Planner