Synthetic Test Dataset Generator

Build repeatable sample columns for test names, contacts, dates and numbers, with CSV, JSON, SQL and XLSX exports.

On-device No sign-up Free to use

Generate test data controls

More options

Processed in your browser. Your inputs stay on this device.

Showing an example. Change the fields, then use generate test data to update it.

Result

Showing an example.

Generate repeatable sample data in four export formats.

Generated 100 explicitly synthetic rows with seed 42.

Loading the tool. Your result will appear here.

https://usefreetools.net/synthetic-test-dataset-generator · 20 November 2026

Was this helpful?

How to use Synthetic Test Dataset Generator

  1. Enter one to 10,000 rows and keep the seed if you need to reproduce a result.
  2. Add or edit sample columns in the controls or JSON. Choose supported IDs, labels, numbers, dates, categories, booleans or explicitly fake contact/company fields.
  3. Set bounds or category values for the selected types and enter a valid SQL table name.
  4. 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.

You add
Rows: 100; Repeatable seed: 42; Sample columns (JSON): [{"name":"sample_id","type":"id"},{"name":"label","type":"label"},{"name":"amount","type":"decimal","min":0,"max":100,"precision":2},{"name":"category","type":"category","values":["Sample A","Sample B","Sample C"]},{"name":"date","type":"date","start":"2026-01-01","end":"2026-12-31"}]; SQL table name: synthetic_samples
You get
Generated 100 explicitly synthetic rows with seed 42.

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.

Page updated · Project managed by Tony Hines · Report a problem with Synthetic Test Dataset Generator