About
Last updated 20 November 2026
Mock data is easy to make and hard to keep. The rows you generated last week are gone, the test that used them fails for a reason nobody can read, and the screenshot of the failing row is all that is left. This page treats a data set as a file with a recipe: columns, a row count, and one number that fixes every value.
What it does
- The columns. Each row of the builder is one column: a name, a type, the options that type takes, and a share of cells to leave empty. Columns can be added, renamed, retyped, moved up and down, or removed, and the table is rewritten as you go.
- The seed. A single number starts the pseudo random stream that every value comes from. Type another number and the whole table changes. Type the first one back and it returns, cell for cell.
- The writers. The same rows leave as a JSON array, NDJSON, CSV with a header row, SQL
INSERT INTOstatements for a table name you set, or a TypeScript type with an exported constant. Each can be copied or downloaded. - The fingerprint. Eight characters computed from the file itself, printed beside the row count. It is the cheapest way to say two runs produced the same data.
How the stream works
The generator is mulberry32: a 32 bit state, one multiply and a couple of shifts per draw. It is small enough to read in a minute and identical in every browser, which matters more here than statistical quality: a generator whose output changes between engines would break the promise of a fixed seed.
Cells are filled left to right and row by row. Each cell takes as many draws as its type needs and keeps the result. The null decision is a draw of its own, taken after the value, so a cell that becomes null still moves the stream exactly as far as one that does not. That single rule is what makes the null share safe to change without renumbering every row after it.
The order is visible in the output: change a column type in the middle and the rows after that point differ, while the rows before it stay. Add a column at the end and nothing earlier moves. This is not a defect to hide; it is the mechanism, and knowing it is how you keep a fixture stable when a schema grows.
Where the values come from
Every list is written for this page, and every range is one the standards set aside for examples. Nothing is read from a database, an account, or another tool.
- Names, companies, jobs, countries and cities are short generic lists, kept small on purpose so a demo does not look like it describes a particular market.
- Email is always at example.com, example.org or example.net. No real provider domain is used anywhere.
- Phone numbers come from the 555-0100 to 555-0199 band that the North American numbering plan keeps for fiction, the 020 7946 0xxx band kept by Ofcom, or the 010-0000-XXXX shape, which is in the range Korean carriers do not assign.
- IPv4 addresses come from 192.0.2.0/24, 198.51.100.0/24 and 203.0.113.0/24, the three blocks RFC 5737 reserves for documentation.
- Card numbers are generated on published test BINs and end in a check digit computed with the Luhn algorithm, so a form accepts them and no bank issued them.
- Text is the lorem ipsum word list, and colours are six random hex digits.
What it deliberately does not do
- It does not generate values that imitate a real person, a real company or a real address. There is no locale pack to download and no name database behind it.
- It does not connect to a database, an API or your repository. The content policy sets
connect-src 'none', so the page has nothing that could send the output anywhere. - It does not model relations between columns. An order's total is not the sum of its lines, and a foreign key is not matched to a parent row. What it generates is a table with the right shapes, not a schema with constraints.
- It does not promise that a card number, an IP address or an email is reachable, unique or valid beyond the check the format defines.
Why it is free
The whole generator is a static page: no server, no account, no database, nothing to meter, and no request after the first load. It sits with the other Pikkola tools, each of which does one small job in the browser. There is no advertising or tracking on the page, and no plan to put the export behind a paid tier.
Contact
Write to hello@pikkola.com. A seed, a column list and the fingerprint that came out of it is the most useful bug report you can send.