Group Maker: Automatically Make Groups with Google Sheets

Group Maker

This template allows you to copy and paste your roster of students and have them randomly divided up into groups.

The Template

alicekeeler.com/groupmaker

Paste Roster

After creating a copy of the template, paste your student roster into column A. Default group size is 4. Change the group size in cell B1.
Column A

Add On Menu

Use the Add-On menu to find “Group Maker.”
Group Maker

Click the button to make groups.
Click button

Each student is assigned a random number. The list is then sorted by random number and students are assigned to a group.
Make Groups

Digiprove sealCopyright secured by Digiprove © 2015