The Data Generation feature allows users to quickly create dummy data in one or more spreadsheet columns. This function is especially useful for developers and analysts who need to populate test data for formulas, formatting, or functionality testing without manually entering large amounts of information.
It is accessed from the EasySheet Pro ribbon and opens a side panel with various generation options.

Types of Data That Can Be Generated:

Numbers
Generates random numbers

Text
Creates random text strings and numbers

Dates
Produces random dates between two specified dates

Fiscal Years
Inserts specific or random fiscal years for financial simulations

Boolean
Generates TRUE/FALSE values for logical condition testing

UUID (Universally Unique Identifiers)
Creates unique identifiers for records or elements

Values
Allows inserting a user-defined list of values that will be randomly distributed across selected cells

Email
Generates valid format fake email addresses for testing contact fields

Phone Numbers
Generates random phone numbers

1,2,3,4,5,6
Generates random numbers between 1 and 6, simulating a dice roll

Notes
Data is inserted starting from row 2, as row 1 is reserved for headers
After generation, columns are automatically resized to fit the content
The same data type can be generated in multiple columns simultaneously, making it easier to create complex datasets

Available Operations
Custom Header Naming – Users can specify the header name for generated columns, ensuring clear data identification.

Select Destination Columns – Choose one or more columns for generated data, offering flexibility in data arrangement.

Define Number of Rows – Users can specify how many rows of data to generate, adapting to their specific needs.

How to Use
In the side panel, choose the type of data to generate (e.g., numbers, dates, text, etc.).

Enter the desired header name for the column.

Select the columns where the generated data should be inserted.

Specify the number of rows to create.

Click the generate button – data will be inserted into the selected columns starting from row 2.