Data Generation Function List

DataGen.FormattedString

Returns a random string, using the format “# = Number, ? = Letter, * = Number or Letter”.

"=DataGen.FormattedString("# = 3, ? = A, * = 5")"

Returns:
2 = 3, C = A, 7 = 5
6 = 3, L = A, 9 = 5
1 = 3, Q = A, 2 = 5

DataGen.Random.RandomFromCSV

Returns a random value from a list of specified values.

"=DataGen.Random.RandomFromCSV("Red,Yellow,Green,Blue")"

Returns:
Red
Yellow
Red

DataGen.SetLocale

Sets the Locale.

"=DataGen.SetLocale("sv")"

Returns:
Locale is set to sv

DataGen.SetSeed

Sets the Seed.

"=DataGen.SetSeed(2)"

Returns:
Seed is set to 2

DataGen.Random.RandomDouble

Returns a random double variable less than 1.

"=DataGen.Random.RandomDouble()"

Returns:
0.291310112
0.634659199
0.968867593

DataGen.Random.RandomInt

Returns a random integer value within a defined range. The function is formatted =DataGen.SequenceInt(minValue, maxValue).

"=DataGen.Random.RandomInt(1, 6)"

Returns:
6
2
6

DataGen.Random.RandomLong

Returns a random big integer value within specified long range. The function is formatted =DataGen.Random.RandomLong(minValue, maxValue).

"=DataGen.Random.RandomLong(1,50000)"

Returns:
229432
33478
8765

DataGen.SequenceInt

Returns a random integer from a defined starting point, without duplicate values. The function is formatted =DataGen.SequenceInt(sequence name, starting number). Integers will not duplicate within each given sequence name.

"=DataGen.SequenceInt(1, 1)"

Returns:
1
2
3

DataGen.Address.BuildingNumber

Returns a random building number between 3 and 5 characters for an address.

"=DataGen.Address.BuildingNumber()"

Returns:
076
4583
5567

DataGen.Address.CityPrefix

Returns a random city prefix.

"=DataGen.Address.CityPrefix()"

Returns:
East
Port
Lake

DataGen.Address.CitySuffix

Returns a random city suffix.

"=DataGen.Address.CitySuffix()"

Returns:
Shire
Berg
Ham

DataGen.Address.Country

Returns a random country.

"=DataGen.Address.Country()"

Returns:
Barbados
Fiji
England

DataGen.Address.CountryCode

Returns a random country code.

"=DataGen.Address.CountryCode()"

Returns:
QA
JP
SM

DataGen.Address.County

Returns a random English county.

"=DataGen.Address.County()"

Returns:
Cambridgeshire
Buckinghamshire
Nottinghamshire

DataGen.Address.FullAddress

Returns a random full address.

"=DataGen.Address.FullAddress()"

Returns:

71186 Eichmann Gateway, North
Nayelishire, India
381 Emelie Ports, Schultzport, Nigeria
935 Mertz Spurs, Lake Ignacio, Niger

DataGen.Address.Latitude

Returns a random latitude.

"=DataGen.Address.Latitude()"

Returns:
61.9834
-69.9603
-64.8166

DataGen.Address.Longitude

Returns a random longitude.

"=DataGen.Address.Longitude()"

Returns:
-84.5083
-8.8659
-19.2732

DataGen.Address.SecondaryAddress

Returns a random secondary address.

"=DataGen.Address.SecondaryAddress()"

Returns:
Suite 895
Apt. 548
Apt. 511

DataGen.Address.State

Returns a random state.

"=DataGen.Address.State()"

Returns:
Orissa
Pondicherry
Jammu and Kashmir

When Locale is set to en_IND.

DataGen.Address.StateAbbr

Returns a random state abbreviation.

"=DataGen.Address.StateAbbr()"

Returns:
UT
OK
VA

When Locale is set to en_US.

DataGen.Address.StreetAddress

Returns a random street address.

"=DataGen.Address.StreetAddress()"

Returns:
Ängsvägen 15
Norra Åkergatan 862
Övre Järnvägsgärdet 720

When Locale is set to SV.

DataGen.Address.StreetName

Returns a random street name.

