How to use Synthetic Test Dataset Generator
- Enter one to 10,000 rows and keep the seed if you need to reproduce a result.
- Add or edit sample columns in the controls or JSON. Choose supported IDs, labels, numbers, dates, categories, booleans or explicitly fake contact/company fields.
- Set bounds or category values for the selected types and enter a valid SQL table name.
- Generate the rows, inspect a few records and download the CSV, JSON, SQL or XLSX file you need. All four formats are produced together.
Example: Synthetic Test Dataset Generator
Generate repeatable sample data in four export formats.
Supported inputs and limits
- 1–10,000 rows and 1–20 columns; combined exports up to 8 MiB.
- Every value is explicitly synthetic.
- Contact/address/company shapes are examples, without locale, demographic, reachability or uniqueness guarantees.
- Dates range from 1900 to 2100.
- Same schema, seed and row count repeat the same values.
More details
SQL targets SQLite syntax and is generated only.
Editable category lists use commas; advanced JSON supports other category text.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Use a fixture that answers your test question
Keep the schema, seed and row count with a test case so an import or formatting problem can be reproduced. The generator is for artificial fixtures; it does not reproduce a population, realistic distributions or valid reachable contacts. Review the downloaded data and keep it labelled synthetic. The SQL file uses SQLite syntax and is not executed by this page.
Questions about Synthetic Test Dataset Generator
Are the generated identities real?
No. Labels are explicitly synthetic and do not describe real people.
Can I reproduce a fixture?
Yes. Keep the same supported schema, row count and seed.
Will SQL be applied to a database?
No. It is exported as text for your review.