Random team generator by skill level
Why pure random teams are lopsided
Split 10 players into 2 teams of 5 completely at random and the chance that your two best players land on the same team is 4 in 9, about 44%: once the first one is placed, 4 of the 9 remaining spots are on his team. Rating players and dealing in snake order puts them on opposite sides every time, while shuffling within each rating keeps the teams different from week to week.
The snake draft, step by step
- Rate everyone 1 to 5. Keep it simple; finer scales only start arguments.
- Take goalkeepers (or setters, or captains) out of the list and place one on each team first.
- Sort the rest from highest to lowest rating; shuffle players who share a rating.
- Deal in snake order: player 1 to team A, players 2 and 3 to team B, 4 and 5 to team A, and so on. With 3 teams: A, B, C, C, B, A.
- Add up each team's ratings. If the gap is more than 1 or 2 points, swap two players with similar ratings.
Example: 10 players, 2 teams
| Team A | Rating | Team B | Rating |
|---|---|---|---|
| Ana | 5 | Fay | 5 |
| Gus | 4 | Ben | 4 |
| Carl | 3 | Helen | 3 |
| Ian | 2 | Dana | 2 |
| Ed | 1 | Jude | 1 |
| Total | 15 | Total | 15 |
In Google Sheets or Excel
- Names in A2:A21, ratings in B2:B21, a tie-breaker in C2:
=RAND(). - Sort by rating (descending), then by column C.
- Number of teams in E1; team for each row in D2:
=IF(MOD(INT((ROW()-2)/$E$1),2)=0,MOD(ROW()-2,$E$1)+1,$E$1-MOD(ROW()-2,$E$1)) - Team totals:
=SUMIF(D:D,1,B:B),=SUMIF(D:D,2,B:B).
Copy and paste the result as values to freeze it; RAND() changes on every edit.
The full team picker, free on this site
What the full tool does: Team Picker, this site's team generator for soccer, volleyball, futsal, pickleball or any group, keeps your roster with each player's rating, ticks who showed up and draws only them, keeps goalkeepers apart, and shares the teams to WhatsApp in one tap. Open the team picker: no account, the roster is saved on your device.