Mock Data Generator

Build a schema, generate synthetic rows, and download CSV, TSV, JSON, NDJSON, SQL, XML, HTML or Excel. Generate up to 100,000 rows in memory, or 5 million with supported streaming formats and browsers. No sign-up is required.

Start from a preset

Or build your own schema below

Columns

Preview

First 25 rows

What This Mock Data Generator Does Differently

Most "random data" sites hand you a column of unrelated values: a first name from one row, an email belonging to somebody else, a postcode from a different country entirely. That is fine until you actually load the file into a staging database and your joins, validators and display logic start behaving in ways real data never would. This generator builds a coherent identity for every row first — person, address, employer — and then fills your columns from it. The email is derived from the name in the same row. The postal code format matches the selected country. Rearranging your columns does not break any of it.

Reproducible output is the headline feature

A seed repeats the pseudo-random sequence for the same schema and settings. Reproducing a file also requires the same date anchor, export format, and generator version; a seed alone is not a cross-browser, all-format byte-identity guarantee. Keep the schema and pinned share link with a fixture, and verify the resulting file when exact bytes matter.

Date-derived fields also depend on a time anchor. Without a restored anchor, a seeded run uses midnight UTC of the current day, so output can change on another day. Copy share link pins that anchor. Explicit date bounds stabilize those fields, but do not fix unrelated format metadata or future implementation changes.

Everything runs in your browser

No account or API key is required. Row generation is local, and CSV, JSON and SQL can work after the required page code has loaded. The first XLSX export requires a network connection to load JSZip from a CDN unless it is already cached; shared page features may also use the network. A share link contains the schema and settings, so avoid real personal information or confidential schema details.

Field types available

Output formats and what they are good for

What people use generated datasets for

The presets above exist because the same handful of jobs keep coming up. All of them need plausible rows; if what you actually need is a file of a particular size, use the Sample File Generator instead.

Why generated CSVs are a security problem (and how this one is not)

Spreadsheet software treats any cell beginning with =, +, - or @ as a formula. A CSV containing =cmd|'/c calc'!A1 can therefore trigger a command prompt when somebody opens it in Excel — the well-documented CSV injection class of attack. Test data ends up in exactly the places where this bites: shared with QA, attached to tickets, imported into admin dashboards. This tool prefixes any such cell with an apostrophe by default, which forces the value to be treated as text and renders it inert. You can disable the guard with the checkbox above when you specifically want to test how your own importer handles those characters.

Generating very large datasets

Up to 100,000 rows the file is assembled in memory and handed to the browser as a normal download. Beyond that, tick Stream straight to disk: the generator writes CSV, TSV, JSON or NDJSON in chunks through the File System Access API and never holds the full dataset in RAM, which is what makes multi-million-row files possible in a tab. Streaming needs a Chromium browser (Chrome, Edge, Opera, Brave or Arc); Safari and Firefox have not shipped the API, and fall back to the in-memory limit.

Limitations worth knowing

Privacy

Rows are generated locally. Share links encode the schema and options in the URL, so review column names, fixed values, and other supplied content before sharing. Synthetic generation does not automatically remove privacy-law obligations, especially if options contain real personal data.

Frequently Asked Questions

No account, no email, no API key. You can generate 100,000 rows in memory or up to 5 million rows with streaming enabled, as often as you like. The limits are what a browser tab can physically handle, not a paywall.
Yes — that is what the Orders and Employees presets are shaped for. Pick one, set a row count, choose Excel (XLSX) and download. You get a real spreadsheet with a frozen header row and genuine numeric cells, so pivot tables, SUM and Power Query work straight away. For a Power BI report, 10,000 order rows is usually enough to exercise slicers and a date hierarchy. Above roughly 50,000 rows, switch to CSV and let Excel or Power BI import it — building that much spreadsheet XML in a browser tab gets slow.
A seed repeats the pseudo-random sequence with the same schema, settings, and time anchor. Seeded runs without a restored anchor use midnight UTC of the current day; a share link pins the anchor. Keep the format and generator version fixed and compare the output if byte identity matters. Leave the seed blank for new randomized rows.
Yes. Each row starts life as one coherent identity — a person, an address and an employer — and every column you add reads from it. So the email is built from that row's first and last name, the postcode matches the selected country's format, and the city sits in the state shown beside it. This holds no matter what order you arrange the columns in.
Generation, preview and file creation run locally. XLSX export loads JSZip when needed, and shared page features may make network requests. Share links include your schema and options; anyone receiving one can inspect them. Local generation does not make confidential inputs safe to share.
Yes. Pick your dialect (MySQL, PostgreSQL, SQLite or SQL Server) and the output uses the right identifier quoting — backticks, double quotes or brackets — with string literals escaped correctly, including backslashes for MySQL. You get a CREATE TABLE with a sensible type per column followed by batched multi-row INSERT statements. Turn the CREATE TABLE off if the table already exists.
No. They are synthetic numbers built with a correct Luhn check digit, which is what payment forms and validation libraries check first — so they let you exercise your validation path. They are not issued to anyone, carry no funds, and will always be declined by a real payment processor.
That is the CSV injection guard. Excel and other spreadsheet apps execute any cell starting with =, +, - or @ as a formula, so a leading apostrophe forces it to be read as plain text instead. Uncheck the guard if you are deliberately testing how your own importer handles those characters.
Use Copy share link to encode the schema and supported options in a URL. Anyone with the link may inspect those values. A seed helps repeat randomized fields, but timestamps, format metadata, and implementation changes can prevent byte-identical downloads.
Yes. It is a genuine Open XML workbook with a bold frozen header row, auto-sized columns, and numeric columns written as real numbers rather than text — so SUM and sorting work immediately with no "convert to number" prompt. It opens in Excel, LibreOffice, Google Sheets and Numbers, and is validated in testing against strict OOXML parsers.
That is a different job — use the Sample File Generator, which produces a file of an exact byte size in 25 formats. Use this tool when you need structured rows with realistic values; use that one when you need a file of exactly 100 MB to test an upload limit.