Skip to content

How to Use Mock Data Generator

Generate realistic fake test data with 30+ field types and export up to 1,000 rows as JSON, CSV, SQL inserts or XML. Free mock data generator.

About this tool

The mock data generator creates realistic fake records for testing apps, seeding databases and building demos. Add fields and pick types such as names, emails, phone numbers, addresses, companies, prices, UUIDs, dates, booleans and text, then generate up to 1,000 rows and export them as JSON, CSV, SQL INSERT statements or XML.

How to use Mock Data Generator

  1. Add fields, give each a name and choose its data type.
  2. Set the number of rows and choose JSON, CSV, SQL or XML (with a table name for SQL).
  3. Click Generate data, then copy or download the result.

Worked example

Fields id, first_name, email and signup_date with 100 rows and SQL format give 100 INSERT statements to seed a users table, with each email matching the person's name.

Is the generated data real?

No. It is random and fictional. Emails use reserved example domains, phone numbers use the 555 test range and web addresses use the .example domain.

Can I use it for load testing?

Yes, for up to 1,000 rows per run. For larger datasets, generate several times or use the data as a template.

Does it follow my database types?

Numbers and booleans are unquoted and strings are escaped for SQL, but check the column types in your schema.

Put this guide into practice

  • Mock Data Generator — Generate realistic fake data as JSON, CSV, SQL or XML for testing and demos.

Explore Data Generators · More practical guides

Accessibility Menu

Personalize your experience. Open with Ctrl+U (Option+U on Mac). Preferences stay in this browser when storage is available.

Move / Hide Widget

Restore at any time with Ctrl+U (Option+U on Mac).

Accessibility statement and help