Fake Data Generator
Build realistic test data in seconds — pick fields like name, email, phone, UUID, date, address and price, choose how many rows, and export as JSON, CSV or SQL INSERT statements. Everything is generated locally in your browser.
About this tool
The Fake Data Generator builds realistic mock records so you can populate a database, test an API, or fill a UI without touching real customer information. Pick the fields you need — names, emails, phone numbers, UUIDs, dates, addresses, prices, IP addresses and more — decide how many rows you want, and export the result as JSON, CSV, or ready-to-run SQL INSERT statements.
It is built for developers who need believable data now: the generator mixes Vietnamese and international names, real-looking companies and job titles, and correctly formatted values, all assembled in your browser. Because it produces fictional data, it is a safe alternative to copying production data into a test environment.
How to use
- Add the fields you want in your dataset and name each column key.
- Assign a data type to every field — for example email, fullName, uuid, price, or ipv4.
- Set the number of rows to generate.
- Choose an output format: JSON, CSV, or SQL INSERT statements.
- If you pick SQL, enter the target table name so the INSERTs are ready to paste.
- Generate, then copy or download the output for your seed script or test suite.
Features
- Over twenty field types including id, uuid, names, email, username, phone, age, dates, boolean, city, country, company, job title, street, price, color, and IPv4.
- Three export formats — JSON for APIs, CSV for spreadsheets and imports, and SQL INSERT statements for database seeding.
- Custom column keys and a configurable table name so the SQL output matches your schema.
- Proper escaping in every format: quoted CSV cells and single-quote-escaped SQL string literals.
- Generates up to a thousand rows per run, enough to stress-test pagination and queries.
- Runs completely client-side, so no real data ever leaves your machine and nothing is uploaded.
Frequently asked questions
Is the generated data real or does it belong to anyone?
It is entirely fictional. Names, emails, and other values are assembled at random from built-in word lists and are not linked to real people, so you can share and commit it safely.
Does the tool send my configuration or output to a server?
No. Every row is generated locally in your browser. Nothing about your fields, counts, or generated records is uploaded, which is exactly why it is a safe stand-in for real production data.
Can I use the SQL output directly in my database?
Yes. Choose the SQL format and set your table name, and the tool emits INSERT INTO statements with proper value escaping. Review the column keys to match your schema before running them.
Which format should I pick — JSON, CSV, or SQL?
Use JSON to mock API responses or seed NoSQL stores, CSV to import into spreadsheets or bulk-load tools, and SQL when you want to seed a relational database table directly.
How many rows can I generate at once?
You can generate up to one thousand rows in a single run, which is usually plenty for local development, demos, and load-testing lists.