Skip to content

snowindy/csv-test-data-generator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 

Repository files navigation

CSV test data generator

This is command line tool test data generator project based on online solution http://www.convertcsv.com/generate-test-data.htm.

When you generate test data online at http://www.convertcsv.com/generate-test-data.htm your browser can only generate up to 50-100K rows, then it hangs. This tool is a good alternative if you want to generate MILLIONS test data rows, using the same definition syntax as used in online web service.

Usage

node generator.js <COLUMNS_DEFINITION NUMBER_OF_ROWS> <OUT_FILE>

COLUMNS_DEFINITION - columns definition from http://www.convertcsv.com/generate-test-data.htm (or see below "Allowed Keywords")

NUMBER_OF_ROWS - number of rows to generate

OUT_FILE - output file path

Command example:

node generator.js "email,first,last,age,street,city,state,zip,digid,date(3),latitude,longitude,pick(RED|BLUE|YELLOW|GREEN|WHITE),string" 10000 out1.csv

Allowed Keywords

Keyword: Description

age: person'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)

birthday: date of birth in mm/dd/yyyy format or birthday(2) for dd/mm/yyyy

bool: true or false

char: 1 single character of a letter or digits or !@#$%^&*()

city: cities

ccnumber: Credit 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

dollar: Dollar amount in format of $99999.99

domain: domain name

email: dummy email address

first: First name

float: Floating/Real number with at most 4 digits to right of decimal See also: integer,natural,seq,digit

gender: Male or Female

integer: Integer value - includes negatives. See also: natural,float,seq,digit

last: Last name

latitude: Latitude

longitude: Longitude

mi: middle initial - 1 letter

name: full 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

paragraph: paragraph of words - 3 to 7 sentences

phone: US phone number 999-999-9999

pick(pick1|pick2|...): choose one of choices separated by |

postal: Canadian postal (see also province)

province: Canadian 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)

sentence: sentence words - 12 to 18 words

state: state

street: street address

string string(n): random string value of letters,digits, and !@#$%^&*()

string(n) where n is length. word: words - 5-6 letters

yn: Y or N

zip: 5 digit US zip code

zip9: 9 digit US zip code in 99999-9999 format

About

CSV test data generator aimed, good for million of rows generation

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published