"=DataGen.Address.StreetName()"

Returns:
Allée de Tilsitt
Rue de Seine
Passage Saint-Séverin

When Locale is set to fr.

DataGen.Address.StreetSuffix

Returns a random street suffix.

"=DataGen.Address.StreetSuffix()"

Returns:
park
straat
plantsoen

When Locale is set to nl.

DataGen.Address.ZipCode

Returns a random zip code.

"=DataGen.Address.ZipCode()"

Returns:
TN01 2XU
YP23 1FE
UO8 1BQ

When Locale is set to en_GB

DataGen.Commerce.Category

Returns a random product category.

"=DataGen.Commerce.Category"

Returns:
Electronics
Automotive
Home

DataGen.Commerce.Color

Returns a random color.

"=DataGen.Commerce.Color"

Returns:
gold
yellow
ivory

DataGen.Commerce.Price

Returns a random product price. The function is formatted =DatGen.Commerce.Price(minimum value, maximum value, number of decimal places, currency symbol). Note: the cell must be formatted to the relevant currency for the symbols to be generated.

"=DataGen.Commerce.Price(1,4,2,"$")"

Returns:
$2.46
$1.78
$2.54

When the cell is formatted to currency, with the symbol “$” set.

DataGen.Commerce.Product

Returns a random product.

"=DataGen.Commerce.Product()"

Returns:
Salad
Chicken
Computer

DataGen.Commerce.ProductAdjective

Returns a random product adjective.

"=DataGen.Commerce.ProductAdjective"

Returns:
Sleek
Refined
Fantastic

DataGen.Commerce.ProductMaterial

Returns a random product material.

"=DataGen.Commerce.ProductMaterial"

Returns:
Metal
Rubber
Cotton"

DataGen.Commerce.ProductName

Returns a random, three word product name, combining adjective, material, product type.

"=DataGen.Commerce.ProductName()"

Returns:
Generic Frozen Towels
Rustic Wooden Chair
Incredible Stee

DataGen.Company.Bs

Returns a random piece of company jargon or management speak.

"=DataGen.Company.Bs()"

Returns:
generate next-generation relationships
scale e-business relationships
maximize ubiq

DataGen.Company.CatchPhrase

Returns a random company catch phrase.

"=DataGen.Company.CatchPhrase()"

Returns:
Implemented content-based moderator
Assimilated incremental Graphical User Interface
Down-sized object-oriented artificial intelligence

DataGen.Company.CompanyName

Returns a random company name.

"=DataGen.Company.CompanyName()"

Returns:
Garnier - Perrot
Rosenbaum Group
Reilly – Hermann

When Locale is set to en_GB

DataGen.Company.CompanySuffix

Returns a random company suffix.

"=DataGen.Company.CompanySuffix()"

Returns:
Inc
Ltd
and Sons

DataGen.Database.Collation

Returns a random database collation.

"= DataGen.Database.Collation()"

Returns:
cp1250_general_ci
ascii_general_ci
utf8_bin

DataGen.Database.Column

Returns a random database column name.

"=DataGen.Database.Column()"

Returns:
createdAt
token
status

DataGen.Database.Engine

Returns a random database storage engine.

"=DataGen.Database.Engine()"

Returns:
CSV
MEMORY
BLACKHOLE

DataGen.Database.Type

Returns a random database column type.

"=DataGen.Database.Type()"

Returns:
bigint
real
serial

DataGen.Date.Future

Returns a random date in the future, with the number of future years specified in the format =DataGen.Date.Future(number of years to go forward) . Note: the cell must be formatted to date, with the correct format.

"=DataGen.Date.Future(4)"

Returns:
10/27/2021
4/20/2022
8/15/2019

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).

DataGen.Date.Month

Returns a random month.

"=DataGen.Date.Month()"

Returns:
January
February
December

DataGen.Date.MonthAbbr

Returns a random month abbreviation.

"=DataGen.Date.MonthAbbr"

Returns:
Jan
Mar
Nov

DataGen.Date.Past

Returns a random date in the past, with the number of past years specified in the format =DataGen.Date.Past(number of years to go back). Note: the cell must be formatted to date, with the correct format.

