After an intensive dashboard week, we are going to do a mock data challenge this week. So in this blog, I will share some steps about how to use Mackaroo to generate the mock data.

Mockaroo is a powerful tool that simplifies the process of generating realistic mock data for testing and development purposes. Whether you’re a developer, tester, or data analyst, Mockaroo can save you time and effort by automating the creation of diverse datasets. In this step-by-step guide, we’ll walk you through the process of using Mockaroo effectively, so you can harness its potential and accelerate your development workflow.

Step 1: Getting Started with Mockaroo

  1. Access the Mockaroo website at
  2. Sign up for a free account to unlock additional features and increased usage limits.


Step 2: Creating a New Schema

  1. Once you’re logged in, click on the “Create Schema” button.
  2. Give your schema a descriptive name to help you identify it later.
  3. Determine the number of rows you want in your dataset.
  4. Define the fields you need by clicking on the “Add Field” button.


Step 3: Customizing Data Fields

  1. For each field, specify the data type from the dropdown menu. Options include names, addresses, email addresses, phone numbers, dates, and more.
  2. Customize the properties of each field by adjusting options like format, range, or distribution. This ensures the generated data matches your requirements.


Step 4: Establishing Relationships

  1. To create relationships between fields, click on the “Add Another Field” button and choose the related field from the dropdown menu.
  2. Use the relationship feature to generate data that reflects realistic associations. For example, you can link customers with their corresponding orders.


Step 5: Validating Data
  1. Ensure data quality by setting up validation rules for specific fields. Click on the “Add Validation” button for a field and define the validation criteria.
  2. Specify constraints such as minimum and maximum values, regular expressions, or custom rules to ensure the generated data meets specific criteria.


Step 6: Previewing and Customizing Sample Data

  1. Click on the “Preview Data” button to see a sample of the generated data based on your schema.
  2. If necessary, modify the generated sample data by clicking on the values and editing them directly in the preview window.


Step 7: Exporting Data

  1. Once you’re satisfied with your schema and the generated sample data, it’s time to export your dataset.
  2. Click on the “Download Data” button and choose the desired format, such as CSV, JSON, SQL, or Excel.
  3. Save the file to your preferred location on your local machine.


Step 8: Integrating Mockaroo with Your Development Environment
  1. Import the exported dataset into your development environment or application, depending on your specific needs.
  2. Use the generated mock data to populate databases, test APIs, or simulate real-world scenarios.


Mockaroo empowers developers and testers by providing an intuitive interface for generating realistic mock data. By following this step-by-step guide, you can easily create custom schemas, establish relationships between fields, validate data, and export datasets in various formats. Incorporating Mockaroo into your development workflow will enhance the accuracy and efficiency of your testing processes, enabling you to build robust and reliable applications with ease.

The Data School
Author: The Data School