Random Generator will help you get the type of random data you need in your Google sheet. Fill cells with numbers, Booleans, dates, passwords, etc. in three simple steps: select the cells, choose the type of data, and click Generate. Please see the detailed instructions below.
Random Generator also processes cells in filtered & hidden rows & columns.
Select the range you want to fill in your sheet and open the add-on from Extensions > Random Generator > Start:
Or you can create and use your own lists instead:
One more way to identify the range is to click the Select range icon. A special pop-up will then appear inviting you to select the range on the sheet, or type it in the range, or hit Auto select to automatically take the entire used range (all data till the first empty row & column):
The last checkbox will make sure to generate only unique values whatever character sets you selected.
Good day. I would like to find out if duplicate numbers can occur when generating unique numbers on different days. In other words, can a duplicate number ever be generated from a person's account?
Thank you for your comment.
Please check the Unique values option if you want just unique numbers to be generated. Also, if you need to check your list for duplicates, you can use our Remove Duplicates tool.
If you have any other questions or need further assistance, please feel free to email us at firstname.lastname@example.org.
I'm wondering if the key license work on multiple devices and multiple Google account? I'm purchasing for company.
Thank you for your question.
Please note that a subscription for the Google Sheets add-on is account-based. If the product is going to be used under different Google accounts at the same time, you need to have several subscriptions, so there is one for each account. However, we don't impose any limitations on the number of devices or people who can work with the add-on at the same time, as many of your colleagues as you need can use the add-on under the same account on different PCs.
Please email us at email@example.com with the subscription plan you'd like to get and the number of users who need access to the add-on. We'll provide you with the pricing details and a direct link to the purchase order form. Thank you.
Dear Support Team,
I would like to use this Plugin to generate random but unique identifiers to my customers. However with random strings I cannot set that the new values should be unique. Do you have any solution how to avoid duplicates?
Thank you for the answer.
Each group of values (except Boolean and String) offers this option – Unique values. All you need to do is tick it off and no duplicates will be generated. The String group generates unique records by default.
I kindly ask you to look through the instructions closely, you will find the text description of the option and will see it on the screenshots.
I purchased this by mistake! Is there any way I can cancel and get a refund for my subscription?
Thank you for contacting us. I'm sorry you've encountered this problem.
Please email us to firstname.lastname@example.org with your order ID and the email address you purchased the subscription for.
We'll do our best to assist you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!