EN
Create a wheel

How to pick a random name in Google Sheets

By the Spinrin editorial team. Updated .

Three ways to pick random names in Google Sheets: a one-cell formula, a shuffled list for several winners and the built-in Randomize range.

Put the names in column A starting at A2. The formulas below adapt to the length of your list.

1. One random name

=INDEX(A2:A, RANDBETWEEN(1, COUNTA(A2:A)))

2. Several winners with no repeats

=ARRAY_CONSTRAIN(SORT(FILTER(A2:A, A2:A<>""), RANDARRAY(COUNTA(A2:A)), TRUE), 3, 1)

This shuffles the non-empty names and keeps the first 3. Change the 3 to the number of winners.

3. Shuffle the list in place

Select the names, right-click and choose Randomize range. The order changes once and stays put, which makes it easy to read the first names as winners.

Freeze the result

Formulas recalculate on every edit. To keep a result, copy it and paste with Ctrl+Shift+V (Cmd+Shift+V on Mac) to paste values only.

When a spreadsheet is not enough

If entrants will question the result, use a certified draw. It publishes a commitment code first and a certificate after, so anyone can confirm the winner was not chosen by hand. For quick everyday picks, paste the column into the random name picker.

Try it

Install Spinrin

Add the app to your device. It opens full screen, starts faster and works offline.