Generate Test Data

Use this tool to generate test data in CSV or JSON 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.

Enter each keyword separated by a delimiter:

Test Data Options:

Allowable Keywords:

KeywordDescription
ageperson's age 1 to 120
alpha
alpha(n)
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 !@#$%^&*()
citycities
ccnumberCredit Card Number
date
date(2)
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
digit(n)
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
float Floating/Real number with at most 4 digits to right of decimal
See also: integer,natural,seq,digit
genderMale or Female
guidGlobally Unique Identifier
integer Integer value - includes negatives.
See also: natural,float,seq,digit
lastLast name
latitudeLatitude
longitudeLongitude
mimiddle initial - 1 letter
namefull person's name
natural
natural(n)
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)
seq
seq(n)
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
statestate
streetstreet address
string
string(n)
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
NOTE Most functions in the chancejs.com 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 Chancejs.com Javascript library