Fake Data Generator
Make test data from fields you choose or a JSON Schema, as JSON, CSV or SQL INSERT, repeatable with a seed.
All of the data is invented. Names, emails, phone numbers and addresses are random and could by chance match real ones, so use them only for testing and never to contact anyone. Nothing leaves your browser.
Runs in your browser. Nothing is uploaded.
What is Fake Data Generator?
Fake data, also called test data or mock data, is made-up information that looks real: names, emails, addresses, dates, prices and IDs. Developers use it to fill a database before the real records exist, to test a form or a report with many rows, to build a demo, and to give a front-end something to display while the back end is still being written. Using invented data instead of real customer records also keeps personal information out of test systems.
This fake data generator works two ways. Build your own table by adding fields and choosing a type for each: people (names, emails, phone numbers, birth dates, job titles), places and companies (addresses, cities, countries, postcodes, websites), numbers and IDs (row numbers, UUIDs, ranges, prices, dates, true or false) and text (sentences, paragraphs, colors, or a list of choices you type). Or paste a JSON Schema and get sample objects that follow it, with text properties named like email, firstName or city filled with realistic values. Presets for users, products and orders get you started in one click.
Get the result as JSON, JSON Lines, CSV or SQL INSERT statements for PostgreSQL, MySQL or SQLite. Every dataset is repeatable: the same fields, number of rows and seed always give exactly the same data, so a test can be run again with the same input, and Shuffle makes a new set. The data generator is downloaded only when you click Generate, so the page stays light until you use it, and everything is made in your browser. All data is invented, but it is random, so a name, email or phone number can by chance match a real one. Use it only for testing.
How to use
- Choose Build fields or From a JSON Schema, or start from the Users, Products or Orders preset.
- Add, rename, reorder or remove fields, and set a range or a list of choices where a type needs one.
- Set the number of rows (up to 1,000) and, if you want, a seed. Pick JSON, JSON Lines, CSV or SQL.
- Click Generate. The first time, the generator is downloaded; after that the data updates as you change anything.
- Click Copy result or Download, and use Shuffle for a different set of data.
Example
Input
Users preset, 3 rows, seed 1, format CSV
Output
id,first_name,last_name,email,phone,birth_date,city,country,active 1,…,…,…,…,1986-09-27,…,…,true
Frequently asked questions
- Is the data real?
- No, it is all invented. It is random, though, so an email address, phone number or name can happen to match a real one. Use it for testing only and never to contact anyone.
- What does the seed do?
- The seed starts the random generator at a fixed point, so the same seed with the same settings gives the same data every time. Change the seed, or click Shuffle, for different data. If the generator library is updated, the data for a given seed may change.
- Which parts of JSON Schema work?
- Types, properties, arrays, enum, const, string lengths and formats such as email, uuid and date-time, number bounds and multipleOf, array sizes and unique items. Keywords like $ref, anyOf, allOf and pattern are not followed, and the page lists any it finds in your schema.
- Can I import the SQL into my database?
- Yes. Choose PostgreSQL, MySQL or SQLite so that names and values are quoted correctly, and create the table first with matching columns. The tool writes the INSERT statements, not the CREATE TABLE.
Related tools
- SQL FormatterFormat and minify SQL for PostgreSQL, MySQL, SQLite, SQL Server, Oracle, BigQuery and Snowflake.
- CSV to JSON & JSON to CSVConvert CSV to JSON and JSON to CSV with delimiter detection and nested JSON flattening.
- JSON to TypeScriptTurn JSON into TypeScript interfaces or types, merging array items and marking missing fields optional.
- UUID GeneratorGenerate UUID v4 and v7 in bulk, and validate any UUID.
- Lorem Ipsum GeneratorGenerate lorem ipsum placeholder text by paragraphs, sentences, words or characters.
- JSON Formatter & ValidatorFormat, minify and validate JSON online with line-accurate error messages.