App Icon
Ablebits
•  225,034
Overview
Generate random passwords, numbers, custom values, booleans or dates according to your criteria.
Random Generator will be at hand whenever you need a random set of data in your sheet. 
Forget about puzzling over clever strong passwords: our add-on will quickly create any number of random strings that meet your requirements. All you need is pick a set of characters and choose the length for the created values.
 
The tool is also good at filling your range with workdays or weekends in the selected time period, getting unique numbers from the defined range, randomizing your custom values, or simply putting yes/no or true/false values at random. 

Create any set of random data in your Google sheet:

  • Generate strong passwords
  • Create random codes by masks
  • Pack your cells with dates
  • Generate real numbers and integers
  • Fill the range with Booleans
  • Shuffle your own values 

Since neither RAND nor RANDBETWEEN will be able to do that, our Random Generator will become irreplaceable for completing your spreadsheet with random passwords, dates, numbers, and other data of your choice.

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-generate-values/
We'll be happy to assist!

Random Generator is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:

***** V1.9 (5 May 2021) *****
Improved:
- The limits for custom list size were expanded.

Fixed:
- Created duplicates of custom lists.
- Errored if your 'Data validation' rules prevented the add-on from randomizing records.
- Didn't work if you run the tool from a sheet with its own separate chart.
- UX: the drop-down for 'Boolean' values displayed incorrectly making it impossible to choose a variant.
Reviews
Language:
Sort by:
Profile Picture
James Brooks
April 14, 2021
NOTED.
Is this review helpful?
Yes
No
Profile Pciture
Logan Scheich
April 14, 2021
Ok James.
Profile Picture
Mark Reed
January 1, 2021
Hmmm... Would love to see in run, but it states that Google Drive "refused to open.
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
January 29, 2021
Hello Mark, Thank you for contacting us. There is currently an issue on the side of Google that occurs when you are logged in under more than one account. Please sign out and log back in only under the account you used to grant permissions to the add-on and see if the issue persists.
Profile Picture
SanRaf2(A) California Santa Rosa Mission
December 27, 2020
LOVE IT! message me!
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 10, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
A User of Random Generator
March 14, 2020
My trial expired so I tried the other one in the marketplace that is free and has a lot more different data types.
Is this review helpful?
Yes
No
Profile Pciture
Shawna Geban
November 12, 2020
Hello what is the name of of the other one that you found?
Profile Pciture
A user of Random Generator
March 5, 2020
Hello, The add-on is designed to fill all cells in the selected range. If you also tick off the option Unique values, it fills as many cells as there are uniques within your range of values to generate. If this still doesn't solve your problem, we'd appreciate if you email our support team with the details. Please use the Ablebits link next to the ratings, and on the opened website go to Support > Report a bug. Thank you.
Profile Picture
A User of Random Generator
January 10, 2020
This add-on is great! I use it to assist in generating multiple word problems and math puzzles for elementary students. Well worth the cost!
Is this review helpful?
Yes
No
Profile Picture
A User of Random Generator
July 31, 2018
Absolutely love this. I use it to keep my Instagram hashtags fresh and not over used. Too bad it only has a free trial. I'll have to figure out how to code this myself.
Is this review helpful?
Yes
No
Profile Pciture
A user of Random Generator
November 12, 2018
Hello, Our add-ons don't provide any files to download to your PC - everything should be installed straight in Google Sheets and it works only there. The evaluation version offers unlimited functionality for 30 days. Once the trial expires, it will prompt you to either order a subscription (2 plans for your choice) or uninstall the add-on.
Profile Pciture
A user of Random Generator
November 8, 2018
I can barely tell it does... what are the terms of the trial? Is this a winrar deal where I just can't use it for commercial purposes or is there a hidden time limit or what?
Profile Picture
A User of Random Generator
July 25, 2018
This is very easy to use. There are lots of options that you can use for the random generator. The only problem I had was that it gave me one entry at a time.
Is this review helpful?
Yes
No
Profile Picture
A User of Random Generator
July 10, 2018
Not a free app.
Is this review helpful?
Yes
No
Profile Picture
A User of Random Generator
June 29, 2018
It isn't free, they charge you, you only get one free generation per day. Completely useless as a free app.
Is this review helpful?
Yes
No
1-10 of 16
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu