How to pick random rows from a spreadsheet

When the answer is hiding in a column of hundreds, a random draw beats scrolling and guessing every time.

Sometimes the data you need to choose from already lives in a spreadsheet: a list of competition entries, a register of orders, a roster of names, a backlog of ideas. You don't need to pick a name out of thin air — you need to pick a row, with all of its columns attached, at random and without quietly favouring the rows at the top.

That's exactly what Spin Sheet is for. You give it columns — typed in by hand, or imported from a CSV, an Excel file or Google Sheets — and it draws random rows for you. This guide covers when random rows are the right tool, how to get clean data in, the difference between drawing with and without replacement, and how to keep a draw fair when something real is riding on it.

When you actually need a random row

Picking rows at random comes up far more often than people expect:

• Drawing a winner from a list of entries — a prize draw, a giveaway, a raffle where each line is one entry.
• Taking a fair sample for a spot-check or quality review: pull a handful of orders, tickets or files at random and inspect those, rather than only the ones that catch your eye.
• Assigning tasks or shifts — letting a random draw decide who takes which job removes the awkwardness of choosing.
• Choosing which idea to try next when a backlog has stalled and every option is roughly as good as the others.
• Picking discussion questions, prompts or topics from a longer bank so a session stays unpredictable.

In every one of these, the goal is the same: take the choice out of human hands so the result is even-handed and easy to defend.

Getting your data in

There are two ways to put rows into Spin Sheet, and both end up in the same place.

Type the columns directly. If your list is short or you're starting from scratch, just add columns and type rows straight in. This is quickest for a one-off draw — a dozen names, a handful of tasks — where opening a spreadsheet would be overkill.

Import from a file. If the data already exists, bring it in from a CSV, an XLSX (Excel) file, or Google Sheets. For Google Sheets, the simplest route is to export the sheet first — File → Download → Comma-separated values (.csv) or Microsoft Excel (.xlsx) — and then import that file. Either way your columns come across intact, so the winning row still carries its name, email, order number or whatever else you need to act on it.

A few practical tips make imports painless:

• Keep a header row. One clear label per column (Name, Email, Ticket) means the draw shows tidy fields rather than guessing what each value is.
• One record per row. Don't merge two entries onto one line or split one across two — the draw treats each row as a single candidate.
• Trim the noise. Remove blank rows, totals, and stray notes at the bottom of the sheet, or they become "candidates" that can be drawn by mistake.
• Decide what counts as an entry before you import. If someone appears twice, that's two chances — fine if intentional, a problem if not.

One row or several — and with or without replacement

You can draw a single row or several in one go. The important decision is what happens to a row once it's been drawn.

• Without replacement. A drawn row is removed from the pool, so it can't come up again. Use this when each row can only be chosen once — picking three distinct prize winners, sampling ten different orders to review, or assigning a unique task to each person.
• With replacement. Every drawn row stays in the pool, so the same row could be picked again. Use this when each draw is independent and a repeat is acceptable — for example choosing which question to ask each round, where landing on the same one twice is just chance.

Keeping a draw fair when it picks a winner

A method can be perfectly random and still look rigged if nobody saw it happen. When a draw decides who wins something, treat visibility as part of the process:

1. Show the list first. Let people see the full set of rows before you draw, so everyone can confirm they're in and the list looks right. Surprises after the result are what start arguments.
2. Draw in view. Run the draw on a shared screen, projector or stream so the moment of selection happens in front of people rather than off to one side.
3. Keep the result. Hold on to the drawn row — and ideally the list it came from — so you can point back to exactly what was chosen if anyone asks later.

Sampling, in plain English

If you're spot-checking work, the temptation is to "grab a few from the top". The trouble is that the top of a list is rarely typical — it's the oldest entries, or the ones sorted to the front, or simply the ones you've already seen. A random sample avoids that cherry-picking. Because every row has the same chance of being chosen, the rows you end up inspecting are far more likely to reflect the list as a whole, which gives you a more honest picture of what's really going on.

The other half of the idea is size: a larger sample is generally more representative than a tiny one, because a handful of rows can land anywhere by luck while a bigger draw smooths that out. There's no magic number that fits every job — the right size depends on how big the list is and how confident you need to be — but the principle holds. Draw at random, draw enough rows to be meaningful, and resist the urge to swap out any row you happened not to like.

Recording the result

Whatever you're drawing for, write down what came up. Note the winning row or the sampled rows, the date, and the list you drew from. For a prize draw that record is your proof; for a sample it's your audit trail when someone asks which orders you checked. A draw you can't reproduce or point back to is much harder to defend than one you simply kept a copy of.

A step-by-step routine with Spin Sheet

Put together, a clean random-row draw looks like this:

1. Get your data into Spin Sheet — type the columns in, or import a CSV, XLSX or exported Google Sheet.
2. Tidy the columns: keep a header row, one record per row, and clear out blanks and totals.
3. Decide how many rows you need and whether to draw with or without replacement.
4. Show the list to anyone who has a stake in the outcome and confirm it's complete.
5. Draw in view, so the selection happens where people can see it.
6. Record the drawn rows, and remove them from the pool if you're drawing without replacement.
7. Repeat until you've drawn as many rows as you need.

Once you've done it once it takes seconds, and it turns "I'll just pick a few" into a result you can stand behind. For more on running draws and randomisers fairly, browse the rest of the SpinKit guides.