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.
āđ‚āļ”āļĒ
āļ§āļąāļ™āļ—āļĩāđˆāļ­āļąāļ›āđ€āļ”āļ•āļ‚āđ‰āļ­āļĄāļđāļĨ:28 āļžāļĪāļĐāļ āļēāļ„āļĄ 2568
āđƒāļŠāđ‰āļ‡āļēāļ™āđ„āļ”āđ‰āļāļąāļš
āđ„āļĄāđˆāļĄāļĩāļĢāļĩāļ§āļīāļ§
314
āļ āļēāļžāļĢāļ§āļĄ
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.

āļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļĢāļēāļ„āļēāđ„āļĄāđˆāļĄāļĩāļ„āđˆāļēāđƒāļŠāđ‰āļˆāđˆāļēāļĒ
āļ™āļąāļāļžāļąāļ’āļ™āļēāļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ
āđ„āļĄāđˆāđ€āļ›āđ‡āļ™āļœāļđāđ‰āļ„āđ‰āļē
āļ™āđ‚āļĒāļšāļēāļĒāļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļŠāđˆāļ§āļ™āļ•āļąāļ§
āļ‚āđ‰āļ­āļāļģāļŦāļ™āļ”āđƒāļ™āļāļēāļĢāđƒāļŦāđ‰āļšāļĢāļīāļāļēāļĢ
Randomizer āļˆāļ°āļ‚āļ­āļŠāļīāļ—āļ˜āļīāđŒāļ—āļĩāđˆāđāļŠāļ”āļ‡āļ”āđ‰āļēāļ™āļĨāđˆāļēāļ‡ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
Randomizer āļ•āđ‰āļ­āļ‡āļĄāļĩāļŠāļīāļ—āļ˜āļīāđŒāđ€āļ‚āđ‰āļēāļ–āļķāļ‡āļšāļąāļāļŠāļĩ Google
āļ‹āļķāđˆāļ‡āļˆāļ°āļ­āļ™āļļāļāļēāļ•āđƒāļŦāđ‰ Randomizer āļ”āļģāđ€āļ™āļīāļ™āļāļēāļĢāļ•āđˆāļ­āđ„āļ›āļ™āļĩāđ‰
āļ”āļđāļ­āļĩāđ€āļĄāļĨāļŦāļĨāļąāļāļ‚āļ­āļ‡āļšāļąāļāļŠāļĩ Google
āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§ āļ‹āļķāđˆāļ‡āļĢāļ§āļĄāļ–āļķāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§āđƒāļ”āđ† āļ—āļĩāđˆāļ„āļļāļ“āđ„āļ”āđ‰āđ€āļœāļĒāđāļžāļĢāđˆāļ•āđˆāļ­āļŠāļēāļ˜āļēāļĢāļ“āļ°āļ”āđ‰āļ§āļĒ
āļĢāļĩāļ§āļīāļ§
āļ āļēāļĐāļē:
āļˆāļąāļ”āđ€āļĢāļĩāļĒāļ‡āļ•āļēāļĄ:
Google āđ„āļĄāđˆāđ„āļ”āđ‰āļ•āļĢāļ§āļˆāļŠāļ­āļšāļĢāļĩāļ§āļīāļ§āļŦāļĢāļ·āļ­āļ„āļ°āđāļ™āļ™ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄāđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļĢāļĩāļ§āļīāļ§
āđ„āļĄāđˆāļĄāļĩāļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™
āļ„āđ‰āļ™āļŦāļē
āļĨāđ‰āļēāļ‡āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āļ›āļīāļ”āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āđāļ­āļ› Google
āđ€āļĄāļ™āļđāļŦāļĨāļąāļ