Test Data Generator
Generate fictional identities in bulk and export to CSV, JSON or SQL. Up to 100,000 records free — for seeding databases, QA, and demos.
Free, up to 100,000 rows. No sign-up.
Fields to include
Preview and download use the same seed. Save it with your file to reproduce the records with this generator version.
Full Name,Sex,Street,City,State Code,ZIP/Postal,Country,Phone,Email,Username,Password,Birthday,Age Janis K. Hoppe,female,8079 Emilie Spurs,Springfield,MA,01103,United States,413-555-0135,jhoppe90@example.org,back1918,xOJLkpFV73,1994-06-01,31 Cornelius J. Goodwin-Wunsch,male,5763 Gilbert Squares,Atlanta,GA,30350,United States,678-555-0132,cgoodwinwunsch57@example.org,Corneliu726,3fwqL2uVfy,1967-07-23,58 Irma M. Wiza,female,8695 W Broad Street,Duluth,MN,55806,United States,218-555-0160,iwiza96@example.org,edible1938,8H7UIcnMEX,1986-02-20,39 Henrietta A. Powlowski,female,950 Center Road,Jackson,MS,39204,United States,769-555-0153,hpowlowski64@example.net,Henriett616,b8fkcQO4aU,1957-08-23,68 Alice A. Turcotte,female,7729 College Avenue,Memphis,TN,38105,United States,901-555-0160,aturcotte90@example.com,AliceTur519,TqaD52gaos,1990-04-30,35
This bulk fake data generator creates many fictional identities at once and exports them to CSV, JSON, or SQL INSERT statements. Pick how many records you need, choose your fields, and download a file you can drop straight into a test database or spreadsheet.
Use the Customers, Users or Addresses template to choose a useful set of columns, then adjust individual fields. The output is generated test data; street details are not verified for delivery and a name can match a real person by chance. Financial fields are format fixtures, so choose a payment processor’s documented test values for payment integration tests.
Each format is shaped for where it usually lands. The CSV export starts with a header row naming your selected fields, so it opens cleanly in a spreadsheet and imports directly with tools like Postgres COPY. The JSON export is a plain array of objects, ready for a fixtures file or an HTTP mock. The SQL export is a set of INSERT statements for a table named identities. Create a compatible test table and check column names and types before importing. In every format, only the fields you selected are included — there are no hidden columns to strip afterwards.
One property of any realistic dataset surprises people at scale: duplicates. Random draws collide far earlier than intuition says — the birthday paradox — and we measured it on this engine: across 2,000 US profiles, the first repeated first name arrived at profile 14 and the first repeated full name at profile 599. That is a feature for most tests, because real customer tables contain people who share a name or a birthday, and code that silently merges them is exactly the bug realistic data catches. Deduplicate only the columns your schema genuinely requires to be unique, like emails or usernames, and let display fields stay realistic.
It is completely free, with no sign-up and no cap behind a paywall — export up to 100,000 records in one file. Generation runs entirely in your browser, so the data never leaves your device.
Need a ready-made customer dataset?
Download sample customer data as CSV or JSON with a field dictionary and preview. Use this generator when you want to choose your own columns, seed or row count.
Frequently asked questions
How many records can I generate?
Up to 100,000 records per export, completely free and with no sign-up. Everything is generated in your browser, so nothing is uploaded or stored.
What export formats are supported?
CSV, JSON, and ready-to-run SQL INSERT statements. You can choose exactly which fields to include in every format.
Is the bulk data safe to use in a test database?
The data is generated for development and QA. National IDs are masked, emails use example domains, and street details are unverified. Generated card numbers are format fixtures, not necessarily a payment processor’s documented test cards. Use a processor’s official fixtures for payment integration tests.
Is the generated dataset reproducible?
Yes. Keep the same seed, fields and generator version to reproduce the records. Preview and download now use that same seed. Age-related fields use a fixed reference date of 1 January 2026. Save the downloaded file as well, since future data or engine updates can change generated output.