How to use
- 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.
- In Columns, tick only what you need. There are 20 to choose from, such as name, email, phone, address and company.
- 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.
- 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.
Related tools
- Check the JSON with the JSON Formatter, and convert between JSON and CSV with the JSON and CSV Converter.
- For IDs alone use the UUID Generator, and for account handles the Username Generator.
- For filler body text use the Lorem Ipsum Generator.
Data is created only in your browser and never sent to a server.