Welcome to Randomizer for Google Sheets™ by Avi Megiddo. You can make random student orders, partners, and groups groups of 3–5. Includes "bad pairing" option to avoid potential conflicts.
Listing updated:May 28, 2025
Works with:
No reviews
242
Overview
Randomizer by Avi Megiddo is a handy tool built for teachers. Use Google Sheets™ to manage classroom participation, grouping, and fairness in collaborative activities. With just a few clicks, this tool lets you:

Randomize the order of student names

Create random pairs, trios, quartets, or quintets

Prevent students from being grouped together based on prior conflicts or planning constraints ("bad pairings")

Quickly import a setup template with clear instructions

Maintain formatting consistency with pre-set fonts and styles

🎯 Why Use This Tool?
In the middle of a lesson or project, you don’t have time to fiddle with sorting formulas or dragging cells. Whether you need to:

Randomize presentation order

Pair students for peer reviews

Form small groups for cooperative learning

Exclude specific pairings due to social/emotional needs or accommodations

This add-on makes it instant and effortless — right inside Google Sheets™.

💡 Key Features
✅ Randomize Order
Instantly shuffle the list of student names in Column B. Set the number of randomizations in cell A2 to add variability, then click the Randomize Order button.

✅ Make Random Partners
Quickly form pairs from the student list. The tool checks for "bad pairings" (students who shouldn't be grouped together), and reshuffles if needed.

✅ Groups of 3, 4, or 5
Choose the group size you want, and let the tool handle the math and placement. Odd numbers? Leftover students are intelligently distributed into existing groups.

✅ Bad Pairing Exclusions
Add or edit a list of "bad pairings" so that two specific students will not appear in the same group or pair. The tool attempts up to 5 reshuffles to avoid those combinations before notifying you.

✅ Consistent Formatting
All results are pasted in clean, formatted ranges using the Barlow font and 14pt text size, keeping your sheet neat and readable.

Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Randomizer will ask for the permissions shown below. Learn more
Randomizer will need access to your Google account
This will allow Randomizer to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu