Best for
facilitators, program managers, community operators
Create teams from a Google Sheets attendee list
Copy rows from Google Sheets into TeamCreator and create balanced teams without adding a plugin, sharing the sheet, or uploading attendee data.
Direct answer: Select the attendee rows in Google Sheets, copy them, paste into TeamCreator, map the columns, choose team size, then tune similar-or-diverse sliders for the outcome.
Preset
Balanced
Team size
4 to 6 people per group
Use these attendee columns
A name column is enough to start. These columns make the grouping smarter for this use case; extra spreadsheet columns become custom sliders automatically.
For Google Sheets team generator, start with name, organization, role, location. Add expertise, ask, offer, notes when the session needs better matching, more diverse groups, or cleaner follow-up.
nameorganizationrolelocationexpertiseaskoffernotes
Recommended TeamCreator setup
Use the preset as a starting point, then move only the sliders that express the room design. Similar sliders cluster people who share a field; diverse sliders spread that field across teams. Positive ask-and-offer fit helps when participants submitted what they need and what they can contribute.
Slider move
Use geography diversity for cross-regional exchange.
Slider move
Use ask and offer fit when the sheet contains goals or needs.
Slider move
Use custom columns for cohort, role, track, or priority.
Constraints to review
Constraints are the manual safety layer. Add keep-together rules for hosts, accessibility needs, or required pairs, and keep-apart rules for reporting lines, conflicts, competitors, or pairs that would reduce candor.
- Delete sensitive notes before copying if they are not needed.
- Freeze the source sheet before exporting assignments back.
How to create the teams
- Export or copy the attendee list with the columns needed for the grouping decision.
- Open TeamCreator and paste the rows or load the CSV file.
- Choose Balanced and set the team size to 4 to 6 people per group.
- Tune the similar-or-diverse sliders: Use geography diversity for cross-regional exchange. Use ask and offer fit when the sheet contains goals or needs.
- Add keep-together or keep-apart constraints, then create and review the teams.
- Download the assignment CSV and use it inside the room plan.
After the groups are formed
The assignment is only useful if the room knows what to do with it. Put the group number into the agenda, open with a prompt that matches the relationship goal, and make the follow-through visible before people leave.
- Paste the assignment CSV back into a new sheet tab.
- Share only the columns participants need.
- Use the icebreaker library to choose the opening prompt.
Before and after example
Manual grouping
The manual version usually starts with a spreadsheet sort, a last-minute shuffle, or a randomizer. That can be fast, but it tends to over-seat colleagues together, miss useful ask-and-offer matches, and leave sensitive keep-apart rules to memory.
Designed grouping
The TeamCreator version starts from the outcome: select the attendee rows in google sheets, copy them, paste into teamcreator, map the columns, choose team size, then tune similar-or-diverse sliders for the outcome. The organizer uses Balanced, sets the group size to 4 to 6 people per group, checks constraints, and exports assignments that fit the room plan.
Export and room-plan examples
Useful exports for Google Sheets team generator include a facilitator copy with every assignment, a participant-facing list with only names and table numbers, a CSV for badge or check-in systems, and a follow-up version that includes the next prompt or owner.
Want a second set of eyes? Send the use case, not the attendee list: the event goal, group size, available columns, and the rules that matter. We can suggest a TeamCreator setup and a short room plan without touching private participant data.
Common questions
What columns does TeamCreator need for Google Sheets team generator?
A name column is enough to start, but useful columns include name, organization, role, location, expertise, ask.
Does attendee data leave the browser?
No. TeamCreator parses, scores, and forms teams in the browser. United We Transform does not receive, store, or inspect the attendee list.
What is the best preset for this use case?
Start with Balanced, then adjust the sliders to match the session goal and any keep-together or keep-apart rules.
What constraints should I check manually?
Review constraints such as Delete sensitive notes before copying if they are not needed.; Freeze the source sheet before exporting assignments back.