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.

Random Data Generator screenshot

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, 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

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.

Payment

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.

Installation

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.

rdg installation screen

Read and accept the license agreement:

rdg license screen

Read the included readme 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 and up, click the newly created RDG tab. It's that simple.

Compatibility

Excel 2003 logo Microsoft Excel 2003 Excel 2007 logo Microsoft Excel 2007 Excel 2010 logo Microsoft Excel 2010 Excel 2013 logo Microsoft Excel 2013

Works in Excel 2003-2013, for 32-bit versions of Office only. See System Requirements for more details.

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.

Random Data Generator selected fields

Once the file is saved, a success message is printed to the screen.

Random Data Generator output complete

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).

Random Data Generator Access output

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!

Random Data Generator Access table

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

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.

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.

Official PayPal Seal

Site last updated: August 20, 2014