Generate random values for sample datasets, model testing, and practice workbooks.
Try it - click the ribbon
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
Use Random Values when a worksheet needs dummy numbers, dates, text, or other generated data for testing and simulation.
Select the value type and generation settings, then populate the chosen Excel range with randomized values.
Set upper and lower bounds and choose from five supported types: whole numbers, decimal numbers, percentages, dates, and Boolean values.
Build test data directly in the workbook without manually entering values or maintaining temporary randomizing formulas.
Inside Excel
The demo above is a simplified web version. This is Random Values running in Excel.
Keep exploring
| Tool | What it does | Demo |
|---|---|---|
| Random Sample | Select a random sample from transactions, invoices, or other records for review. | Try it live |
| Change Formula References | Switch selected formulas between absolute, relative, and mixed cell references. | Try it live |
| Select All | Select formula cells, numbers, text, or errors across the active worksheet in one step. | Try it live |
| Add Custom Formula | Wrap the cells in a selected range with a custom formula of your choice. | Try it live |
| Add IFERROR | Wrap selected formulas with IFERROR and choose what to display when a calculation returns an error. | Try it live |
| Add Rounding | Apply ROUND, ROUNDUP, or ROUNDDOWN across a selection without editing each formula. | Try it live |
