Dummy Data Generator Tool

Dummy Data Generator Tool
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
Dummy Data Generator Tool

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
    Dummy Data Generator Tool
  • As the file contains macros, you may be asked to enable the macros to use the tool
    Dummy Data Generator Tool
  • Click on ‘Generate Dummy Data’ button
    Dummy Data Generator Tool
  • The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
    Dummy Data Generator Tool
  • Following are the datatype which are available in the tool for selection
Dummy Data Generator Tool
Dummy Data Generator Tool
  • Once you are ready with the fields, click on ‘Generate Random Data’ button on the form
Dummy Data Generator Tool
  • Within few seconds, tool will generate the data in a new workbook
Dummy Data Generator Tool
  • Congratulations you are now ready to use the tool
Dummy Data Generator Tool

Recommended Articles

Similar Posts

VBA Code to Count Cells by Color
| |

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

VBA Code to Check if File Exist in Folder

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

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit