Mock Data Generator

Make up to 10,000 rows of realistic test data — names, emails, numbers, dates — as JSON, CSV, SQL inserts or NDJSON, repeatable from a seed.

On this device

Fields

Name
Kind
Start
Step
Empty %
Name
Kind
Empty %
Name
Kind
Empty %
Name
Kind
Empty %
Name
Kind
Empty %
Name
Kind
From
To
Empty %
Name
Kind
True %
Empty %

Data

Rows

SeedThe same seed gives the same rows.

The first 20 rows
id	name	email	phone	city	joined	active
1	Harpreet Jain	harpreet.jain1@example.org	+91 83582 37636	Hyderabad	2026-08-04	true
2	Deepak Kumar	deepak.kumar2@example.com	null	Panaji	2025-07-13	true
3	Mohan Joshi	mohan.joshi3@example.com	+91 78600 73695	Bengaluru	2025-04-23	true
4	Shreya Sharma	shreya.sharma4@example.net	+91 89781 43501	Mumbai	2026-01-29	false
5	Akash Menon	akash.menon5@example.net	+91 65442 91564	Ludhiana	2025-03-23	true
6	Deepak Joshi	deepak.joshi6@example.org	+91 80975 99587	Kolkata	2026-01-19	false
7	Mohan Ghosh	mohan.ghosh7@example.com	+91 67092 28300	Visakhapatnam	2026-04-04	false
8	Vivek Pillai	vivek.pillai8@example.com	+91 82532 89476	Jaipur	2026-05-15	true
9	Meera Agarwal	meera.agarwal9@example.net	+91 71833 98763	Surat	2025-03-14	true
10	Priya Pillai	priya.pillai10@example.com	+91 76682 06539	Bhubaneswar	2024-01-03	false
11	Aditi Yadav	aditi.yadav11@example.com	+91 67697 54746	Jaipur	2026-03-20	true
12	Arjun Jain	arjun.jain12@example.org	+91 62498 13061	Lucknow	2024-10-23	true
13	Ishaan Agarwal	ishaan.agarwal13@example.com	null	Bhopal	2024-04-18	false
14	Nisha Desai	nisha.desai14@example.com	+91 99631 29256	Surat	2025-07-08	true
15	Asha Gupta	asha.gupta15@example.net	+91 79174 96360	Ludhiana	2026-08-12	false
16	Sneha Patel	sneha.patel16@example.org	+91 61129 44412	Jaipur	2024-10-08	true
17	Lakshmi Singh	lakshmi.singh17@example.org	+91 95170 71597	Ahmedabad	2024-10-11	true
18	Uday Sharma	uday.sharma18@example.org	+91 63132 33886	Srinagar	2025-03-21	true
19	Rahul Agarwal	rahul.agarwal19@example.com	+91 84424 58049	Bengaluru	2025-11-21	true
20	Tanvi Khan	tanvi.khan20@example.org	+91 95336 47869	Delhi	2024-12-12	true

