Test Data Generator - JSON, CSV, SQL
Build structured test data from field rules and export it as JSON, CSV or SQL INSERT. A fixed seed keeps generated rows reproducible.
Field Rules
Data is generated in your browser with a seeded random generator. Nothing is uploaded.
Generated Data
About This Tool
The test data generator builds rows from field rules instead of hand-writing fixtures. Each rule has a name and a type such as name, email, phone, company, city, address, URL, UUID, auto increment, date range, enum, boolean, integer, decimal or template, and dotted names like user.city produce nested objects.
Output can be JSON for frontend mocks, CSV for spreadsheet-style imports, or SQL INSERT statements for database seeding. A fixed seed keeps every run identical, so the same fixture can be committed to a repository and reused across test runs.
Key Features
Sixteen field types
Cover the values that appear most in test fixtures, from contact details to sequences and dates.
Nested output
Use dotted field names to produce nested objects without writing a schema by hand.
Three export formats
JSON, CSV and SQL INSERT with identifier quoting and value escaping.
Reproducible seed
The same seed and rules always generate the same rows.
When to Use It
Frontend mocking
Produce list responses for tables and detail pages before the API is ready.
Database seeding
Generate SQL INSERT statements to populate a local or test database.
Load test input
Create CSV batches with realistic names, phones and identifiers.
How to Use It
- 1Add field rules and pick a type for each one.
- 2Fill type-specific options such as enum values or numeric ranges.
- 3Set row count, seed and export format.
- 4Generate, then copy or download the result.
Frequently Asked Questions
Is the generated data realistic?
Values follow common formats such as email addresses, phone numbers and UUIDs, but they are synthetic and do not describe real people.
Why do two runs match exactly?
Generation uses a seeded pseudo-random generator. Change the seed if you need a different data set.
