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

Advance Filter in Excel – how to create and use
| | |

Advance Filter in Excel – how to create and use

BySumit Shrimal

This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.

XLOOKUP function in Excel with formula examples
|

XLOOKUP function in Excel with formula examples

BySumit Shrimal

This tutorial introduces XLOOKUP, a new function in Excel for both vertical and horizontal lookups. Tasks that used to feel super complicated, like left-side lookups, finding the last match, or using VLOOKUP with multiple criteria, are now much easier with XLOOKUP.
Before, you had to choose between VLOOKUP for vertical lookups, HLOOKUP for horizontal ones, or more complex options like INDEX MATCH or Power Query. But now, you don’t have to pick anymore. XLOOKUP can handle all those tasks in one simple function.

Leave a Reply

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

Excel VBA Master Tool Kit