[
  {"id": 1, "name": "Harpreet Jain", "email": "harpreet.jain1@example.org", "phone": "+91 83582 37636", "city": "Hyderabad", "joined": "2026-08-04", "active": true},
  {"id": 2, "name": "Deepak Kumar", "email": "deepak.kumar2@example.com", "phone": null, "city": "Panaji", "joined": "2025-07-13", "active": true},
  {"id": 3, "name": "Mohan Joshi", "email": "mohan.joshi3@example.com", "phone": "+91 78600 73695", "city": "Bengaluru", "joined": "2025-04-23", "active": true},
  {"id": 4, "name": "Shreya Sharma", "email": "shreya.sharma4@example.net", "phone": "+91 89781 43501", "city": "Mumbai", "joined": "2026-01-29", "active": false},
  {"id": 5, "name": "Akash Menon", "email": "akash.menon5@example.net", "phone": "+91 65442 91564", "city": "Ludhiana", "joined": "2025-03-23", "active": true},
  {"id": 6, "name": "Deepak Joshi", "email": "deepak.joshi6@example.org", "phone": "+91 80975 99587", "city": "Kolkata", "joined": "2026-01-19", "active": false},
  {"id": 7, "name": "Mohan Ghosh", "email": "mohan.ghosh7@example.com", "phone": "+91 67092 28300", "city": "Visakhapatnam", "joined": "2026-04-04", "active": false},
  {"id": 8, "name": "Vivek Pillai", "email": "vivek.pillai8@example.com", "phone": "+91 82532 89476", "city": "Jaipur", "joined": "2026-05-15", "active": true},
  {"id": 9, "name": "Meera Agarwal", "email": "meera.agarwal9@example.net", "phone": "+91 71833 98763", "city": "Surat", "joined": "2025-03-14", "active": true},
  {"id": 10, "name": "Priya Pillai", "email": "priya.pillai10@example.com", "phone": "+91 76682 06539", "city": "Bhubaneswar", "joined": "2024-01-03", "active": false},
  {"id": 11, "name": "Aditi Yadav", "email": "aditi.yadav11@example.com", "phone": "+91 67697 54746", "city": "Jaipur", "joined": "2026-03-20", "active": true},
  {"id": 12, "name": "Arjun Jain", "email": "arjun.jain12@example.org", "phone": "+91 62498 13061", "city": "Lucknow", "joined": "2024-10-23", "active": true},
  {"id": 13, "name": "Ishaan Agarwal", "email": "ishaan.agarwal13@example.com", "phone": null, "city": "Bhopal", "joined": "2024-04-18", "active": false},
  {"id": 14, "name": "Nisha Desai", "email": "nisha.desai14@example.com", "phone": "+91 99631 29256", "city": "Surat", "joined": "2025-07-08", "active": true},
  {"id": 15, "name": "Asha Gupta", "email": "asha.gupta15@example.net", "phone": "+91 79174 96360", "city": "Ludhiana", "joined": "2026-08-12", "active": false},
  {"id": 16, "name": "Sneha Patel", "email": "sneha.patel16@example.org", "phone": "+91 61129 44412", "city": "Jaipur", "joined": "2024-10-08", "active": true},
  {"id": 17, "name": "Lakshmi Singh", "email": "lakshmi.singh17@example.org", "phone": "+91 95170 71597", "city": "Ahmedabad", "joined": "2024-10-11", "active": true},
  {"id": 18, "name": "Uday Sharma", "email": "uday.sharma18@example.org", "phone": "+91 63132 33886", "city": "Srinagar", "joined": "2025-03-21", "active": true},
  {"id": 19, "name": "Rahul Agarwal", "email": "rahul.agarwal19@example.com", "phone": "+91 84424 58049", "city": "Bengaluru", "joined": "2025-11-21", "active": true},
  {"id": 20, "name": "Tanvi Khan", "email": "tanvi.khan20@example.org", "phone": "+91 95336 47869", "city": "Delhi", "joined": "2024-12-12", "active": true},
  {"id": 21, "name": "Akash Khan", "email": "akash.khan21@example.net", "phone": "+91 83268 77517", "city": "Bengaluru", "joined": "2026-08-06", "active": true},
  {"id": 22, "name": "Suresh Banerjee", "email": "suresh.banerjee22@example.com", "phone": "+91 83651 18626", "city": "Mumbai", "joined": "2024-06-07", "active": true},
  {"id": 23, "name": "Ishaan Iyer", "email": "ishaan.iyer23@example.net", "phone": "+91 99748 21910", "city": "Bhubaneswar", "joined": "2025-01-13", "active": true},
  {"id": 24, "name": "Ravi Das", "email": "ravi.das24@example.org", "phone": "+91 78662 50199", "city": "Kolkata", "joined": "2024-10-21", "active": true},
  {"id": 25, "name": "Rohan Kumar", "email": "rohan.kumar25@example.com", "phone": "+91 87891 41087", "city": "Lucknow", "joined": "2026-04-08", "active": true},
  {"id": 26, "name": "Sneha Singh", "email": "sneha.singh26@example.com", "phone": "+91 95407 17496", "city": "Mumbai", "joined": "2025-05-06", "active": true},
  {"id": 27, "name": "Sanjay Iyer", "email": "sanjay.iyer27@example.org", "phone": "+91 76510 79375", "city": "Surat", "joined": "2025-10-17", "active": true},
  {"id": 28, "name": "Zoya Das", "email": "zoya.das28@example.org", "phone": "+91 62334 02205", "city": "Panaji", "joined": "2024-04-17", "active": true},
  {"id": 29, "name": "Gaurav Das", "email": "gaurav.das29@example.net", "phone": "+91 91324 41514", "city": "Chennai", "joined": "2025-03-28", "active": true},
  {"id": 30, "name": "Yash Nair", "email": "yash.nair30@example.com", "phone": "+91 90592 01537", "city": "Visakhapatnam", "joined": "2024-04-10", "active": true},
  {"id": 31, "name": "Uday Khan", "email": "uday.khan31@example.net", "phone": "+91 81020 75792", "city": "Panaji", "joined": "2025-03-26", "active": true},
  {"id": 32, "name": "Shreya Pillai", "email": "shreya.pillai32@example.net", "phone": "+91 97690 42237", "city": "Bengaluru", "joined": "2025-09-19", "active": false},
  {"id": 33, "name": "Pranav Patel", "email": "pranav.patel33@example.com", "phone": "+91 84943 29444", "city": "Patna", "joined": "2026-05-19", "active": true},
  {"id": 34, "name": "Ravi Singh", "email": "ravi.singh34@example.net", "phone": "+91 65276 82428", "city": "Guwahati", "joined": "2025-06-17", "active": true},
  {"id": 35, "name": "Ishaan Chauhan", "email": "ishaan.chauhan35@example.org", "phone": "+91 98547 46503", "city": "Guwahati", "joined": "2025-10-08", "active": true},
  {"id": 36, "name": "Lakshmi Das", "email": "lakshmi.das36@example.org", "phone": "+91 63801 39544", "city": "Ranchi", "joined": "2024-01-18", "active": true},
  {"id": 37, "name": "Sneha Verma", "email": "sneha.verma37@example.org", "phone": "+91 89075 89741", "city": "Ludhiana", "joined": "2026-06-27", "active": true},
  {"id": 38, "name": "Farhan Agarwal", "email": "farhan.agarwal38@example.net", "phone": "+91 60688 19140", "city": "Bhopal", "joined": "2026-03-03", "active": true},
  {"id": 39, "name": "Rohan Reddy", "email": "rohan.reddy39@example.com", "phone": "+91 91837 38349", "city": "Lucknow", "joined": "2024-06-02", "active": true},
  {"id": 40, "name": "Akash Gill", "email": "akash.gill40@example.net", "phone": "+91 72915 72168", "city": "Pune", "joined": "2025-04-29", "active": false},
  {"id": 41, "name": "Uday Sharma", "email": "uday.sharma41@example.com", "phone": "+91 96253 44352", "city": "Indore", "joined": "2024-07-24", "active": true},
  {"id": 42, "name": "Arjun Khan", "email": "arjun.khan42@example.net", "phone": "+91 92893 28465", "city": "Dehradun", "joined": "2025-01-31", "active": true},
  {"id": 43, "name": "Sneha Gupta", "email": "sneha.gupta43@example.net", "phone": "+91 74895 99837", "city": "Pune", "joined": "2025-11-28", "active": false},
  {"id": 44, "name": "Arjun Mishra", "email": "arjun.mishra44@example.com", "phone": "+91 89341 80062", "city": "Nagpur", "joined": "2024-05-30", "active": true},
  {"id": 45, "name": "Divya Das", "email": "divya.das45@example.net", "phone": "+91 63119 24503", "city": "Chennai", "joined": "2025-04-24", "active": true},
  {"id": 46, "name": "Neha Chauhan", "email": "neha.chauhan46@example.org", "phone": "+91 71708 76100", "city": "Surat", "joined": "2024-12-10", "active": true},
  {"id": 47, "name": "Suresh Iyer", "email": "suresh.iyer47@example.net", "phone": "+91 61909 64524", "city": "Jaipur", "joined": "2024-04-18", "active": true},
  {"id": 48, "name": "Shreya Pillai", "email": "shreya.pillai48@example.com", "phone": "+91 77073 75121", "city": "Pune", "joined": "2025-11-20", "active": true},
  {"id": 49, "name": "Lakshmi Jain", "email": "lakshmi.jain49@example.com", "phone": null, "city": "Thiruvananthapuram", "joined": "2024-12-10", "active": true},
  {"id": 50, "name": "Farhan Kumar", "email": "farhan.kumar50@example.org", "phone": "+91 80819 76473", "city": "Ahmedabad", "joined": "2026-06-03", "active": true},
  {"id": 51, "name": "Nikhil Chauhan", "email": "nikhil.chauhan51@example.net", "phone": "+91 61658 39135", "city": "Kolkata", "joined": "2026-08-29", "active": true},
  {"id": 52, "name": "Zoya Jain", "email": "zoya.jain52@example.com", "phone": "+91 88886 72566", "city": "Mysuru", "joined": "2024-02-20", "active": false},
  {"id": 53, "name": "Nikhil Kapoor", "email": "nikhil.kapoor53@example.net", "phone": "+91 88727 02272", "city": "Lucknow", "joined": "2024-03-29", "active": true},
  {"id": 54, "name": "Gaurav Gill", "email": "gaurav.gill54@example.org", "phone": "+91 88399 11232", "city": "Mumbai", "joined": "2026-07-06", "active": true},
  {"id": 55, "name": "Aarav Rao", "email": "aarav.rao55@example.net", "phone": "+91 69872 17344", "city": "Surat", "joined": "2024-04-13", "active": true},
  {"id": 56, "name": "Gaurav Desai", "email": "gaurav.desai56@example.com", "phone": "+91 92642 50486", "city": "Kanpur", "joined": "2024-11-03", "active": true},
  {"id": 57, "name": "Harpreet Desai", "email": "harpreet.desai57@example.com", "phone": "+91 87958 04748", "city": "Hyderabad", "joined": "2025-06-30", "active": true},
  {"id": 58, "name": "Farhan Jain", "email": "farhan.jain58@example.org", "phone": "+91 62734 37443", "city": "Srinagar", "joined": "2024-08-04", "active": true},
  {"id": 59, "name": "Asha Saxena", "email": "asha.saxena59@example.com", "phone": "+91 95131 66691", "city": "Chandigarh", "joined": "2025-05-30", "active": true},
  {"id": 60, "name": "Asha Reddy", "email": "asha.reddy60@example.com", "phone": "+91 61524 26963", "city": "Bhopal", "joined": "2026-02-23", "active": true},
  {"id": 61, "name": "Shreya Kumar", "email": "shreya.kumar61@example.com", "phone": "+91 66679 20544", "city": "Nagpur", "joined": "2024-06-01", "active": false},
  {"id": 62, "name": "Nikhil Saxena", "email": "nikhil.saxena62@example.net", "phone": "+91 94601 31618", "city": "Visakhapatnam", "joined": "2025-07-21", "active": true},
  {"id": 63, "name": "Ananya Singh", "email": "ananya.singh63@example.net", "phone": "+91 85509 15510", "city": "Visakhapatnam", "joined": "2026-02-13", "active": true},
  {"id": 64, "name": "Kavya Agarwal", "email": "kavya.agarwal64@example.net", "phone": null, "city": "Kolkata", "joined": "2024-04-07", "active": true},
  {"id": 65, "name": "Ananya Menon", "email": "ananya.menon65@example.net", "phone": "+91 64693 17265", "city": "Ahmedabad", "joined": "2024-07-16", "active": false},
  {"id": 66, "name": "Mohan Menon", "email": "mohan.menon66@example.net", "phone": "+91 74753 73925", "city": "Ranchi", "joined": "2024-12-16", "active": true},
  {"id": 67, "name": "Neha Banerjee", "email": "neha.banerjee67@example.org", "phone": null, "city": "Surat", "joined": "2025-01-11", "active": true},
  {"id": 68, "name": "Asha Singh", "email": "asha.singh68@example.com", "phone": "+91 71072 39875", "city": "Bhopal", "joined": "2025-10-14", "active": true},
  {"id": 69, "name": "Arjun Mishra", "email": "arjun.mishra69@example.org", "phone": "+91 91020 97974", "city": "Raipur", "joined": "2026-06-20", "active": false},
  {"id": 70, "name": "Sana Singh", "email": "sana.singh70@example.net", "phone": "+91 80028 21791", "city": "Srinagar", "joined": "2025-04-18", "active": false},
  {"id": 71, "name": "Divya Iyer", "email": "divya.iyer71@example.com", "phone": "+91 94649 94498", "city": "Ludhiana", "joined": "2024-02-08", "active": true},
  {"id": 72, "name": "Arjun Desai", "email": "arjun.desai72@example.net", "phone": "+91 81665 86066", "city": "Ludhiana", "joined": "2025-01-14", "active": true},
  {"id": 73, "name": "Arjun Chauhan", "email": "arjun.chauhan73@example.org", "phone": "+91 76889 79746", "city": "Kolkata", "joined": "2026-08-01", "active": false},
  {"id": 74, "name": "Ishaan Thomas", "email": "ishaan.thomas74@example.net", "phone": "+91 75961 99213", "city": "Mysuru", "joined": "2024-10-29", "active": true},
  {"id": 75, "name": "Rohan Thomas", "email": "rohan.thomas75@example.com", "phone": "+91 95906 24294", "city": "Surat", "joined": "2024-02-28", "active": true},
  {"id": 76, "name": "Ravi Joshi", "email": "ravi.joshi76@example.com", "phone": "+91 75276 27977", "city": "Raipur", "joined": "2024-07-12", "active": true},
  {"id": 77, "name": "Aditi Jain", "email": "aditi.jain77@example.org", "phone": "+91 77751 69266", "city": "Mumbai", "joined": "2024-06-30", "active": true},
  {"id": 78, "name": "Joseph Khan", "email": "joseph.khan78@example.org", "phone": "+91 99628 52549", "city": "Pune", "joined": "2025-07-23", "active": true},
  {"id": 79, "name": "Joseph Patel", "email": "joseph.patel79@example.org", "phone": "+91 61503 90866", "city": "Surat", "joined": "2024-01-22", "active": true},
  {"id": 80, "name": "Deepak Chauhan", "email": "deepak.chauhan80@example.com", "phone": "+91 60420 98818", "city": "Mumbai", "joined": "2025-01-13", "active": true},
  {"id": 81, "name": "Yash Gupta", "email": "yash.gupta81@example.com", "phone": null, "city": "Visakhapatnam", "joined": "2025-02-17", "active": true},
  {"id": 82, "name": "Rohan Gupta", "email": "rohan.gupta82@example.com", "phone": "+91 96854 13726", "city": "Raipur", "joined": "2026-06-14", "active": true},
  {"id": 83, "name": "Rahul Sharma", "email": "rahul.sharma83@example.net", "phone": "+91 67808 08761", "city": "Panaji", "joined": "2025-02-14", "active": true},
  {"id": 84, "name": "Tanvi Kumar", "email": "tanvi.kumar84@example.org", "phone": "+91 88620 54206", "city": "Bhopal", "joined": "2025-11-29", "active": true},
  {"id": 85, "name": "Farhan Jain", "email": "farhan.jain85@example.com", "phone": "+91 88543 07162", "city": "Kochi", "joined": "2026-05-11", "active": true},
  {"id": 86, "name": "Deepak Sharma", "email": "deepak.sharma86@example.com", "phone": "+91 63285 59123", "city": "Bengaluru", "joined": "2026-03-30", "active": true},
  {"id": 87, "name": "Priya Gill", "email": "priya.gill87@example.org", "phone": "+91 96067 20345", "city": "Pune", "joined": "2026-05-19", "active": true},
  {"id": 88, "name": "Harpreet Iyer", "email": "harpreet.iyer88@example.com", "phone": "+91 68320 88254", "city": "Bhubaneswar", "joined": "2024-03-31", "active": false},
  {"id": 89, "name": "Rahul Yadav", "email": "rahul.yadav89@example.net", "phone": "+91 91502 22898", "city": "Kochi", "joined": "2024-02-22", "active": false},
  {"id": 90, "name": "Kavya Bhat", "email": "kavya.bhat90@example.com", "phone": "+91 69956 97025", "city": "Hyderabad", "joined": "2025-04-09", "active": true},
  {"id": 91, "name": "Suresh Gupta", "email": "suresh.gupta91@example.com", "phone": "+91 99505 70919", "city": "Jaipur", "joined": "2026-07-01", "active": true},
  {"id": 92, "name": "Farhan Menon", "email": "farhan.menon92@example.com", "phone": "+91 80213 40627", "city": "Chennai", "joined": "2026-05-26", "active": false},
  {"id": 93, "name": "Yash Patel", "email": "yash.patel93@example.com", "phone": "+91 87815 29608", "city": "Pune", "joined": "2026-05-28", "active": true},
  {"id": 94, "name": "Ishaan Kumar", "email": "ishaan.kumar94@example.com", "phone": "+91 88678 88461", "city": "Lucknow", "joined": "2025-10-25", "active": true},
  {"id": 95, "name": "Vivek Patel", "email": "vivek.patel95@example.org", "phone": "+91 99355 23939", "city": "Kochi", "joined": "2025-08-12", "active": false},
  {"id": 96, "name": "Anjali Bhat", "email": "anjali.bhat96@example.com", "phone": "+91 80510 48591", "city": "Dehradun", "joined": "2024-04-28", "active": true},
  {"id": 97, "name": "Ananya Agarwal", "email": "ananya.agarwal97@example.org", "phone": "+91 78549 65251", "city": "Thiruvananthapuram", "joined": "2025-08-26", "active": true},
  {"id": 98, "name": "Lakshmi Bhat", "email": "lakshmi.bhat98@example.com", "phone": "+91 63520 32276", "city": "Chandigarh", "joined": "2026-03-21", "active": true},
  {"id": 99, "name": "Kavya Verma", "email": "kavya.verma99@example.net", "phone": "+91 80874 73447", "city": "Guwahati", "joined": "2025-10-22", "active": true},
  {"id": 100, "name": "Divya Kumar", "email": "divya.kumar100@example.com", "phone": "+91 84110 32050", "city": "Dehradun", "joined": "2025-05-02", "active": true}
]

