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

Page: https://datautility.in/mock-data-generator
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

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

## How to use the Mock Data Generator

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.

1. Choose a dataset
2. Edit the columns
3. Set rows and generate

## What it does

- Realistic fake names, emails and dates
- Presets or your own columns
- Up to 500,000 rows
- CSV, JSON, Parquet or Excel

## 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-#####).
- After you generate, the panel under the download buttons offers matching datasets (for example visits, lab results and vitals for Patients) with ids that line up, as one ZIP.
- Linked set mode: drag datasets from any group into your set (flight bookings from Travel, payments from Finance), then drag a column onto a column of another dataset to link them. The linked column only uses values that exist in the first one.

## 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 link datasets from different groups, such as flights and payments?
Yes. Open Linked set, add the datasets (for example Flight bookings from Travel and Booking payments from Finance), and drag booking_ref from one onto booking_ref of the other, or use the link button. Every value in the linked column then exists in the other file, and a check after download shows how many values matched.

### Can I generate related datasets that join?
Yes. After you generate a dataset such as Patients, Orders, Students or Bank accounts, the related datasets panel creates the matching ones (visits, products, exam marks, loans and more) so every id exists in both files, then downloads them together as one ZIP.

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

## Related pages

- [Fake Data Generator](https://datautility.in/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](https://datautility.in/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](https://datautility.in/student-data-generator): Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- [Student Marks Dataset Generator](https://datautility.in/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.
- [Sample Data for SQL Practice](https://datautility.in/sample-data-for-sql-practice): Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- [Dummy Data for Excel Practice](https://datautility.in/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](https://datautility.in/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](https://datautility.in/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](https://datautility.in/guides/test-data)

## Guides

- [Free Mock Data Generator: Realistic Test Data in 1 Minute](https://datautility.in/blog/free-mock-data-generator-test-data)
- [Mock API Data for Frontend and Backend Testing](https://datautility.in/blog/mock-api-data-for-frontend-testing)
- [Free Online Data Tools for Students and Learners](https://datautility.in/blog/free-data-tools-for-students)
- [How to Generate a Dataset for a College Project](https://datautility.in/blog/how-to-generate-datasets-for-a-college-project)

Open the tool: https://datautility.in/mock-data-generator
