How to Generate a Dataset for a College Project

No suitable public dataset? You can make a realistic one in a few minutes, as long as you are clear about what it is.

Open the Mock Data Generator

Final-year and course projects often need data that is not available publicly, such as customers, sales or hospital visits with sensitive details. A generated dataset lets you build and test the whole project.

Open the Mock Data Generator, choose a dataset type or your own columns, and set the number of rows. For a table with specific column types, paste a CREATE TABLE into the Schema Data Generator. Download CSV, JSON, Parquet or Excel.

Make it useful. Generate enough rows to make a query or a chart meaningful, include a date column for time analysis, and add some blanks and duplicates on purpose if you want to show cleaning. Open the file in the Data Profiler to describe it in your report.

Be honest in your submission. Say the data is generated, describe how, and avoid conclusions about the real world from random data. Check your institution rules, and use real data only when you have permission to do so.

Open the Mock Data Generator

Related tool pages

  • 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.
  • 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.

How to use the Mock Data Generator: step by step

  1. Open the Mock Data Generator and choose the fields.
  2. Set the number of rows and download the file.
  3. Profile it to describe the columns.
  4. State in your report that the data is generated.

When to use the Mock Data Generator

  • Build a database project
  • Practise charts and dashboards
  • Show data cleaning steps
  • Test a model pipeline

Example

Input: Dataset: Customers, 3 rows

Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com

Frequently asked questions

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.

Tip: Add a few blanks and duplicates on purpose if your project is about data cleaning.