100 rows · 15.9 KB

Open in…

Runs in your browser — nothing you enter leaves this device.

About this tool

What it does

This tool makes rows of made-up data for testing an app, filling a demo, or seeding a database. You list the fields you want — a row number, a name, an email address, a price, a date, one of a list of statuses — and it writes as many rows as you ask for, up to 10,000, as JSON, CSV, SQL INSERT statements or NDJSON (one JSON object per line). Each row hangs together: the email address is made from the name in the same row, and the state matches the city. Everything comes from a seed, so the same fields and seed always give exactly the same rows — handy for a test fixture you want to regenerate later, or for sharing data with a colleague by telling them the seed.

How to use it

Start from one of the presets — Users, Orders or Products — or edit the fields directly.
For each field, set a name and a kind. Some kinds have settings: a range for numbers and dates, decimal places, a list of choices, or the chance of true.
Set “Empty %” on any field that should sometimes be null, to test how your code handles missing values.
Choose how many rows and the format. For SQL, give the table name.
Check the preview, then copy or download the data. Change the seed, or press the refresh button beside it, for a different set.

Limits and your data

Up to 10,000 rows and 30 fields at a time. For more, generate several sets with different seeds.
This is test data, not real data. Email addresses use example.com, example.org and example.net, domains reserved so that no mail to them can reach anyone. Mobile numbers are only shaped like Indian ones (+91, starting 6 to 9) and may belong to a real person, so never send messages or calls to them.
Randomness comes from a seeded generator, not a secure one. Do not use these UUIDs or values as passwords, tokens or anything secret.
Decimals are exact: a price range of 99 to 24999.99 with two places gives values such as 1520.45, never 1520.4500000001. Whole numbers can have up to 15 digits.
SQL uses standard syntax: TRUE and FALSE, and names quoted with double quotes when they contain spaces or symbols. MySQL needs ANSI_QUOTES for quoted names; plain names work everywhere.
Nothing is uploaded: the rows are made in this page, and the fields you set up are not saved anywhere.

Questions

Why do I get the same data every time?

Because the seed is the same. That is deliberate: a test that uses generated data should fail or pass the same way each run. Type a different seed, or press the refresh button beside it, for new rows.

Will changing one field change all the others?

Switching nulls on or off in one field leaves the other fields’ values where they were. Adding, removing or reordering fields, or changing a field’s kind, draws the rows afresh.

How do I load the SQL into my database?

Create the table first, with columns named like your fields, then run the INSERT statements. Rows are grouped 500 to a statement, which every major database accepts. The SQL Playground on this site can run them straight away if you paste a CREATE TABLE before them.

Can I get the data in a different shape, such as nested JSON?

Rows are flat, one value per field, which is what tables and CSV need. For nested JSON, generate the flat rows and reshape them, or describe the shape you want with the JSON Schema Generator.