Dummy Data Generator

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 increase, tool may take more time to generate random data

How to use this tool

Opening the tool

  1. Open the tool and you will see below screen
    Dummy Data Generator
  2. As the file contains macros, you may be asked to enable the macros to use the tool
    Dummy Data Generator
  3. Click on ‘Generate Dummy Data’ button
    Dummy Data Generator
  4. The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
    Dummy Data Generator
  5. Following are the datatype which are available in the tool for selection
    Dummy Data Generator
  6. Once you are ready with the fields, click on ‘Generate Random Data’ button on the form
    Dummy Data Generator
  7. Within few seconds, tool will generate the data in a new workbook
    Dummy Data Generator
  8. Congratulations you are now ready to use the tool