Generate Random Data (Numbers, Date, String, etc…)
Sometimes you want to generate some random data for testing purposes or for some other reason. Dose for Excel‘s Insert Random Data utility can easily generate these data randomly with one click.
- Generate random numbers
- Generate random string
- Generate random date
- Generate random Boolean
- Generate random custom list
Click DOSE » Insert » Insert Random Data
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-pane.png)
Generate random numbers
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Insert Random Data.
- For example, if you want to generate numbers between 0 and 100, then simply enter 0 in From box and 100 in To box.
- Ability to generate Integer or real numbers. Check the Unique values in case you want all generated values to be unique.
- Then click on Generate. See screenshots.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-numbers-pane.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-numbers-result.png)
Generate random string
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Insert Random Data.
- For example, you can specify if the string you want to generate is uppercase or lowercase, include numbers or space, and number of digits.
- Then click on Generate. See screenshots.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-string-pane.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-string-result.png)
Generate random date
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Insert Random Data.
- For example, set the date in From box and date in To box and if you want check Unique values box for unique dates, and the utility will generate dates between these 2 dates.
- Then click on Generate. See screenshots.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-date-pane.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-date-result.png)
Generate random Boolean
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Insert Random Data.
- For example, choose from the list of Boolean (TRUE / FALSE) or (YES / NO).
- Then click on Generate. See screenshots.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-boolean-pane.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-boolean-result.png)
Generate random custom list
- Select the range of the list you want to insert, and then click on “Insert List” button.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-custom-list-test.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-custom-list-pane-result.png)
- And then apply this function by clicking on DOSE » Insert » Insert Random Data.
- For example, choose the custom list you want to insert randomly into your range of cells.
- Then click on Generate. See screenshots.
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-custom-list-pane.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Random Generator](https://zbrainsoft.com/wp-content/uploads/2022/08/random-generator-custom-list-result.png)
More Features:
Excel Remove All Macros
Remove All Macros From Excel Workbooks Delete Macros, User Forms, VBA modules, etc. from Excel…
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…
How To Sum And Count Cells By Color In Excel
Sum and count and average cells by color in Excel To make the data stand…
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
Excel Extend Selection To Last Used Row
Easily Extend Selection To The Last Used Row Normally if you want to select a…