How to randomize a list

Randomizing a list sounds simple, but mistakes happen when items are duplicated, pasted on the same line, or edited after the shuffle. A clean process gives you a fair order and a result you can trust.

Reviewed by Sam Parker | Updated Sep 23, 2026

Step-by-step

Start with the original list. Put each item on its own line. Remove blank lines. Decide whether duplicates should stay. Then use the list randomizer to shuffle the list. Copy or export the result before running another shuffle.

When duplicates are okay

Duplicates are okay when they represent multiple entries. For example, a giveaway may give one person three entries because they completed three allowed actions. Duplicates are not okay when every person should have one equal chance.

What to randomize

You can randomize student names, team names, tasks, chores, giveaway entries, presentation order, game turns, practice drills, writing prompts, and playlist order. The method is the same: clean list first, shuffle second.

How do I randomize a list of names for a class or meeting?

Use one line per person, add last initials for duplicate first names, and decide whether absent people should stay in the list. Shuffle once, then copy the order into the place people will actually use: a slide, agenda, chat message, or printed roster.

Can I paste names from Excel, Google Sheets, or a CSV file?

Yes, but the cleanest input is one item per line. If you paste from a spreadsheet column, each row usually becomes one line. If you paste comma-separated text, check the preview first because the tool is designed around line breaks rather than hidden spreadsheet columns.

How do I randomize a list in Excel 365?

If the names are in A2:A20, enter this formula in an empty cell:

=SORTBY(A2:A20, RANDARRAY(ROWS(A2:A20)))

This dynamic-array method requires Microsoft 365 or a current Excel version that supports SORTBY and RANDARRAY. RANDARRAY creates one random value per row and SORTBY returns the names as a spilled random-order result. The formula is volatile: editing or recalculating the workbook can produce a new order.

How do I keep an Excel or Google Sheets random order from changing?

After the formula returns the order you want, copy the result and paste it back as values only. Keep the original list in a separate column until you have checked that no name is missing. In older Excel versions, add =RAND() beside each row, fill the formula down, and sort the complete table by that helper column.

How do I randomize a list in Google Sheets?

Add =RAND() in the column beside the first item, fill it down for every row, select the full range, and sort by the random-number column. Copy the final order and paste values only if it must stop changing. For a simple one-time order, the browser tool avoids spreadsheet recalculation.

How should I prepare a CSV list?

Open the CSV in a spreadsheet and copy only the column that contains the items you want to randomize. Do not paste an entire multi-column row into the tool unless the combined row is meant to be one entry. Save the original CSV separately before removing duplicates or blank rows.

How do I save or share the randomized order?

Copy the result as soon as it appears. For classrooms, meetings, and casual drawings, paste the result where everyone can see it. For recurring groups, save each result so you can notice if the same person keeps landing first or last across multiple sessions.

When a list randomizer is better than a wheel

A wheel is more visual for picking one item. A list randomizer is better when you need a complete order, such as every student presenting, every task being assigned, or every entry being ranked.