Test data generator

Realistic fake data for testing and demos

To test a form, a report or a database you need data, and using real customer records for that is a privacy problem and often against the rules. Typing your own samples takes time and gives you data that is too neat. This generator produces as many made-up records as you need, with realistic names, emails, addresses and dates, so that screens look real and edge cases such as long names and accents appear.

What you can generate

• People: first and last names, full names, usernames, birth dates and job titles.
• Contact details: emails, phone numbers, street addresses, cities, postal codes and countries.
• Identifiers: sequential ids, UUIDs, IBANs with correct check digits and, on the Spanish version, NIF numbers with the right letter.
• Other values: companies, web addresses, IP addresses, colors, dates, whole and decimal numbers within a range, true or false values and short sentences.

Formats

JSON gives an array of objects, ready to use as a mock API response or a fixture. CSV and TSV open in a spreadsheet or import into a database. SQL INSERT produces one statement per row for the table name you give, with text quoted and apostrophes escaped, so you can paste it into a client to fill a table.

Repeatable results

Random data is a problem when a test must be repeated. Type any word in the seed box and you get exactly the same rows every time, on any device. Leave it blank and each click gives new data.

Safe by design

Emails use the domains example.com, example.org and example.net, which are reserved so that they never belong to a real person. American phone numbers use the 555-01xx range set aside for fiction. Names and addresses are combined at random, and addresses do not exist. A randomly built phone number in another country may still coincide with a real one, so use the data for testing only, never to contact anybody.

Limits

Up to 10,000 rows are generated at once. The values are plausible, not statistically realistic, and columns are independent apart from names and emails, and cities and postal codes, which go together. Everything is generated in your browser. To format the JSON afterwards, use the JSON formatter.