Generate the same synthetic table from a seed
Admin ·
Use a small synthetic table to reproduce an import test without relying on a production export. A seed repeats the same draws while the column settings control which values your importer sees.
Build the three-row table with seed 42
Select Load example and Generate table. The example uses seed 42 and four columns. It draws a six-digit text ID, an integer from 1 to 9, a boolean and a text note for each row.
The first row has ID 037913, quantity 5, active false and note Birch. Select Generate table again with the same settings and compare the rows. The values and their order stay the same.
id,quantity,active,note
037913,5,false,Birch
097291,8,true,Dune
060434,3,true,Cedar
RFC 4180, common CSV field rulesRFC 8259, JSON values and data types
Verify a padded identifier in the JSON export
Choose JSON under Export format without drawing new rows. The first ID is the string "037913", quantity is the number 5 and active is the boolean false. Download random-data-table.json and compare that record with the preview.
Choose CSV and download random-data-table.csv for a CSV importer. Set the ID column to text if the importer would drop the leading zero. The CSV format stores field text. A Null column produces empty CSV fields and actual null values in JSON.
RFC 4180, common CSV field rulesRFC 8259, JSON values and data types
Change the seed and keep the fields
Change Seed to 43 and generate again. The first row now has ID 098643, quantity 6, active true and note Dune. Change the seed back to 42 to restore the first dataset.
For a column that must stay in an allowed range, enter minimum and maximum bounds before generating. Preserve the seed and the rest of the settings with the test so someone else can replay it.
Common questions
What happens if I add another column to a seeded table?
A column can consume extra draws, so later cells can change. Save the complete column order and settings with the seed.
Do date fields become JSON date objects?
The date field produces a YYYY-MM-DD string. Decode it as a date in your test harness only when its schema calls for one.
Sources
Put it into practice.
- Random Data Table Generator
- Random Data Table Generator
- Data Type Guesser
- CSV Viewer and HTML Table Exporter