Generate random passwords, numbers, custom values, booleans or dates according to your criteria.
Listing updated:August 1, 2024
Works with:
422K+
Overview
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.10 (1 Mar 2022) *****
Improved:
- Minor UX and UI improvements.

Fixed:
- The add-on couldn't paste data into the file without a set time zone.
- Added time units when generated dates.
- Generated incorrect integers of 15+ characters.

***** 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.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Random Generator will ask for the permissions shown below. Learn more
Random Generator will need access to your Google account
This will allow Random Generator to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Владимир
July 17, 2024
What is generated is not what you ask for. If you check the numbers, it does not add numbers. You check the box for large and small letters - it makes only capital letters. Well, what's the point of such an application?
Is this review helpful?
Yes
No
Profile Picture
Taemin Jin
March 11, 2014
It does exactly what it says it will do, and it's super easy to use, even at first glance. Of course, most people will probably not need things randomized on a regular basis (unless you're doing research or something), but I can't think of any reason not to get this add-on, if only to have it tucked away in case you ever need it, especially since it's so easy to use. It's so user-friendly that at the worst-case scenario, you would have wasted a whole 30 seconds adding it and learning its interface.
Is this review helpful?
Yes
No
Profile Picture
A User of Random Generator
August 21, 2016
This works as designed and is very useful for my needs. However, one thing I would really love to have/need is a way to show others when I hit the number generator for a shared file.
Is this review helpful?
Yes
No
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
Lkate N
May 24, 2021
USELESS
Is this review helpful?
Yes
No
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 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 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
Samuel Lopez
March 29, 2018
Wonderful tool! Too bad it's not free anymore.
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 14
Search
Clear search
Close search
Google apps
Main menu