"=DataGen.Date.Past(80)"

Returns:
2/14/1950
4/25/1944
8/7/1979

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).

DataGen.Date.Recent

Returns a random date within a number of days of the current date, specified in the format =DataGen.Date.Recent(number of days). The number of days is set to 30 by default. Note: the cell must be formatted to date, with the correct format.

"=DataGen.Date.Recent(5)"

Returns:
9/6/2018
9/6/2018
9/5/2018

When the function is executed on 10/09/2018 and the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).

DataGen.Date.Weekday

Returns a random weekday

"=DataGen.Date.Weekday()"

Returns:
Friday
Wednesday
Sunday

DataGen.Date.WeekdayAbbr

Returns a random weekday abbreviation

"=DataGen.Date.WeekdayAbbr()"

Returns:
Tues
Sun
Mon

DataGen.Random.RandomDate

Returns a random date within a specified range. The function is formatted =DataGen.SequenceInt(“day, month, year”, “day, month, year”). Note: the cell must be formatted to date, with the correct format.

"=DataGen.Random.RandomDate("1/1/1900", "7/19/2018")"

Returns:
8/21/1900
2/4/1909
5/13/1989

When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US).

DataGen.Finance.Account

Returns a random account number.

"=DataGen.Finance.Account()"

Returns:
84296305
23065655
16099530

DataGen.Finance.AccountName

Returns a random account name like Savings, Checkings, Home Loan etc.

"=DataGen.Finance.AccountName()"

Returns:
Savings Account
Personal Loan account
Savings Account

DataGen.Finance.AccountOfSpecifiedLength

Returns a random account number of a length specified in the format =DataGen.Finance.AccountOfSpecifiedLength(number of digits). The number of digits is set to 8 by default.

"=DataGen.Finance.AccountOfSpecifiedLength(12)"

Returns 12 Digit Account Numbers:
005968327716
548027231195

DataGen.Finance.Amount

Returns a random amount within a specified range.

"=DataGen.Finance.Amount()"

Returns:
Credit Card Account
Savings Account
Personal Loan Account

DataGen.Finance.AmountWithDetails

Returns a random amount within a range specified in the fromat =DataGen.Finance>AmountWithDetails(minimum amount, maximum amount, number of decimal places).

"=DataGen.Finance.AmountWithDetails(1, 1000,2)"

Returns a random amount between 1 and 1000, and two decimal places:
265.53
259.83
954.03

DataGen.Finance.Bic

Returns a random bank identifier code (Bic).

"=DataGen.Finance.Bic()"

Returns:
TOXECRZ1399
UOTUGNB1
TWJAGDQ1

DataGen.Finance.BitcoinAddress

Returns a random bitcoin address.

"=DataGen.Finance.BitcoinAddress()"

Returns:
3M0Z1F9R7Z79H04F9R5Y4KQ10634
3BS6SB09WYY9BK9BG6Y40CHCMJH4B7
1RS9Q8JY968NPLXNJY11Y21D57MXDE88WJ

DataGen.Finance.CreditCardNumber

Returns a random valid credit card number.

"=DataGen.Finance.CreditCardNumber()"

Returns:
6767-5069-6253-4893-027
6759-5377-4241-9170
3529-2124-4921-0837

DataGen.Finance.Currency.Code

Returns a random currency code.

"=DataGen.Finance.Currency.Code()"

Returns:
USD
XTS
MOP

DataGen.Finance.Currency.Description

Returns a random currency description.

"=DataGen.Finance.Currency.Description()"

Returns:
IRR
DKK
RWF

DataGen.Finance.Currency.Symbol

Returns a random currency symbol.

"=DataGen.Finance.Currency.Symbol()"

Returns:
£
TT$

DataGen.Finance.TransactionType

Returns a random transaction type: Deposit, Withdrawl, Payment or Invoice.

"=DataGen.Finance.TransactionType()"

Returns:
payment
withdrawal

Data Generation Functions - Names

Returns a first name.

"=DataGen.Name.FirstName"

Returns:
蓮
太一
陽翔

When Locale is set to ja

DataGen.Name.FullName

Returns a full name.

"=DataGen.Name.FullName()"

