Work Team Generator

Build teams from an employee table and make department, role, level, and location coverage visible. Files are read for the active task and every unmet rule stays visible for review.

Presentation

1 · Add employees

Enter complete names here. Add optional workplace fields below.

8 unique employees

2 · Configure employee details

Department, role, level, and location are optional. Select only the fields that are relevant to this team task.

Avery
Blake
Cameron
Dakota
Emerson
Finley
Harper
Jordan

Include a Name column and any of Department, Role, Level, or Location. Imported rows fill the same fields above. Export XLSX files as CSV first.

Balance across teams
Keep together

Choose pairs that should be assigned to the same team when possible.

Keep apart

Choose pairs that should be assigned to different teams when possible.

2 · Work teams

Paste an employee table and generate teams to see the matrix.

Ready to build workforce-balanced teams.

What this tool does

A work team generator assigns employees to teams while attempting declared workplace constraints such as cross-department coverage, role spread, level mix, capacity, and together-or-apart rules.

Workplace teams

Where structured work teams help

Cross-department workshops

Spread participants from different functions across workshop tables and show which teams still lack a requested role.

Training cohorts

Create teams with a mix of experience levels or locations while respecting stated capacities and required separations.

Hack days and internal events

Use an employee export as the starting roster, then review the generated matrix before announcing teams.

Instructions

How to prepare and generate teams

Prepare the employee table

Include a name column and only the department, role, level, or location fields needed for this team task.

Map and review the columns

Confirm headers, resolve duplicate names, and remove sensitive fields that do not affect the declared grouping rules.

Set team rules

Choose team size or count, then add coverage, capacity, together, or separate rules that can be explained to participants.

Generate, inspect, and export

Review the team matrix and unmet-rule summary, adjust if necessary, then copy or export the accepted result.

Troubleshooting

Data and constraint problems

A column cannot be mapped

When: The imported file has missing headers, merged cells, or inconsistent rows.

Why: The table cannot reliably match values to employee fields until its columns have a consistent shape.

Try: Use one header row, one person per row, and a stable value format before importing again.

A hard constraint is impossible

When: Capacity, separation, or required coverage rules conflict with the roster.

Why: No assignment can satisfy every selected rule with the available employees and team structure.

Try: Read the unmet-rule explanation, relax a rule, change team count, or adjust the active roster.

A team lacks a requested role

When: There are fewer people with that role than the number of teams requiring it.

Why: The generator cannot create coverage that does not exist in the input data.

Try: Reduce the number of teams, change the coverage rule, or make a documented manual assignment.

Trust

Balance explanations and employee privacy

Balance is limited to declared fields and rules

The matrix explains the attributes the tool used and any selected rules it could not satisfy; it does not measure employee worth or predict team performance.

  • Field values come from the imported table and may be incomplete, outdated, or too coarse for the real work.
  • Hard rules restrict possible assignments; soft rules influence the chosen mix without guaranteeing an optimum.
  • Managers must review accessibility, reporting lines, conflicts, workload, consent, and context not represented in the file.

Employee data is not saved

Imported files, employee fields, constraints, and teams are used for the active task and are not saved by Random 42.

  • Random 42 does not save organization data, employee profiles, or team results to an account.
  • Use the export deliberately, store it according to your organization's policy, and refresh to clear the active session.

Boundaries

Decisions this tool must not automate

Do not use this tool for employment decisions

The generator supports temporary team formation, not hiring, promotion, discipline, performance scoring, or protected-trait decisions.

Review before you use the result

  • Do not import sensitive personal data or fields that are unnecessary for the team task.
  • A generated team matrix is a proposal requiring human review, not evidence of equal opportunity or predicted performance.
  • The tool does not integrate with HR systems, meeting platforms, calendars, or directory services.

FAQ

Frequently asked questions

Are CSV or spreadsheet files uploaded?

No. Supported files are read for the active task and are not saved by Random 42.

Can every team receive every role?

Only when the roster contains enough people with those roles and the other rules do not conflict. Missing coverage is shown rather than hidden.

What is the difference from Random Team Generator?

Work Team Generator accepts structured employee fields and workplace constraints, while Random Team Generator uses names, captains, and lightweight ability labels.

Does the tool find an objectively best team structure?

No. It searches for a result that fits the selected rules and reports gaps, but team quality depends on context outside the data.

Keep exploring