# Mock Data Generator — JSON, CSV, SQL & More

> Generate realistic fake test data in 14 formats from 100+ field types, with reproducible seeds.

To generate mock data, pick a ready-made schema such as users, orders or products — or define your own columns from over 100 field types — then choose how many rows and which format. Output is available as JSON, CSV, SQL, XML, YAML, TypeScript and more, generated entirely in your browser.

**URL:** https://convertto.tech/t/mock-data-generator
**Category:** Samples & Mock Data (https://convertto.tech/c/sample-data)
**Privacy:** Runs entirely in the browser; no upload
**Cost:** Free, no sign-up
**Last updated:** 2026-08-01

## Key facts

- **Field types:** 97 across identity, contact, location, commerce, finance, dates, text and tech
- **Output formats:** 14 — JSON, NDJSON, CSV, TSV, XML, YAML, SQL, Markdown, HTML, TypeScript, JavaScript and Python
- **Maximum rows:** 5,000 per run
- **Reproducible:** Seeded — the same seed always returns the same dataset
- **Privacy:** Runs entirely in your browser — nothing is uploaded
- **Cost:** Free, unlimited, no sign-up

## How to use

1. Choose the data shape.
2. Add each custom fields as a key and value pair.
3. Set the number of rows.
4. Choose the output format.
5. Choose the locale.
6. Enter or paste your table / root name.
7. Enter or paste your seed.
8. Set the empty / null values.
9. Set the first sequential id.
10. Enter or paste your wrap array in a key.
11. The result appears immediately — copy or download it.

## FAQ

### Is the generated data reproducible?

Yes. Every run is driven by a seed, so the same seed and settings always produce identical rows. Because the seed is part of the shareable link, a colleague opening your link sees exactly the same dataset.

### Are the rows internally consistent?

Yes. Each record is built as one coherent person: the email matches the name, the postcode matches the country, and an "updated" date is never earlier than the matching "created" date.

### Can I use this data in production?

No. It is synthetic test data. Card numbers and IBANs are structurally valid but deliberately non-functional, and names and addresses are randomly assembled rather than real.

### How many rows can I generate?

Up to 5,000 per run. Generation happens in your browser, so the practical limit is your device memory rather than a server quota.

## Related tools

- [Data Format Converter](https://convertto.tech/t/data-format-converter): Convert between JSON, YAML, XML, CSV, TSV and TOML in any direction, locally in your browser.
- [Sample Dataset Generator](https://convertto.tech/t/sample-dataset-generator): Download ready-made sample datasets — users, orders, products, transactions — as CSV, JSON, SQL or Excel-ready TSV.
- [Wrap Lines in Quotes or Brackets](https://convertto.tech/t/line-wrapper): Add a prefix and suffix to every line and join them — build SQL IN lists, arrays and CSV rows.
- [Sample File Generator](https://convertto.tech/t/sample-file-generator): Create valid test files of an exact size in 22 formats — text, data, code, images, audio, PDF and ZIP.
- [CSV Column Extractor](https://convertto.tech/t/csv-column-extractor): Pull selected columns out of a CSV by name or position, and reorder them.
- [Sample JSON Generator](https://convertto.tech/t/sample-json-generator): Turn a JSON Schema into realistic sample documents, respecting types, enums, formats and constraints.
- [INI & Config File Parser](https://convertto.tech/t/ini-parser): Parse INI, .conf, .cfg and .properties files into structured JSON, YAML or TOML.
- [JSON to TypeScript Converter](https://convertto.tech/t/json-to-typescript): Generate TypeScript interfaces, Zod schemas, Go structs, Python dataclasses or Rust structs from JSON.
- [Random Person Generator](https://convertto.tech/t/sample-person-generator): Generate complete fake personas — name, email, address, phone, job, company, bio and avatar.