Random Data Generator v3.3.2 (RDG) is an add-in for Microsoft® Excel® 2003-2013 (32-bit Office) that lets you easily create fake, randomly generated personal and demographic information in Excel.
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.
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, MySQL, other 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 (SOX) and HIPAA by not exposing real customer data to loss or theft
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.
Multiple Data Fields
See the Features page for a list of data fields you can generate.
In total, 64 fields may be generated using the Random Data Generator add-in!
Multiple Output Formats
See the Features page for a list of output formats.
The Random Data Generator Add-In for Excel costs $29.95 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.Purchase
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.
Download and extract the archive. You must uninstall any previous versions of Random Data Generator. Close Excel and run the .exe program to install the add-in.
Read and accept the license agreement:
Read the included readme file for additional details about the add-in. The installer does not include any toolbars, free trials, spyware or viruses.
Go to Data Menu » Random Data Generator to get started (Excel 2003). In Excel 2007 and up, click the newly created RDG tab. It's that simple.
Microsoft Excel 2003 Microsoft Excel 2007 Microsoft Excel 2010 Microsoft Excel 2013
Works in Excel 2003-2013, for 32-bit versions of Office only. See System Requirements for more details.
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.
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 "RandomData". (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:Purchase
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.
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.