Sample Data for SQL Practice

Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.

Quick answer: Create realistic fake data for testing and demos.

How to use the Sample Data for SQL Practice

Create realistic fake data for testing and demos.

The Data Generator creates realistic fake data: names, emails, phone numbers, addresses, dates, prices and more. Pick a preset or build your own columns, choose up to 500,000 rows, and download CSV, JSON, Parquet or Excel. Developers and testers use it to fill demos, load-test apps and avoid copying real customer data into test systems.

Choose a dataset
Edit the columns
Set rows and generate

Tips

Up to 500,000 rows – type any number you like.
“Empty %” leaves some values blank to test missing data.
Pattern: # = digit, ? = letter, * = either (e.g. ORD-#####).

Example

Input: Dataset: Students, 500 rows

Output: students.csv ready for SELECT, JOIN and GROUP BY

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I practise SQL with this data?

Generate a dataset, download the CSV, then open SQL on Your Files and run queries such as SELECT course, AVG(marks) FROM students GROUP BY course. Nothing needs to be installed.

Can I practise JOIN?

Yes. Generate two datasets, for example students and exam marks, and join them on student_id.

Is the data real?

No. It is random and fictional, so it is safe to share.

Can I get the same data again?

No – each click makes new data. Download to keep a set.

How many rows can the Data Generator create?

Up to 500,000 rows at a time. Choose column types such as names, emails, addresses and dates, then download as CSV, JSON, Parquet or Excel.

Mock Data Generator: Generate up to 500,000 rows of realistic fake data (names, emails, addresses, dates) and download as CSV, JSON, Parquet or Excel. Free, in your browser.
Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.
Sample CSV File Generator: Create a sample CSV with realistic names, emails, dates and numbers. Choose columns and rows, then download. Free and private.
Fake Database for Testing: Create a fake database for testing: paste a CREATE TABLE script and get realistic rows as INSERT statements, CSV or JSON. Free, in your browser.

Topic guides

Test Data Guides and Free Generators