TestingAPIs is still being built. If something breaks, email support@testingapis.com.

Mock data generator

Runs in your browser; nothing is uploaded

Build a list of fields and generate fake records as JSON, CSV or SQL. The same seed always gives the same data.

Fields

6 fields
1
[
2
{
3
"id": 1,
4
"name": "Zara Fischer",
5
"email": "zara.fischer57@example.org",
6
"city": "Denver",
7
"active": false,
8
"createdAt": "2022-01-13T07:04:00Z"
9
},
10
{
11
"id": 2,
12
"name": "Leila Santos",
13
"email": "leila.santos@example.org",
14
"city": "Berlin",
15
"active": true,
16
"createdAt": "2023-04-02T18:08:10Z"
17
},
18
{
19
"id": 3,
20
"name": "Aiko Nakamura",
21
"email": "aiko.nakamura@example.com",
22
"city": "Leeds",
23
"active": true,
24
"createdAt": "2024-07-13T06:42:07Z"
25
},
26
{
27
"id": 4,
28
"name": "Arjun Novak",
29
"email": "arjun.novak@example.com",
30
"city": "Pune",
31
"active": true,
32
"createdAt": "2022-05-20T14:47:59Z"
33
},
34
{
35
"id": 5,
36
"name": "Rosa Novak",
37
"email": "rosa.novak21@example.com",
38
"city": "São Paulo",
39
"active": true,
40
"createdAt": "2020-07-11T09:01:20Z"
41
},
42
{
43
"id": 6,
44
"name": "Lucia Rossi",
45
"email": "lucia.rossi@example.com",
46
"city": "Lagos",
47
"active": true,
48
"createdAt": "2022-09-30T16:19:48Z"
49
},
50
{
51
"id": 7,
52
"name": "Sami Torres",
53
"email": "sami.torres@example.net",
54
"city": "Toronto",
55
"active": true,
56
"createdAt": "2026-08-16T23:43:18Z"
57
},
58
{
59
"id": 8,
60
"name": "Tariq Mensah",
61
"email": "tariq.mensah50@example.org",
62
"city": "Perth",
63
"active": false,
64
"createdAt": "2023-09-16T18:56:51Z"
65
},
66
{
67
"id": 9,
68
"name": "Sofia Costa",
69
"email": "sofia.costa35@example.org",
70
"city": "Lagos",
71
"active": true,
72
"createdAt": "2023-05-19T14:12:24Z"
73
},
74
{
75
"id": 10,
76
"name": "Amara Wilson",
77
"email": "amara.wilson76@example.org",
78
"city": "Lyon",
79
"active": true,
80
"createdAt": "2025-06-12T23:59:58Z"
81
}
82
]
10 rows · 6 fields
1.7 KB

What is mock data?

Mock data is realistic-looking but made-up data that you use in place of real records while building and testing software. Instead of copying customer data from production, which is risky and often illegal under privacy laws, you generate names, emails and addresses that have the right shape but belong to nobody.

Frontend developers need something to render before the backend exists. Testers need many varied records to check lists, search, sorting and pagination. API tests need request bodies, and databases need seed rows. Demos look more convincing with plausible names than with test1, test2 and test3.

Data from this tool is generated from a seed: the same fields, row count and seed always give the same records. Put the seed in a test fixture and everyone on the team gets identical data; change the seed to get a new set.

How to use this tool

  1. 1Build the field list on the left: a name and a type for each field, and options such as a number range, a date range or a list of values. Presets fill in common shapes such as users, products, orders and access logs.
  2. 2Set the number of rows (up to 10,000) and a seed. New seed (Ctrl+Enter) picks a random one.
  3. 3Choose the output: JSON (pretty or minified), JSON Lines, CSV with a comma, semicolon or tab, or SQL INSERT statements for PostgreSQL and SQLite or for MySQL.
  4. 4Check the records in the Table tab, then copy them or download a file (Ctrl+S).

Troubleshooting

Two fields are named the same
Every field name becomes a JSON key or a column, so names must be unique. Rename one of them.
The data changed after a reload
The seed changed. Note the seed shown in the status bar, or set your own, to get the same rows again.
MySQL rejects the SQL
Pick the MySQL dialect: it quotes names with backticks and doubles backslashes in strings, as MySQL expects by default. The other dialect uses standard double-quoted names.
Excel puts every CSV value in one column
Excel in many European locales expects semicolons. Choose the semicolon delimiter, or import the file with Data › From Text and pick the delimiter there.

Frequently asked questions

Is the data generated on a server?

No. Records are generated in your browser. The field list and output settings are saved in this browser so they are there next time.

Can the generated people or numbers be real?

Names are random combinations of first and last names. Emails use example.com, example.org and example.net, which are reserved for documentation and never deliver mail. Phone numbers use 555-0100 to 555-0199, the range set aside for fiction in North America, and IP addresses come from the ranges reserved for documentation (192.0.2.0/24, 198.51.100.0/24, 203.0.113.0/24 and 2001:db8::/32).

Are values unique?

Sequential IDs and UUIDs are. Other values are drawn at random, so names and emails can repeat in large sets; add an ID field when you need a unique key.

Can I use the seed in my own tests?

The seed reproduces data in this tool only. To get the same records in a test suite, download them once and commit the file as a fixture.

Related