This program gives you:

Numerous Data Types Multiple Output Formats A Simple User Interface Configurable Options

Numerous Data Types

There are over 50 data types output by Random Data Generator, including demographic and personal information:

Free Version
Pro Version
AddressA random house number and street chosen from popular street namesYesYes
AutoNumberSame as the ROW() function, or the Access AutoNumber field, can be used for unique IDYesYes
Birthdaya valid date between today and January 1, 1900, or any two dates you specify in the Options menuYesYes
Blood TypeA, B, O, AB (positive or negative)NoYes
BooleanTrue or FalseNoYes
ByteA number between 0 and 255NoYes
CAS Registry NumberA syntactically valid CAS Registry NumberNoYes
City/State/ZipA valid combination of city name, state abbreviation and zip code from 250 most populated cities in the United StatesNoYes
Company NameA fictitious company name chosen from a predefined listYesYes
ContinentsA randomly chosen continent nameNoYes
CountryAll U.S. State Department recognized countriesYesYes
Country CapitalsCapitals of all U.S. State Department recognized countriesNoYes
Country Code (ISO)Country code abbreviation from ISO 3166YesYes
Credit Card NumberSyntactically valid AmEx, Discover, Visa, MC, Diner's Club credit card numbers (in)validated with Luhn algorithmNoYes
DateRandom date between today and January 1, 1900, or any two dates you specify in the Options menuYesYes
Day (Number)Random day number (1 to 31)YesYes
Day Of WeekDay of week (Monday through Sunday)YesYes
DepartmentA list of common company department titlesNoYes
Driver's LicenseValid format (based on current state requirements) driver's license number from up to 50 statesNoYes
Email AddressA random first initial-last name combination, followed by a randomly chosen popular domain nameYesYes
Fax Number (US)A U.S. formatted fax numberNoYes
First NameA randomly chosen first name from a list of 1,000+YesYes
Fiscal QuarterQuarter abbreviations: Q1, Q2, Q3, Q4YesYes
GenderMale or FemaleYesYes
GPAA calculated GPA scoreNoYes
GUIDValid format GUIDNoYes
Hire DateA random date between today and January 1, 1900, or any two dates you specify in the Options menuNoYes
ICD-10 CodeA syntactically valid ICD-10 numberNoYes
IMEI CodeA syntactically valid IMEI Code (in)validated with Luhn algorithmNoYes
IntegerA number in the Integer range (-32768 to 32767). Can be generated using RANDOM.ORG API or Mersenne Twister algorithm.NoYes
Internet TLDFrom Wikipedia's list of Internet top-level domain abbreviationsNoYes
ISBNA 10 or 13 digit ISBN (depending on setting on Options menu)NoYes
Job TitleA list of commonly used job titlesNoYes
Last NameA randomly chosen last name from a list of 1,000+YesYes
LatitudeA randomly calculated point of latitudeNoYes
LongRandom numbers of the type Long (-2,147,483,648 to 2,147,483,647). Can be generated using Mersenne Twister algorithm.YesYes
LongitudeA randomly calculated point of longitudeNoYes
MAC AddressSix pairs of hex characters ([0-9,A-F]) separated by hyphensNoYes
Middle InitialLetter from A to ZYesYes
Marital StatusSingle or MarriedNoYes
MonthJanuary through DecemberYesYes
Mother's Maiden NameA randomly chosen maiden (last) name from a list of 1,000+YesYes
Name PrefixMr.,Ms.,Mrs. and so onYesYes
Name SuffixJr.,Sr.,Ph.D. and so onYesYes
NDC NumberA syntactically valid National Drug Code DirectoryNoYes
NPI NumberA syntactically valid National Provider Identifier (in)validated with Luhn algorithmNoYes
OceansA list of the world's oceansNoYes
PasswordCharacter string with uppercase, lowercase, numbers and special characters.YesYes
Province (Canada)A list of Canadian provincesNoYes
Random StringsCharacter string with uppercase, lowercase, numbers and special characters. Can be generated using RANDOM.ORG API.NoYes
SalaryRandom currency value from 0 to 1,000,000, or whatever range you specify on Options menuYesYes
SAT ScoreStandard score of 600 to 2400 in multiples of tenNoYes
SeasonsWinter, Spring, Summer, FallYesYes
SIN (Canada)Canadian SIN in the format NNN-NNN-NNN (in)validated with Luhn algorithmNoYes
SSNa United States SSN formatted as NNN-NN-NNNNNoYes
Telephone (UK – London)London formatted phone number: (020) NNNN NNNNYesYes
Telephone (US)U.S.-based telephone number formatted as (NNN) NNN-NNNNYesYes
TimeAM or PM, 12-hour clockYesYes
Tracking NumbersRandomly generated tracking numbers from UPS, FedEx, USPS, DHLNoYes
UPCA 12 or 13 digit industry standard UPC codeNoYes
UUIDUniversal Unique IdentifierNoYes
VINA syntactically valid VIN number as described on WikipediaNoYes
WeightA random number between 50 and 350NoYes
YearA valid year between current year and 1900, or any two dates you specify in the Options menuYesYes

