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 Re-link MS Access Link Tables
|

VBA Code to Re-link MS Access Link Tables

Byexcelsirji

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location

Excel Hyperlink: how to create, change and remove
| | |

Excel Hyperlink: how to create, change and remove

BySumit Shrimal

This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.

File Manager Tool

File Manager Tool

Byexcelsirji

File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.

Leave a Reply

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

Excel VBA Master Tool Kit