For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.
| Download Now | Feature Tour | See how it works |
The Random Number Generator for Microsoft Excel can do all this and more with ease! See the complete list of random value types that Random Number Generator can generate.
A really fascinating feature about Random Generator for Excel is that it is so intuitive that you will hardly ever need to look in Help, so easy-to-use that you will never need more than a tick and a click to have the range filled with random values, and besides that very fast, reliable and flawless.
The Random Generator window has 6 groups, each of the tabs is designed for producing a particular type of random values. Below is a quick overview of their capabilities:
I wish Microsoft would just license your software and build it into Excel. You guys are great! Pete Liappis, CTO, Creative Agency Services Team, Inc.
The first 4 groups are purposed for generating numbers exactly as their names suggest. They can produce:
You specify the minimum and maximum values and click Generate and you have the range populated. If you need unique random numbers or dates, check the Unique values checkbox in the corresponding group.
See online help for step-by-step instructions: Fill the range with random numbers.
The next group is meant for populating the range with values from standard Microsoft Excel custom list(s) or from your own list.
You can select the entire custom list or several lists, or pick only some particular values you need. Then you click Generate and your selected range is filled with random values from the list(s). See online help for step-by-step instructions: How to populate the range with random values from a custom list.
The add-in allows creating worksheets with the names of all custom list values by clicking just one button. So if in your workbook you need the worksheets with the days of the week, just select the appropriate custom list and click Create worksheets.
If you need to randomly select a given percentage of values from your custom list, the Random Number Generator for Excel can help with this as well. For example, you have 50 telephone numbers and you need to pick random 10. You add all 50 numbers to your custom list, select 10 blank cells in Excel, click Generate and voila - you have 10 random phone numbers from your list. You can find detailed instructions here: How to pick a given number of random values from a custom list .
Another great feature is the ability to add your custom lists not only to the Random Number Generator for Excel, but to the Standard Microsoft Excel custom lists as well. Suppose you have a list of names in a worksheet. You select that list, and click New List. That's it! Just one click and you have a new list added to the Random Generator. Now you also have it among your Microsoft Excel custom lists. To make sure, go to Microsoft Excel menu - > Tools -> Options -> Custom lists. You can find step-by-step instructions and tips here: How to create your own custom list.
And here is how the String group looks like:
You select the character set (you can choose one or several sets, e.g. A - Z, a - z and 0 - 9, or enter any other characters in the Custom field) and set the string length which may be up to 99 characters. Click Generate, and the Random Generator for Excel does the job in seconds. You can use this function as an ideal password generator. The AbleBits staff used this option to generate their e-mail passwords, and none has been cracked so far :-). See more tips here: How to generate strings of a given length.
A really unique feature of our Random Number Generator for Excel, that you will not find in any other add-in is generating random strings by mask. You use the mask when you need the string of a particular pattern. E.g. if you need to generate a number of GUIDs, you check the Hexadecimal character set and use this mask ????????-????-????-????????????. Click Generate and you will have the 6F9619FF-8B86-D011-B42D-00CF4FC964FF pattern all across the selected range. Of course, apart from GUID codes, you can use this option for producing any other code types, for example coupon codes, RGB color codes, product codes, zip codes, SKU codes etc. Find step-by-step instructions here: How to generate random strings by mask.
Very simple, isn't it? To make sure, just download the Random Generator for Microsoft Excel now and see for yourself :)
Download Random Generator for Excel, a fully-functional 15-day evaluation version.
Our Random generator add-in uses the reliable Mersenne Twister algorithm. We use version MT19937 that produces a sequence of 32-bit integers and has the following advantages:
Click Like and get 15% discount on all our products right now!

You can purchase a license of Random Generator for Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.
You can buy this add-in as part of the AbleBits Add-in Collection for Excel (11 add-ins in 1 package) and save 60% off.
Quantity | USD | EUR | GBP | Volume discount |
1 | 29.95 | 19.95 | 19.95 | |
2-4 | 28.45 | 18.95 | 18.95 | 5% |
5-9 | 26.95 | 17.96 | 17.96 | 10% |
10-24 | 23.95 | 15.96 | 15.96 | 20% |
25-49 | 20.95 | 13.97 | 13.97 | 30% |
50 & more | ||||
If you are not happy with our product for any reason,
you will get your money back, no questions asked.