MIP Logo

Using Mockaroo to Create Data

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

Using Mockaroo to Create Data

 

In this blog, I will demonstrate how to create simple data using Mockaroo. This data can be used for various purposes, such as training or testing.

 

This is the website where you can create the data.

 

 

 

Introduction to Mockaroo

 

Mockaroo is a website that allows you to create realistic test data quickly. It provides tools to generate data schemas, upload and store datasets, create APIs, and manage projects. The main options available on the website include:

Schemas: Where you create your dataset structure.

Datasets: After downloading your schema, you can save this data under Datasets.

APIs: Allows you to create and connect to APIs for data generation.

Scenario: Stores the scenarios you have created.

Projects: Displays all your projects, which you can also share with others.

Functions: Custom functions you can use to enhance your data generation process.

 

On the top right corner, you will find Settings and Account details. At the bottom of the screen, there are options to Generate Data, Preview the results, and Save your schema.

 

Creating a Table

 

Below the header, you will find the main area for creating your dataset table. This section allows you to customize columns and select the format type for each column.

 

Adding and Renaming Columns

 

  1. Start by clearing all pre-existing columns, keeping only the first one.
  2. Create and rename your columns to fit your desired data structure. For this example, we will create 4 columns: ID, Name, Product, and Price.

 

 

Selecting Format Types

 

When you click on the Format Type field, a new screen appears where you can select or search for the desired format type. The process for each column is as follows:

 

  • ID Column: Use the format type Row Number.
  • Name Column: Change the format type to Full Name.

 

 

 

 

  • Product Column: Choose Custom List. Add the list of products manually, and select Weighted to control the distribution.

 

 

 

 

In this example, the weights are: Mobile (40%), Notebook (40%), Watch (10%), and Video Game (10%).

 

 

 

  • Price Column: Set the format type to Number. Configure the settings to have a minimum of 100, a maximum of 1500, with two decimal places and no blanks.

 

 

 

 

Generating and Previewing Data

 

 

Once all columns are set, click on Preview to see the generated data. The result will display the data according to your schema.

 

 

 

 

 

 

Conclusion

This is a basic guide on how to create data using Mockaroo. It is a powerful tool for generating data for various use cases, from testing and training to data analysis and development. Mockaroo’s flexibility makes it extremely useful for building datasets that match your specific requirements.

 

Share this post