I use spreadsheets to organize group projects. I have created a step by step tutorial for how take a list of students and put them into groups. Go through each tab for each step. Double click on cells to view the formulas.
Click Here to create a copy of the tutorial.
Start with a List of Names