Make a dataset that holds together
Start with customers, employees, products, suppliers, students or website events. The first ten rows show exactly how your download begins. Change the columns, choose a row count and format, then download a file ready for your project. Related columns share the same underlying record: names build emails, ZIP codes supply cities and states, and occupations supply salary ranges. Select a value to see its source and the rule that produced it.
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 and Age. Shuffle chooses another seed. Reserved email domains and fictional phone numbers keep your demo from contacting a stranger.
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. Missing published wages stay empty. Download includes the table definition and batched INSERT statements.
Grades for a spreadsheet exercise
Input
Students and grades · Excel · seed 42
Result
StudentID, FirstName, LastName, GradeLevel, Subject, Score, LetterGrade, Teacher
Scores cluster around a typical value; the grade reads the score from the same row. Excel keeps numbers numeric and IDs as text. Teachers repeat from a fixed pool of 40 invented people, separate from the students.
From starting point to usable file
- Pick a starting point. Customers opens with a filled ten-row preview; Blank starts with a row number and the type picker.
- Adjust columns, ranges and shares. Rename fields, move them up or down, and select values to understand how related columns agree.
- Choose rows and a format, then Download. More options holds the seed, as-of date, CSV settings, SQL dialect and save/share controls.
Questions about generated test data
Is any of this real?
The reference lists are real public data; the people and companies are invented combinations. Products come from MySafeInfo’s invented Sample store. Do not use these rows as evidence about actual individuals.
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.
Are the emails and phone numbers safe to use?
Emails use example.com, example.net or example.org unless you enter your own test domain. U.S. phones use a real area code and the fictional 555-0100 through 555-0199 range. Suppliers have a separate country calling code instead of an international phone number.
How do I load it into SQL Server, PostgreSQL, MySQL or SQLite?
Choose SQL, then select your dialect and table name under More options. Download the CREATE TABLE and INSERT script. Review the destination database before running it. Each INSERT batch stays below SQL Server’s 1,000-row limit.
Why do the cities and ZIP codes match?
City, state, ZIP, county and coordinates come from one Census ZIP code record. Population weights favor larger places. Street names and house numbers are invented; they are not verified deliverable addresses.
What does a Data Pass add?
The free tool supports 10,000 rows and every column type and format. A Data Pass increases that to 250,000 rows and uses complete ZIP and product collections plus larger historical name pools. It is optional.
Keep the generated data in context
Use up to 40 columns. 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, and no holiday calendar is applied. This first version creates one table at a time. Everything is generated on your device.