Random Number Generator for Excel
Pick a range and how many numbers you need, choose whole numbers or decimals, then copy them straight into Excel. Unlike the RAND function, these values stay put.
🔒 Runs entirely in your browser — nothing is uploaded
Note: uses the browser's standard randomness — great for samples, test data and picking winners, but not for cryptographic or security use.
Working with real data, not random?
Quiriz reads your actual spreadsheet and answers questions about it in plain English — no formulas, no functions to remember. Free to start.
Try Quiriz free →How to use it
- Set the range — a minimum and maximum — and how many numbers you want.
- Choose whole numbers or decimals, and whether duplicates are allowed.
- Click Generate, then copy the column into Excel. The values are fixed, so they won't reshuffle every time the sheet recalculates.
Frequently asked questions
How do I generate random numbers for Excel?
Set a minimum and maximum, choose how many numbers and whether they're whole numbers or decimals, then click Generate. Copy the results into Excel — they're static, so they won't recalculate like RAND.
Can I generate random numbers without duplicates?
Yes — turn off Allow duplicates. For whole numbers, the range has to be at least as large as the quantity (you can't draw 10 unique integers from a range of 5).
Do these numbers change like Excel's RAND function?
No — they're fixed values, so they stay put once pasted. RAND and RANDBETWEEN recalculate on every edit unless you paste them as values.
Prefer to do it with a formula? See how to generate random numbers in Excel.