Returns:
Ramon Karlsson
Amy Svensson
Neil Nilsson

When Locale is set to sv

DataGen.Name.JobArea

Returns a job specialism.

"=DataGen.Name.JobArea()"

Returns:
Integration
Solutions
Group

DataGen.Name.JobDescriptor

Returns a job descriptor.

"=DataGen.Name.JobDescriptor()"

Returns:
Senior
Customer
Corporate

DataGen.Name.JobTitle

Returns a job title.

"=DataGen.Name.JobTitle()"

Returns:
Human Accounts Executive
Customer Directives Manager
Product Paradigm Assistant

DataGen.Name.JobType

Returns a job type.

"=DataGen.Name.JobType()"

Returns:
Dynamic Program Associate
Customer Paradigm Manager
Chief Applications Analyst

DataGen.Name.LastName

Returns a last name.

"=DataGen.Name.LastName()"

Returns:
Ferrara
Costantin
Bianc

When Locale is set to it

DataGen.Name.Prefix

Returns a name prefix.

"=DataGen.Name.Prefix()"

Returns:
Κύριος
Κυρία
Δόκτορ

When Locale is set to el

DataGen.Name.Suffix

Returns a name suffix.

"=DataGen.Name.Suffix()"

Returns:
I
Sr.
V

DataGen.Phone.PhoneNumber

Returns a random phone number, specified by the locale.

"=DataGen.Phone.PhoneNumber()"

Returns:

+910245048269
+912292980049
+91289-806-9090

When Locale is set to en_IND

DataGen.Phone.PhoneNumberWithFormat

Returns a random phone number, specified by the locale. Formats are specified within bracket and double quotation marks. Hash signs (#) will be replaced with a random number, and all other characters such as spaces, dashes, and bracket, will be replicated literally.

DataGen.Internet.Avatar

Returns an online avatar.

"=DataGen.Internet.Avatar()"

Returns:
https://s3.amazonaws.com/uifaces/faces/twitter/nbirckel/128.jpg
https://s3.amazonaws.com/uifaces/faces/twitter/a1chapone/128.jpg
https://s3.amazonaws.com/uifaces/faces/twitter/traneblow/128.jpg

DataGen.Internet.DomainName

Returns an internet domain name.

"=DataGen.Internet.DomainName()"

Returns:
samuel.es
clemente.info
patricio.info

DataGen.Internet.DomainSuffix

Returns a domain name suffix e.g. .com, .net, .org

"=DataGen.Internet.DomainSuffix()"

Returns:
es
org
info

DataGen.Internet.DomainWord

Returns a random word used in domain names.

"=DataGen.Internet.DomainWord()"

Returns:
rosario
ramona
eva

DataGen.Internet.Email

Returns an email address.

"=DataGen.Internet.Email()"

Returns:
Carolina42@gmail.com
Catalina_Galarza61@hotmail.com
Ramona23@gmail.com

DataGen.Internet.EmailWithDetails

Returns variations of an email using a first name, last name, and provider, specified in the format =DataGen.Internet.EmailWithDetails(“firstname, lastname, provider”).

"=DataGen.Internet.EmailWithDetails("firstname", "lastname", "provider.com")"

Returns:
firstname_lastname@provider.com
firstname.lastname77@provider.com
firstname_lastname59@provider.com

DataGen.Internet.Ip

Returns an IP address.

"=DataGen.Internet.Ip()"

Returns:
222.88.182.155
55.114.248.110
134.228.149.234

DataGen.Internet.Ipv6

Returns an IP V6 address.

"=DataGen.Internet.Ipv6()"

Returns:
ba3a:2ba4:b6b3:5360:f9a6:3747:95e2:504
803e:69ea:b832:c096:76d5:4d32:10:9685
146a:29ab:f04c:afa:2cab:8163:85d:2eb

DataGen.Internet.Mac

Returns a Mac address.

"=DataGen.Internet.Mac()"

Returns:
3d:59:9f:a7:ab:07
87:c1:38:8e:8d:9d
a9:5c:91:4b:ed:ec

DataGen.Internet.Password

Returns a password.

"=DataGen.Internet.Password()"

Returns:
fBUMRer2Wa
7n3Ku5RcHW
9enZAxmV_r

DataGen.Internet.PasswordWithDetails

Returns a password of a length specified in the format =DataGen.Internet.PassWithDetails(number of characters).

"=DataGen.Internet.PasswordWithDetails(6)"

Returns:
lvTV5g
vJ2RvY
vWyLJX

DataGen.Internet.Protocol

Returns a protocol http or https.

"=DataGen.Internet.Protocol()"

Returns:
http
https
https

DataGen.Internet.Url

Returns a URL.

"=DataGen.Internet.Url()"

Returns:
https://lourdes.com
https://federico.com
http://jacobo.es

DataGen.Internet.UserAgent

Returns a UserAgent. Data generated by this function reflects the prevalence of Mozilla over Opera.

"=DataGen.Internet.UserAgent()"

Returns:
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_9_9 rv:6.0; BO) AppleWebKit/538.1.2 (KHTML, like Gecko) Version/4.1.6 Safari/538.1.2
Opera/10.22 (Windows NT 5.2; U; UR Presto/2.9.166 Version/12.00)
Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 5.2; Trident/6.0; .NET CLR 2.6.29901.2)

