How to Pick a Winner from a List
Paste your entries one per line — names, ticket numbers, emails, order IDs — and draw. How to pick a winner from a list without a spreadsheet formula or a coin.
·4 min read
To pick a winner from a list, paste your entries one per line and draw one at random. You don't need a spreadsheet formula or a coin — the list is the input, and a single draw is the output.
What counts as a list
Anything you can put one per line: names, email addresses, ticket numbers, order IDs, usernames. If you have the entries in a spreadsheet or a form export, copy the column and paste it in. Duplicate lines merging on their own is worth having, so a name that appears twice doesn't quietly get two chances.
The spreadsheet way, and why it's fiddly
You can do this in a spreadsheet with a random-number column and a sort, and it works — but it is a few steps every time, it is easy to get subtly wrong, and nobody watching believes a sorted column the way they believe a draw. For a one-off it is more setup than the job deserves.
Drawing so people believe it
If the winner matters to anyone but you, draw where they can see it. A pick shown on a screen — a moment of suspense, then the name — carries more weight than a result you announce, because the people watching saw it land rather than taking your word for it.
One winner or several
If you need more than one, set the number and draw them together as distinct names, or draw one prize at a time and keep past winners out so nobody wins twice. Either way the list stays the same; only the number of names you pull changes.
The Raffle & Giveaway Winner Picker takes a pasted list and draws from it; if the list is entrants to a giveaway, what to look for in a giveaway winner picker is the next read.
Something out of date or wrong here? Device specs and interface details shift with every release. Tell me and I'll fix it.
Related reading
- Best Random Winner Picker for GiveawaysWhat to look for in a winner picker for a giveaway: draws one winner or several, keeps past winners out across prizes, takes any list of entries, and shows the draw on a screen.
- How to Pick a Name Out of a Hat, OnlineThe hat, without the hat: paste the names, draw one, and let the room watch. A browser stand-in for pulling a name out of a hat, with a proper reveal.