Random Data Generator (RDG) is an add-in for Microsoft® Excel® 2003-2010 (32-bit Office) that lets you easily create fake, randomly generated personal and demographic information in Excel.
Uses
The fields generated by Random Data Generator can be used in applications such as PivotTables, macros, charts, tutorials, web demos — anywhere that fake test data is needed, without using actual personal information (which may be protected by Sarbanes-Oxley [SOX] and/or the Health Insurance Portability and Accountability Act [HIPAA]).
The output data has many applications. It can be imported into RDBMS applications such as SQL or Oracle databases, used by other programming languages such as .NET, SAS or PHP, or included in automation processes across platforms that accept TXT or CSV formats.
IT administrators: do you set login passwords to expire at regular intervals? Use RDG to generate passwords for new users, or create new passwords for existing users whose passwords have expired.
Companies: do you run web demos or online training sessions for clients? Use RDG to create sample logins for yourself and for your clients, as well as fake scenarios to demonstrate your products.
Rationale
To comply with privacy regulations (HIPAA, Sarbanes-Oxley) and improve data security, organizations that handle sensitive consumer data (names, SSN, DOB, etc) should use fake data when conducting software tests. This Excel add-in allows the end user to generate quantities of fake data for testing purposes, data such as Gender, Name (First and Last), SSN, DOB, Address, City, State, Zip, Phone.
Use Random Data Generator to:
-
Create sample data sets for import into other applications (SAP, Oracle, RDBMS)
-
Demonstrate web applications ("web demos") for customers without using real data
-
Load testing for macros or charts on small or large data sets
-
Comply with Sarbanes-Oxley and HIPAA by not exposing real customer data to loss or theft
Save Time
Save time searching for random sample data, generate your own with Random Data Generator!
You could spend hours trying to figure out how to put together sample fields, and days trying to output it in the format you need. This add-in changes all that. Even casual Excel users can now produce data sets for use in almost any program that accepts output in any of the formats output by the Random Data Generator add-in. No VBA skills required.
Here's a screenshot of the Random Data Generator form:
- Learn more about Random Data Generator
- Purchase Random Data Generator for Excel 2003-2010
- Read the License Agreement
- Become an authorized reseller
- Student Discount now available!
Multiple Data Fields
You may generate fake test data for the following fields:
Address – house number and street name
AutoNumber – same as ROW() function, or the Access field of the same name
Birthday – a valid date between today and 90 years prior
City/State/Zip – valid combination of city name, state abbreviation and zip code
Company Name – fictitious company name
Country – country abbreviation from a list of recognized countries
Credit Card Number – fake CC number using AmEx, Discover, Visa or Mastercard format
Date – random date between today and 90 years prior
Day – random day number (1 to 31)
Day Of Week – day of week (Monday through Sunday)
Email Address – a random 5-10 character username followed by one of 20 randomly selected domains
First Name – chosen from 4500+ first names
Fiscal Quarter – Q1, Q2, Q3, Q4
Gender - Male or Female, randomly assigned to each record
Last Name – chosen from 4500+ last names
Latitude – a randomly selected point in the United States
Longitude – a randomly selected point in the United States
Middle Initial – capital A-Z
Month – January through December
Mother's Maiden Name – chosen from 4500+ maiden names
Name Prefix – Mr.,Ms.,Mrs. and so on
Name Suffix – Jr.,Sr.,Ph.D. and so on
Number – random number between 1 and 100
Password – 8-12 character password with uppercase, lowercase and special characters
SAT Score – 600-2400 score in multiples of ten
SSN – a United States SSN formatted as NNN-NN-NNNN
Salary – a random number between 10,000 and 500,000
Season – Winter, Spring, Summer, Fall
Telephone (US) – U.S.-based telephone number formatted as (NNN) NNN-NNNN
Telephone (UK) – London formatted phone number: (020) NNNN NNNN
Time – AM or PM, 12-hour clock
Year – A random year between the current year and 90 years prior
In total, 32 fields may be generated using the Random Data Generator add-in!
Multiple Output Formats
The following output formats are supported:
- Comma Separated Values (.csv)
- Web Page (.htm or .html)
- Microsoft Access Database (.mdb) (.accdb in Excel 2007-2010)
- Text File (Tab Delimited) (.txt)
- Excel 2003 Spreadsheet (.xls)
- Excel 5.0/95 Format (.xls)
- Excel 2007-2010 Spreadsheet (.xlsx) (Excel 2007-2010)
- Excel 2007-2010 Binary Spreadsheet (.xlsb) (Excel 2007-2010)
- XML Spreadsheet (.xml)
You may also output to the current workbook (a new sheet will be created for the records). Up to 65,535 records may be created in any of these formats (1M+ records in Excel 2007+).
Payment
The Random Data Generator Add-In for Excel costs $35 USD. Payment is accepted via PayPal. Once your payment is received, you are redirected to the download page and you will receive an email with the download link. You have five attempts to download the file. The download link will expire in 120 hours (5 days) from the time the link is issued. If you cannot download the file, or the link has expired, use the contact form to let me know.
Note: Each payment confers a single license to the end user, to be used on one computer system, regardless of the number of download attempts.
Money Back Guarantee
This add-in is guaranteed for 30 days from date of purchase. If for any reason you are unsatisfied with the add-in, simply contact me to request a refund.
- Learn more about Random Data Generator
- Purchase Random Data Generator for Excel 2003-2010
- Read the License Agreement
- Become an authorized reseller
- Student Discount now available!
Installation
Download and extract the archive. Make sure you close all running instances of Excel before proceeding. You should also have uninstalled any previous versions of the application. Run the .EXE program to install the add-in. Read the included readme.txt file for additional details about the add-in.
The installer does not include any toolbars, free trials, spyware or viruses.
Usage
Go to Data Menu » Random Data Generator to get started (Excel 2003). In Excel 2007-2010, click the Add-Ins tab. It's that simple.
Compatibility
Works on 32-bit Office only.
Example Output
Let's produce some sample data as an example. Here's a typical set of fields for a phony person database (mdb). I've arranged the output fields in the order I want them to appear in the database.
After clicking Submit, the fields are randomly generated, then you are prompted for the MDB save location.
Once the file is saved, a success message is printed to the screen.
The database is saved to the save location with the date and time appended to the filename. Open the file and there is a single table called "RandomSampleData". (You may need Microsoft Access in order to view the file).
And you can see the 200 records in the Access table for the fields we requested. In just a few seconds we produced 200 fake records for use in testing out queries or report templates!
Still not convinced?
Read my blog post about the add-in: Random sample data generator add-in for Excel now available.
Check out these mentions of RDG on other sites:
Reseller/Affiliate Program
If you operate a website or blog, or would simply like to make extra money, sign up to resell Random Data Generator. Earn 30% commission for each referral. For more information about the affiliate program click here.
- Learn more about Random Data Generator
- Purchase Random Data Generator for Excel 2003-2010
- Read the License Agreement
- Become an authorized reseller
- Student Discount now available!
Note: The output of this add-in is random and any similarity to any person living or dead is merely coincidental. Credit card and Social Security Number information is fictional and for demonstration and testing purposes only. Any other use may constitute fraud.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Brought to you by:
Jimmy Peña3008 41ST ST #3
Astoria, NY 11103
718-446-8225