DataGen.Internet.UserName

Returns a username.

"=DataGen.Internet.UserName()"

Returns:
JoseEmilio_Valle
Daniela_Godoy94
Rosa.Cardona92

DataGen.Internet.WithDetails

Returns a username using variations of a first and last name, specified in the format =DataGen.Internet.WithDetails(“firstname”, “lastname”).

"=DataGen.Internet.WithDetails(“first”, “last”)"

Returns:
first.last22
first.last
first91

DataGen.Hacker.Abbreviation

Returns an abbreviation for a random word.

"=DataGen.Hacker.Abbreviation()"

Returns:
IB
SAS
CSS

DataGen.Hacker.Adjective

Returns a random word which, in this case, is an adjective.

"=DataGen.Hacker.Adjective()"

Returns:
optical
open-source
optical

DataGen.Hacker.IngVerb

Returns a random '-ing' verb, a present participle.

"=DataGen.Hacker.IngVerb()"

Returns:
parsing
quantifying
indexing

DataGen.Hacker.Noun

Returns a random word which, in this case, is a noun.

"=DataGen.Hacker.Noun()"

Returns:
pixel
driver
system

DataGen.Hacker.Phrase

Returns a phrase.

"=DataGen.Hacker.Phrase()"

Returns:
If we index the panel, we can get to the RAM panel through the redundant RAM panel!

DataGen.Hacker.Verb

Returns a random word which, in this case, is a verb.

"=DataGen.Hacker.Verb()"

Returns:
navigate
reboot
input

DataGen.Lorem.Lines

Returns lines of lorem ipsum filler text.

"=DataGen.Lorem.Lines()"

Returns:
Ut explicabo doloremque incidunt aperiam eum. Sed iusto repellendus cupiditate accusantium illum explicabo. Iure commodi veritatis beatae quis placeat id aut. Voluptatibus consequatur officiis sint quos nam cupiditate nemo reprehenderit.
Eaque qui id est hic cum. Iusto veritatis et hic eum. Cum est voluptatibus at nam consequatur. Quod vitae ad dolore accusantium a nobis quo. Quaerat numquam harum eos dolorum nobis doloribus possimus quis.
Ducimus ipsum rerum consequuntur doloremque quia qui et.

DataGen.Lorem.Paragraph

Returns one paragraph of lorem ipsum filler text.

"=DataGen.Lorem.Paragraph()"

Returns:
Libero rerum accusantium tempora minus tenetur quia ea. Doloribus asperiores officia nam et velit voluptatem ut. Doloribus minus modi similique provident tempore quis sunt eos. Numquam pariatur error odio. Deserunt sunt est. Necessitatibus qui accusamus in ut eos nihil vero. Ratione quo quo quia sed magnam doloremque. Aspernatur aut ex earum nesciunt illum. Eveniet molestiae omnis facilis. Non quo impedit suscipit delectus voluptatem et. Doloremque qui delectus molestiae et doloribus et quas facilis. Amet repudiandae harum.

