Dummy Data Generator Tool

About the tool

Complete Excel VBA Course

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


  • 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
    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
  • 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

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Complete Excel VBA Course

Lets get connected and start learning now. Click here to Enroll.

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Similar Posts

Leave a Reply

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