Example: spot-checking 20 rows of a lead list
Before sending a campaign, a marketer wants to check a sample of a 1,250-row spreadsheet of prospects by hand. Row 1 holds the headings, so the data runs from row 2 to row 1251.
With a minimum of 2, a maximum of 1251, 20 numbers, No repeats and Sort the results ticked, the tool returns twenty different row numbers in order. Checking those rows for wrong names, dead websites or odd emails gives a fair picture of the whole list's quality in a few minutes.
Minimum 2, Maximum 1251 How many 20, Decimal places 0 No repeats and Sort the results ticked
Twenty different whole numbers from 2 to 1251, smallest first, one per line when copied
Generating numbers
Set the range
Fill in the lowest and highest values allowed. Results can land on either end, and negative values are fine.
Set the quantity and precision
How many accepts up to 10,000. Decimal places from 0 to 6 gives decimals instead of whole numbers.
Choose the options
No repeats makes every whole number different; the range must contain enough numbers. Sort the results lists them smallest first.
Generate and copy
Press Generate. A single number is shown large; several are listed. The copy button puts one number on each line.
Why sampling beats skimming
Looking only at the first page of a list tells you about the first page: often the cleanest records, or those from one source. Random rows give every record the same chance of being checked, so if 3 of 20 random rows have a problem, a similar share of the full list probably does too. Twenty or thirty rows are often enough to decide whether a list needs cleaning before use.
Numbers come from your browser's cryptographic generator, which is suitable for draws and sampling. For drawing numbered raffle tickets, set the range to the ticket numbers and generate the winners with no repeats.
Questions people ask
How do I get a random number from 1 to 10?
Leave Minimum at 1, set Maximum to 10, keep How many at 1 and press Generate. Each of the ten numbers, including 1 and 10, has the same chance. Press again for another; with one number at a time, a repeat of the previous result is possible.
Why does it say to check the range?
Either the minimum is larger than the maximum, or No repeats is ticked and you asked for more numbers than the range holds. For example, 1 to 10 cannot give 12 different whole numbers. Widen the range, ask for fewer, or allow repeats.
Does No repeats work with decimals?
The no-repeats option only affects whole numbers. Once decimal places are above zero, each number is drawn independently across the range, so an exact repeat is possible but very unlikely with several decimal places.
Where your data goes
The numbers are produced by your browser's secure random source on this page. Nothing is logged or sent, so the results cannot be seen by anyone else.
Checked against the tool on