DataGen.Lorem.Paragraphs

Returns a number of paragraphs of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of paragraphs)

"=DataGen.Lorem.Paragraphs(2)"

Returns:
"Aliquam eligendi minus voluptates necessitatibus aliquam. Quo voluptatem non recusandae itaque officiis alias accusamus. Doloribus dolorem harum quasi quo iure excepturi. Eum perspiciatis rerum.
"Et debitis sapiente. Id autem iste aut tempore distinctio ut error illum. Recusandae consectetur itaque qui laborum nihil aut iste voluptates quis. Sint a minima deleniti odit consequatur velit.

DataGen.Lorem.Review

Returns a user review in English.

"=DataGen.Lorem.Review()"

Returns:
My co-worker Atha has one of these. He says it looks narrow.
My chicken loves to play with it.
This product works outstandingly well. It grudgingly improves my baseball by a lot.

DataGen.Lorem.Sentence

Returns a sentence of lorem ipsum filler text.

"=DataGen.Lorem.Sentence()"

Returns:
Odio dolorem unde alias officiis illo doloribus quia aut cupiditate.

DataGen.Lorem.Sentences

Returns a number of sentences of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of sentences)

"=DataGen.Lorem.Sentences(2)"

Returns:
Autem enim debitis non quisquam deleniti. Labore quibusdam et. Quis aut facere.
Omnis exercitationem modi architecto excepturi assumenda reprehenderit sunt et nihil. Illum excepturi vel sed vero illum quos sed culpa. Nostrum sit minima reprehenderit.
Facere voluptas ab. Rerum molestiae itaque quaerat odit quod modi. Dolorem dolorum voluptatibus eius magnam qui.

DataGen.Lorem.Slug

Returns a lorem ipsum slug of length specified in the format =Datagen.Lorem.Slug(numer of words)

"=DatGen.Lorem.Slug(4)"

Returns:
iusto-et-autem-tempore
id-et-aut-enim
nostrum-repudiandae-est-officia

DataGen.Lorem.Text

Returns text using one of the other Lorem functions.

"=DataGen.Lorem.Text()"

Returns:
Sit voluptatem maiores libero error corrupti nesciunt. Numquam sit maiores id. Animi qui molestiae similique maiores voluptatem. Dolore voluptatem vero sed ab iusto porro hic sit eos. Numquam adipisci tempora natus quam quas quia ipsa. Sit esse vel cum veniam similique sit.
Ratione reiciendis ducimus vel in quis voluptatem et quaerat.
Error adipisci nostrum laborum quae aliquid.

DataGen.Lorem.Word

Returns a ipsum word

"=DataGen.Lorem.Word()"

Returns:
nemo
dolorem
accusamus

DataGen.Lorem.Words

Returns a number of ipsum lorem words

"=DataGen.Lorem.Words()"

Returns:
dolorum consequuntur assumenda
non consequatur beatae
aliquid est perspiciatis

DataGen.General.Random.Parse

Returns a string value after resolving a set of functions specified in the format =DataGen.Random.Parse(“{{function1}} {{function2}} {{functionN}}”).

"=DataGen.Random.Parse("{{name.prefix}} {{name.lastname}} {{name.suffix}}")"

Returns:
Dr. Herman MD
Mrs. Koch DVM

DataGen.Random.RandomStringFixedLength

Returns a random string of fixed length with or without numbers and special characters. The function is formatted =DataGen.Random.RandomStringFixedLength(length, includeNumbers, includeSpecialChars)

"=DataGen.Random.RandomStringFixedLength(7,TRUE,TRUE)"

Returns:
vXf2P=G
D%r=nNV
Gjs3$d1

DataGen.General.Random.Spin

Returns a random string value after ‘spinning’ text. Spinning generates variations of variables specified in the format =DataGen.Random.Spin(“{{variable 1|variable2|variable}}”). Spin functions can be strung together. Values outside of squiggly brackets will be reproduced literally.

"=DataGen.Random.Spin("{{Red|Yellow} is {my|your} {favourite|least favourite} colour }")"

Returns
Yellow is my least favourite colour
Red is my favourite colour
Red is your least favourite colour