Use this tool to generate test data in CSV format.


The random data generated is based on the header record you enter below. Each header keyword is a special word that indicates what type of data to generate. The list of keywords is listed below, also see the example. You can very easily generate up to 99,999 records of sample test data. The data supported includes text, numbers, name and company data, latitude and longitute, and others.

NEW -You can now Save the complete settings, and then later Load them from your saved file.
Enter each keyword separated by a delimiter:    


Allowable Keywords
ageperson's age 1 to 120
string of letters a to z mixed case
and if n specified then exactly n length long, i.e. alpha(5)
birthdaydate of birth in mm/dd/yyyy format or birthday(2) for dd/mm/yyyy
booltrue or false
char1 single character of a letter or digits or !@#$%^&*()
ccnumberCredit Card Number
or date(3)
or date(4)
date in mm/dd/yyyy format or
date(2) for dd/mm/yyyy
or date(3) for yyyy/mm/dd
or date(4) for yyyymmdd
digit - 5-20 digits
digits(n) where n is a number will generate a string exactly that long, i.e. digit(5)
See also: integer,float,natural, seq
dollarDollar amount in format of $99999.99
domaindomain name
emaildummy email address
firstFirst name
floatFloating/Real number with at most 4 digits to right of decimal
See also: integer,natural,seq,digit
genderMale or Female
guidGlobally Unique Identifier
integerInteger value - includes negatives.
See also: natural,float,seq,digit
lastLast name
mimiddle initial - 1 letter
namefull person's name
Integer value 0 or above, or
natural(n) where n is maximum integer value
See also: integer,float,seq,digit
paragraphparagraph of words - 3 to 7 sentences
phoneUS phone number 999-999-9999
pick(pick1|pick2|...)choose one of choices separated by |
postalCanadian postal (see also province)
provinceCanadian pronvince (see also postal)
numeric integer sequence starting at 1 or n and incremented by 1
seq(n) - sequence starts at integer n, i.e. seq(1000)
sentencesentence words - 12 to 18 words
streetstreet address
random string value of letters,digits, and !@#$%^&*()
string(n) where n is length.
wordwords - 5-6 letters
ynY or N
zip5 digit US zip code
zip99 digit US zip code in 99999-9999 format
NOTEMost functions in the library can be run if not listed above.
Enter the name of the function without the prefix "chance." i.e. prefix. There is limited support to pass parameters to the chance function, i.e. age({type:'child'}). if you have a comma in the function - wrap the function in double quotes.
  Thanks to Javascript library