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

Start

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

  1. 1Add field rules and pick a type for each one.
  2. 2Fill type-specific options such as enum values or numeric ranges.
  3. 3Set row count, seed and export format.
  4. 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.

CodeSwordsman

100+ technical tools with browser-local processing — your data never leaves your device. Official Microsoft Store desktop apps: free, ad-free, offline.

Completely Free

© 2026 CodeSwordsman All Rights Reserved

Service Terms | Privacy Policy | Help | Version Updates | About Us

This website uses cookies to ensure you get the best experience on our website. Privacy Policy.