Random Generator for Google Sheets

Create almost any type of random data in your spreadsheet

Add this sidebar add-on to your Google Sheets and select from 6 types of random data to fill the selected range. It is a useful tool for creating strong passwords, generating random numbers, and populating cells with dates within a certain time period.

Try it for 30 days for free
Random Generator for Google Sheets

With Random Generator you will

  • Generate random numbers and dates Fill the selected сells with random numbers both real and integer, or dates from within any period of time.
  • Create strong passwords Get random strings of any length, pattern, and character set.
  • Make use of random choice generator Have YES/NO and TRUE/FALSE Booleans pasted to your cells in no particular order.
  • Randomize custom lists Form a list of your own values and mix them in a selected range.

How to generate random data in Google Sheets

   
Get a list of random integers…
Get a list of random integers…
…or fill the range with real numbers
…or fill the range with real numbers
Have the cells topped up with Booleans
Have the cells topped up with Booleans
Generate dates, include or exclude weekends or workdays
Generate dates, include or exclude weekends or workdays
Use custom lists to randomize your own records
Use custom lists to randomize your own records
Create strong passwords of any length and from various characters
Create strong passwords of any length and from various characters
The masks will help you generate keys, codes, and other strings of a particular pattern
The masks will help you generate keys, codes, and other strings of a particular pattern
Get a list of random integers…
…or fill the range with real numbers
Have the cells topped up with Booleans
Generate dates, include or exclude weekends or workdays
Use custom lists to randomize your own records
Create strong passwords of any length and from various characters
The masks will help you generate keys, codes, and other strings of a particular pattern

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Volume discounts: the more you buy, the less you pay
Free support

These companies choose Ablebits products

   

Frequently asked questions

About Random Generator for Google Sheets

  • What is Random Generator and what do I need it for?

    The tool is designed to help you get random records of most common types within a certain range.

    Whether your task is to assign duty dates or raffle numbers, create strong passwords or get YES/NO and TRUE/FALSE Booleans, this add-on will help you stay unbiased.

  • Isn’t there a free way to generate data in Google spreadsheets?

    There is, but not without pitfalls.

    There are two special functions: RAND to generate a number between 0 and 1 and RANDBETWEEN to return random integers within two values of your choice. Alas, the functions cannot produce any other type of data and the formulas should be copied all over the range of interest manually. What’s more, they are volatile, meaning the formulas recalculate themselves with each new calculation on the spreadsheet.

    Our add-on lets you generate not only numbers, but also letters, dates, Booleans, passwords, entire strings of characters, and even words from your custom lists.

  • How to generate random data in Google Sheets?

    Select the range, run the tool, choose the data type, and click Generate. Yes, it’s that easy! :)

    See a more detailed description here.

  • Isn't there a chance to get a repeated value? I’d rather avoid that.

    The add-on acts in accordance with your settings. For any type of value, there’s an option to generate unique values only. Turn this option on/off depending on what you’d like to get.

  • I need to generate only workdays for our shifts plan, can I do that?

    Sure! Just specify the date period and then exclude weekends from the generated dates. You can include them back anytime if necessary.

  • How do I create strong passwords with your tool?

    Flexible settings let you generate strings of any pattern. Choose from a set of standard characters (capital and small letters, numbers, hexadecimals, spaces, or other symbols) or enter custom ones, define the length for the created values, or add your own mask for new values.

Choose your plan

12-months

  • 12-month access with all updates
$15.00
Buy now

Lifetime

  • Get all new features and updates for free ever!
$39.95
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close