Generate realistic test data

Believable rows. A repeatable setup. Ready for your next project.

Free up to 1,000 rows No account needed 250,000 rows with a Data Pass

Everything is generated on your device.

Make as

customers-2026-11-21.csv 1,000 rows Up to 1,000 rows free Get a Data Pass

Each customer has

Your next dataset

Customers

Loading the source lists…

Columns

Where the values come from

Public reference lists supply the ingredients. The people and companies are invented combinations; the products come from MySafeInfo’s invented Sample store.

Make a dataset that holds together

Say what you need in one sentence. The first ten rows show how your download begins, and related columns agree: names build emails, Census ZIP records supply cities and states, and occupations supply salaries. Street addresses are invented. Select a value to see how it was made.

Three starting points for your next project

Customers for a demo

Input

Customers · seed 42 · 1,000 rows

Result

CustomerID, FirstName, LastName, Email, Phone, Street, City, State, ZIP, SignupDate

Keep the ready-made columns, or add Birth date with a chip. Shuffle chooses another seed. Reserved email domains and fictional phone numbers keep your demo from contacting anyone.

An employee reporting table

Input

Employees · SQL Server · 1,000 rows

Result

CREATE TABLE employees …
INSERT INTO employees …

Job titles follow employment weights, occupation groups agree with the job, and salaries use the published median. The script includes the table definition and batched INSERT statements.

An online store whose records agree

Input

Online store · Excel or SQL · seed 42

Result

CUST-00001 Christopher Hunt
5 orders · $456.74 spent

ORD-00002 · 2 lines · $119.94
Redfern V-Neck T-Shirt     $21.95
Halcyon & Co. Rain Jacket  $97.99

Matching customer IDs, product references and totals across four tables. Open the workbook or choose SQL to inspect the relationships.

Download workbook Download SQL Open this setup

From starting point to usable file

  1. Say what you need: how many rows, what to make, any related tables and the format.
  2. Choose what each row has with the column chips, or select Customize columns to rename, reorder and fine-tune every field. Import columns builds them from a header row, a JSON example or schema, or a CREATE TABLE statement you paste.
  3. Press Download. Copy, Send to another tool and Options (seed, as-of date, CSV and SQL settings, save and share) sit under the preview.

Questions about generated test data

Is any of this real?

The reference lists are real public data; the people and companies are invented combinations, and products come from MySafeInfo’s invented Sample store. Emails use example.com, example.net, example.org or your own test domain, and phones use the fictional 555-0100 to 555-0199 range.

Can I get the same data again?

Yes. Save the setup, including its seed, as-of date and source revision. The same settings reproduce the same rows. Increasing the row count keeps the earlier rows. Renaming a column does not shuffle values.

How do I load it into SQL Server, PostgreSQL, MySQL or SQLite?

Choose SQL, then pick your dialect and table name under Options. The script creates the table and inserts rows in batches below SQL Server’s 1,000-row limit. Review the destination database before running it.

Can I make tables that link together?

Yes. Make customers with their orders, or with orders and products, or add a related table under Customize columns. Every CustomerID in Orders matches a customer, and counts and totals add up. Excel gets a sheet per table, SQL gets primary and foreign keys, and other formats download as a zip.

What is messy data?

Realistic mistakes to clean up: blanks, duplicates, extra spaces, hidden characters and more, at rates you choose. A separate answer key lists every change and its clean value, so you can check the work. SQL downloads stay clean.

What does a Data Pass add?

The free tool makes up to 1,000 rows, plus their related tables, with every format, linked table and messy data option. A Data Pass raises that to 250,000 rows and adds the complete collections: every ZIP code, product and name, 31,754 world cities, U.S. federal holidays and business days, and People collection IDs. It is optional.

Keep the generated data in context

Use up to 40 columns per table, and link up to 5 tables, 3 levels deep. Unique finite lists cannot supply more unique values than they contain. Birth dates use the setup’s as-of date. Weekdays exclude Saturday and Sunday; with a Data Pass, business days also skip U.S. federal holidays. Everything is generated on your device.

Made something with a MySafeInfo tool? Share it. If approved, get 75% off a Data Pass.