1. Home
  2. Developer
  3. Mock Data Generator

Mock Data Generator

Fake names, addresses, phones and emails as JSON, CSV or SQL INSERT.

Runs in your browser · No upload
1 to 1,000 rows
The same seed always gives the same data, handy for test fixtures. Leave empty for fresh data each time.
Columns
0 row(s)
Everything is randomly invented. Emails use reserved domains (example.com and similar) so they go nowhere, but phone numbers and addresses may coincide with real ones by chance, so never actually call or text during testing.

Data is created only in your browser and never sent to a server.

How to use

  1. Choose the data language (Korean or English) and enter the number of rows (1 to 1,000). Five rows are already made when the page opens.
  2. In Columns, tick only what you need. There are 20 to choose from, such as name, email, phone, address and company.
  3. Pick the output format: JSON, CSV or SQL INSERT. For SQL you also set the table name, the dialect (standard/PostgreSQL or MySQL) and how rows are grouped.
  4. Copy the result or Download file. Generate new replaces every value.

Available columns

Column Content Form
id A sequence from 1 number
uuid A random UUID v4 36 characters
name, username, email Linked to the name (its romanization feeds the username and email) ayeon.kwon95@example.com
phone Korea 010-XXXX-XXXX, English 555-01XX string
postal, address A 5-digit postal code and a street-style address string
company, job A company name and job title string
birthdate, age A birth date and the matching age (19 to 65) date, number
gender M or F (matches the name’s gender) character
amount Korean data in units of 100, English data down to cents number
active true 80% of the time, false 20% boolean
createdAt A random time within the last year (UTC) 2026-03-02 14:05:09
ip, url, color, text A documentation IP range, a reserved-domain URL, a color code, a one-line review string

Emails use only example.com, example.org and example.net. These three domains are reserved for documentation and testing, so no real mail goes out. IPs come from the blocks set aside for documentation: 192.0.2.x, 198.51.100.x and 203.0.113.x. English phone numbers are 555-0100 to 555-0199, which US numbering keeps free for fictional use.

Reproducing the same data with a seed

Put any string in the seed box and the same data comes out every time. Use it so expected values in automated tests do not drift. With seed demo, Korean data, 3 rows and the columns id, name, email, phone:

id,name,email,phone
1,권아연,ayeon.kwon95@example.com,010-7606-2481
2,장우찬,woochan.jang24@example.net,010-4091-1189
3,송아빈,abin.song91@example.com,010-5057-4202

Choosing SQL INSERT with the same settings gives:

INSERT INTO "users" ("id", "name", "email", "phone") VALUES
  (1, '권아연', 'ayeon.kwon95@example.com', '010-7606-2481'),
  (2, '장우찬', 'woochan.jang24@example.net', '010-4091-1189'),
  (3, '송아빈', 'abin.song91@example.com', '010-5057-4202');

The seed is for reproducibility, not security. With the seed empty, values are drawn without bias from the browser’s cryptographic random source (crypto.getRandomValues). Changing the columns does not alter the remaining column values for the same seed.

Output format rules

  • JSON: an array of objects in the column order shown above. Numbers and booleans are written without quotes.
  • CSV: the first line holds the column names. Values containing commas, double quotes or newlines are wrapped in double quotes following RFC 4180.
  • SQL INSERT: single quotes inside strings are doubled. The MySQL dialect uses backticks for column names and doubles backslashes, and the standard/PostgreSQL dialect uses double-quoted identifiers. The table name accepts only letters, digits and underscores.

FAQ

Can a generated name or phone number match a real person?

Everything is a random combination, so a coincidence is possible. Phone numbers and addresses in particular may exist, so never call, text or post anything during testing. Emails use reserved domains and are never delivered.

Can it stand in for real personal data?

It suits testing, demos and screen layouts. These are newly invented values, not masked real records, so they do not reproduce the statistical shape of production data.

How many rows at a time?

Up to 1,000. For more, generate again and join the downloads.

What if the generated SQL fails to run?

Column names go in exactly as this tool names them. If the target table differs, pick matching columns or edit the output. active is written as TRUE/FALSE, which a database without boolean literals may need as 1/0. To tidy the result, use the SQL Formatter.

Can I get just names?

Tick only the name column. For a quick list of names, the Name Generator is more convenient.

Data is created only in your browser and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.