Buy Random Data Generator Now

Multiple Output Formats

Random Data Generator outputs to the following formats:

Output Type
Excel 2003 Excel 2003 logo
Excel 2007 Excel 2007 logo
Excel 2010 Excel 2010 logo
Excel 2013 Excel 2013 logo
This WorksheetCurrently active worksheetYesYesYesYes
This WorkbookA new worksheet in the current workbook YesYesYesYes
CSVComma Separated ValuesYesYesYesYes
HTM/HTMLMicrosoft Web PageYesYesYesYes
HTMLHTML 4.01 Transitional valid web pageYesYesYesYes
MDBMicrosoft Access DatabaseYesYesYesYes
ACCDBMicrosoft Access DatabaseYesYesYesYes
TXTText File (Tab Delimited)YesYesYesYes
XLSExcel 2003 SpreadsheetYesYesYesYes
XMLXML SpreadsheetYesYesYesYes
XMLWell-formed XML (with XSD definition file for remote validation)YesYesYesYes
MySQLDatabase creation scriptYesYesYesYes
XLSX*Excel 2007/2010 SpreadsheetNYesYesYes
XLSM*Excel 2007/2010 Macro-Enabled SpreadsheetNYesYesYes
XLSB*Excel 2007/2010 Binary SpreadsheetNYesYesYes

*Note: Excel 2003 users that have installed the 2007 compatibility pack can save to Excel 2007+ file formats.
Buy Random Data Generator Now

Simple User Interface

The UI is based on existing dialogs to maximize productivity.

Random Data Generator screenshot

Configurable Options

Starting with Random Data Generator 3.2, you can now set various output parameters using an options screen inside the program.

In-Program Help

Click the Help button for a short description of how to use the program, with a link to the support forum if you need further assistance.

Random Data Generator Help
Buy Random Data Generator Now

Integrated With Excel

Random Data Generator is written as a VB6 COM add-in and as such is fully integrated into Excel versions 2003, 2007 and 2010 (32-bit Microsoft Office). Check System Requirements for more information regarding compatibility.

Supported Excel Versions

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


Create randomly generated data for use in your VBA programs. After installing Random Data Generator, the following sample code will show you how you can create and return random data to an array:

Dim RDG As Object ' RandomDataGenerator.RDG if early bound
Dim randomPeople As Variant
Dim i As Long, j As Long

Set RDG = CreateObject("RandomDataGenerator.RDG")
randomPeople = RDG.GetRandom(Array("First Name", "Last Name", "SSN"), 100)

' paste to worksheet?
Range("A1:C" & UBound(randomPeople)).Value = randomPeople

' loop?
For i = LBound(randomPeople) To UBound(randomPeople)
  For j = LBound(randomPeople, 2) To UBound(randomPeople, 2)
    Debug.Print randomPeople(i, j)
  Next j
Next i

To declare an early bound reference to RDG, go to Tools » References in the VBA Editor and scroll down to "Random Data Generator", or click Browse and go to C:\Program Files\Random Data Generator\RandomDataGenerator.dll.

Buy Random Data Generator Now

Site last updated: August 20, 2014