Help & Support
Send Feedback
Random Generator
Generate random passwords, numbers, custom values, booleans or dates according to your criteria
30,231 users
Works with
Install
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.

What's new?

Version 1.8: We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

If you have any questions about the add-on, please post them here: https://www.ablebits.com/docs/howto-generate-google-values/
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
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.
Submit reply
Cancel
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.
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?
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.
Submit reply
Cancel
A User of Random Generator
July 10, 2018
Not a free app.
Submit reply
Cancel
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.
Submit reply
Cancel
John Webster
May 26, 2018
Worked perfectly - the ability to choose which special characters you wanted is excellent
Submit reply
Cancel
A User of Random Generator
March 29, 2018
Wonderful tool! Too bad it's not free anymore.
Submit reply
Cancel
A user of Random Generator
October 12, 2018
I know.
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.
Submit reply
Cancel
A user of Random Generator
July 17, 2017
Could you show an example?
A User of Random Generator
January 26, 2015
Distribution is terrible. Sticks on certain numbers and locks up.
Submit reply
Cancel
Maria Alvarez
November 26, 2014
Made my browser crash several times, had to delete it.
Submit reply
Cancel
A user of Random Generator
December 17, 2018
linos wife righ
A User of Random Generator
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.
Submit reply
Cancel
1-10 of 10
Additional information
Search
Clear search
Close search
Google apps
Main menu