Productivity and Automation

Dummy Data Generator Tool

Table of Content

About the tool

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Booleans etc.

Tool Features

Generate unlimited dummy records on one click
Supports 45 types of data points
Capability to generate Numbers, Text, Date, Time, Long Text, Boolean and many more data types

Benefits

No additional software / investment required, works with commonly available Office Applications
Helps in tool testing
Helps in identifying bugs and deliver high quality tools

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of records increases, tool may take more time to generate random data

How to use this tool

Follow the below video which details out how to use this tool.

Open the tool and you will see below screen
As the file contains macros, you may be asked to enable the macros to use the tool
Click on ‘Generate Dummy Data’ button
The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Following are the datatype which are available in the tool for selection

Once you are ready with the fields, click on ‘Generate Random Data’ button on the form

Within few seconds, tool will generate the data in a new workbook

Congratulations you are now ready to use the tool

Recommended Articles

VBA Code to Filter Data in Excel

Excel VBA and Macros | Productivity and Automation

VBA Code to Filter Data in Excel

Byexcelsirji

VBA Code to Filter Data in Excel Here is an easy reference code which filters data in the sheet. In the code, we have filtered the data in three steps. Step 1: Remove existing filter from…

Excel_Random

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

RANDOM Sampling Excel Tool

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

VBA Code to Add New Sheet at Beginning or End of Excel File

Excel VBA and Macros | Productivity and Automation

VBA Code to Add New Sheet at Beginning or End of Excel File

Byexcelsirji

VBA Code To Add New Sheet In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet…

Outlook-Bulk-Email-Tool

Productivity and Automation

Outlook Bulk Email Tool

Byexcelsirji

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

Reduce File Size in Excel

Productivity and Automation

How to reduce excel file size quickly? – Complete Guide with 8 Methods

ByAnshu Taneja

Learn to reduce excel file size. Tips include removing unnecessary formatting, compressing images, using formulas instead of hardcoded data, and optimizing pivot tables. Clearing unused cells and minimizing data ranges also help. Lastly, consider saving as binary or using third-party add-ins for further compression.

VBA Code to Check if File Exist in Folder

Productivity and Automation

VBA Code to Check if File Exist in Folder

Byexcelsirji

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit