The Data Masking functions are categorised logically, making it easier to browse them and find them. They can be used as simple functions, or combined in complex formulae.

Note: for some functions, the cell type must be set. For instance, generating dates requires the cell formatting must be set to the relevant date type. To format cells, right click the relevant cells and click "format cells", before selecting the relevant formatting. Cell formatting further provides a greater degree of flexibility and increases the variety of data that can be generated using the data generation functions. The formatting can be specified for some functions within the formula itself, as specified below.

Note: The locale is set to the default US English (en_US) in the following examples, unless otherwise stated.

Numbers

Functions that mask integers.

Function Name

Description

Example

VIP.FormattedString

Returns a random string based on the format "# = Number, ? = Letter, * = Number or Letter".

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

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

VIP.Function.IntSequence

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

"=VIP.Function.IntSequence(1, 1)"

Returns:
1
2
3

VIP.Function.LongSequence

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

"= VIP.Function.LongSequence(1,24)"

Returns:
23
24
25

VIP.Random.RandomDouble

Returns a random double value less than 1.

"=VIP.Random.RandomDouble()"

Returns:
0.291310112
0.634659199
0.968867593

VIP.Random.RandomInt

Returns a random integer value within a specified integer range

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

Returns:
6
2
6

VIP.Random.RandomLong

Returns a random, long and big integer value within a specified long range.

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

Returns:
229432
33478
8765

Address

Functions that mask addresses and place names.

Function Name

Description

Example

VIP.Address.StreetName

Returns a random street name.

"=VIP.Address.StreetName()"

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

When Locale is set to fr.

VIP.Address.BuildingNumber

Returns a random building number.

"=VIP.Address.BuildingNumber()"

Returns:
076
4583
5567

VIP.Address.City

Returns a random city name.

"=VIP.Address.City()"

Returns:
Jacksonville
Nottingham
Milan

VIP.Address.CityPrefix

Returns a random city prefix.

"=VIP.Address.CityPrefix()"

Returns:
East
Port
Lake

VIP.Address.CitySuffix

Returns a random city suffix.

"=VIP.Address.CitySuffix()"

Returns:
Shire
Berg
Ham

VIP.Address.Country

Returns a random country.

"=VIP.Address.Country()"

Returns:
Barbados
Fiji
England

VIP.Address.CountryCode

Returns a random country code.

"=VIP.Address.CountryCode()"

Returns:
QA
JP
SM

VIP.Address.County

Returns a random English county.

"=VIP.Address.County()"

Returns:
Cambridgeshire
Buckinghamshire
Nottinghamshire

VIP.Address.FullAddress

Returns a random full address.

"=VIP.Address.FullAddress()"

Returns:

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

VIP.Address.Latitude

Returns random latitudinal coordinates.

"=VIP.Address.Latitude()"

Returns:
61.9834
-69.9603
-64.8166

IP.Address.Longitude

Returns random longitudinal coordinates.

"=VIP.Address.Longitude()"

Returns:
-84.5083
-8.8659
-19.2732

VIP.Address.SecondaryAddress

Returns a random secondary full address.

"=VIP.Address.SecondaryAddress()"

Returns:
Suite 895
Apt. 548
Apt. 511

VIP.Address.State

Returns a random state.

"=VIP.Address.State()"

Returns:
Orissa
Pondicherry
Jammu and Kashmir

When Locale is set to en_IND.

VIP.Address.StateAbbr

Returns a random state abbreviation.

"=VIP.Address.StateAbbr()"

Returns:
UT
OK
VA

When Locale is set to en_US.

VIP.Address.StreetAddress

Returns a random street address.

"=VIP.Address.StreetAddress()"

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

When Locale is set to SV.

VIP.Address.StreetSuffix

Returns a random street suffix.

"=VIP.Address.StreetSuffix()"

Returns:
park
straat
plantsoen

When Locale is set to nl.

VIP.Address.ZipCode

Returns a random zip code.

"=VIP.Address.ZipCode()"

Returns:
TN01 2XU
YP23 1FE
UO8 1BQ

When Locale is set to en_GB

Company and Commerce

Functions that mask company and product information.

Function Name

Description

Example

VIP.Commerce.Category

Returns a random product category.

"=VIP.Commerce.Category"

Returns:
Electronics
Automotive
Home

VIP.Commerce.Color

Returns a random product color.

"=VIP.Commerce.Color"

Returns:
gold
yellow
ivory

VIP.Commerce.Price

Returns a random product price.

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

Returns:
$2.46
$1.78
$2.54

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

VIP.Commerce.PriceParameter

Returns a random product price, parameterized.

"=VIP.Commerce.PriceParameter(1,4,2,"$")"

Returns:
$2.46
$1.78
$2.54

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

VIP.Commerce.Product

Returns a random product type.

"=VIP.Commerce.Product()"

Returns:
Salad
Chicken
Computer

VIP.Commerce.ProductAdjective

Returns a random product adjective.

"=VIP.Commerce.ProductAdjective"

Returns:
Sleek
Refined
Fantastic

VIP.Commerce.ProductMaterial

Returns a random product material.

"=VIP.Commerce.ProductAdjective"

Returns:
Sleek
Refined
Fantastic

VIP.Commerce.ProductName

Returns a random product name.

"=VIP.Commerce.ProductName()"

Returns:
Generic Frozen Towels
Rustic Wooden Chair
Incredible Steel Mouse

VIP.Company.CompanyName

Returns a random company name.

"=VIP.Company.CompanyName()"

Returns:
Garnier - Perrot
Rosenbaum Group
Reilly – Hermann

When Locale is set to en_GB

VIP.Company.CompanySuffix

Returns a random company suffix.

"=VIP.Company.CompanySuffix()"

Returns:
Inc
Ltd
and Sons

VIP.Company.bs

Returns a random piece of company jargon or management speak.

"=VIP.Company.Bs()"

Returns:
generate next-generation relationships
scale e-business relationships
maximize ubiquitous markets

VIP.Company.CatchPhrase

Returns a random company catch phrase.

"=VIP.Company.CatchPhrase()"

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

Date

Functions that mask company and product information.

Function Name

Description

Example

VIP.Date.Future

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

"=VIP.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).

VIP.Date.Month

Returns a random month.

"=VIP.Date.Month()"

Returns:
January
February
December

VIP.Date.MonthAbbr

Returns a random month abbreviation.

"=VIP.Date.MonthAbbr"

Returns:
Jan
Mar
Nov

VIP.Date.Past

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

"=VIP.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).

VIP.Date.Recent

Returns a random date within a number of days of the current date, specified in the format =VIP.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.

"=VIP.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).

VIP.Date.Weekday

Returns a random weekday.

"=VIP.Date.Weekday()"

Returns:
Friday
Wednesday
Sunday

VIP.Date.WeekdayAbbr

Returns a random weekday abbreviation.

"= VIP.Date.WeekdayAbbr()"

Returns:
Tues
Sun
Mon

VIP.Random.RandomDate

Returns a random date within a specified date range.

"=VIP.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).

Finance

Functions that mask account, currency, and transaction information.

Function Name

Description

Example

VIP.Finance.Account

Returns a random account number.

"=VIP.Finance.Account()"

Returns:
84296305
23065655
16099530

VIP.Finance.AccountName

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

"=VIP.Finance.AccountName()"

Returns:
Savings Account
Personal Loan account
Savings Account

VIP.Finance.AccountOfSpecifiedLength

Returns a random account number of a specified length.

"=VIP.Finance.AccountOfSpecifiedLength(12)"

Returns 12 Digit Account Numbers:
005968327716
548027231195
818407984863

VIP.Finance.Amount

Returns a random amount of money.

"=VIP.Finance.Amount()"

Returns:
Credit Card Account
Savings Account
Personal Loan Account

VIP.Finance.AmountWithDetails

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

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

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

VIP.Finance.Bic

Returns a random bank identifier code (Bic).

"=VIP.Finance.Bic()"

Returns:
TOXECRZ1399
UOTUGNB1
TWJAGDQ1

VIP.Finance.BitcoinAddress

Returns a random bitcoin address.

"=VIP.Finance.BitcoinAddress()"

Returns:
3M0Z1F9R7Z79H04F9R5Y4KQ10634
3BS6SB09WYY9BK9BG6Y40CHCMJH4B7
1RS9Q8JY968NPLXNJY11Y21D57MXDE88WJ

VIP.Finance.CreditCardNumber

Returns a random valid credit card number.

"=VIP.Finance.CreditCardNumber()"

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

VIP.Finance.Currency.Code

Returns a random currency code.

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

Returns:
USD
XTS
MOP

VIP.Finance.Currency.Description

Returns a random currency with a description.

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

Returns:
IRR
DKK
RWF

VIP.Finance.Currency.Symbol

Returns a random currency symbol.

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

Returns:
£
TT$
?

Name

Functions that mask job descriptors and names.

Function Name

Description

Example

VIP.Name.FirstName

Returns a first name.

"=VIP.Name.FirstName"

Returns:
蓮
太一
陽翔

When Locale is set to ja

VIP.Name.FullName

Returns a full name.

"=VIP.Name.FullName()"

Returns:
Ramon Karlsson
Amy Svensson
Neil Nilsson

When Locale is set to sv

VIP.Name.JobArea

Returns a job area.

"=VIP.Name.JobArea()"

Returns:
Integration
Solutions
Group

VIP.Name.JobDescriptor

Returns a job descriptor.

"=VIP.Name.JobDescriptor()"

Returns:
Senior
Customer
Corporate

VIP.Name.JobTitle

Returns a job title.

"=VIP.Name.JobTitle()"

Returns:
Human Accounts Executive
Customer Directives Manager
Product Paradigm Assistant

VIP.Name.JobType

Returns a job type.

"=VIP.Name.JobType()"

Returns:
Dynamic Program Associate
Customer Paradigm Manager
Chief Applications Analyst

VIP.Name.LastName

Returns a last name.

"=VIP.Name.LastName()"

Returns:
Ferrara
Costantin
Bianc

When Locale is set to it

VIP.Name.Prefix

Returns a name prefix.

"=VIP.Name.Prefix()"

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

When Locale is set to el

VIP.Name.Suffix

Returns a name suffix.

"=VIP.Name.Suffix()"

Returns:
I
Sr.
V

Phone and Internet

Functions that mask information relating to email, phone numbers, IP, URL, and online account details.

Function Name

Description

Example

VIP.Internet.Avatar

Returns an online avatar.

"=VIP.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

VIP.Internet.DomainName

Returns an internet domain name.

"=VIP.Internet.DomainName()"

Returns:
samuel.es
clemente.info
patricio.info

VIP.Internet.DomainSuffix

Returns an internet domain name suffix (".com; .net; .org").

"=VIP.Internet.DomainSuffix()"

Returns:
es
org
info

VIP.Internet.DomainWord

Returns an email address.

"=VIP.Internet.DomainWord()"

Returns:
rosario
ramona
eva

VIP.Internet.Email

Returns an email address.

"=VIP.Internet.Email()"

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

VIP.Internet.EmailWithDetails

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

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

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

VIP.Internet.IP

Returns an internet IP address.

"=VIP.Internet.Ip()"

Returns:
222.88.182.155
55.114.248.110
134.228.149.234

VIP.Internet.IPv6

Returns an internet IP V6 address.

"=VIP.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

VIP.Internet.Mac

Returns a Mac address.

"=VIP.Internet.Mac()"

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

VIP.Internet.Password

Returns a random internet password.

"=VIP.Internet.Password()"

Returns:
fBUMRer2Wa
7n3Ku5RcHW
9enZAxmV_r

VIP.Internet.PasswordWithDetails

Returns a random internet password of a specified length.

"=VIP.Internet.PasswordWithDetails(6)"

Returns:
lvTV5g
vJ2RvY
vWyLJX

VIP.Internet.Protocol

Returns a random internet protocol (http or https).

"=VIP.Internet.Protocol()"

Returns:
http
https
https

VIP.Internet.URL

Returns a random internet URL.

"=VIP.Internet.Url()"

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

VIP.Internet.UserAgent

Returns a random internet UserAgent.

"=VIP.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)

VIP.Internet.UserName

Returns a random internet UserName.

"=VIP.Internet.UserName()"

Returns:
JoseEmilio_Valle
Daniela_Godoy94
Rosa.Cardona92

VIP.Internet.UserNameWithDetails

Returns a random internet UserName with details.

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

Returns:
first.last22
first.last
first91

VIP.Phone.PhoneNumber

Returns a random phone number, specified by the locale.

"=VIP.Phone.PhoneNumber()"

Returns:

+910245048269
+912292980049
+91289-806-9090

When Locale is set to en_IND

VIP.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.

"=VIP.Phone.PhoneNumberWithFormat("(0)#### ######")"

Returns:
(0)9238 323314
(0)8239 933496
(0)6060 966141

When Locale is set to es

Linguistics and Text

Functions that mask basic linguistics and placeholder text.

Function Name

Description

Example

VIP.Hacker.Abbreviation

Returns an abbreviation for a random word.

"=VIP.Hacker.Abbreviation()"

Returns:
IB
SAS
CSS

VIP.Hacker.Adjective

Returns an abbreviation for a random word.

"=VIP.Hacker.Adjective()"

Returns:
optical
open-source
optical

VIP.Hacker.IngVerb

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

"=VIP.Hacker.IngVerb()"

Returns:
parsing
quantifying
indexing

VIP.Hacker.Noun

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

"=VIP.Hacker.Noun()"

Returns:
pixel
driver
system

VIP.Hacker.Phrase

Returns a phrase.

"=VIP.Hacker.Phrase()"

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

VIP.Hacker.Verb

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

"=VIP.Hacker.Verb()"

Returns:
navigate
reboot
input

VIP.Lorem.Lines

Returns several lines of filler text.

"=VIP.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.

VIP.Lorem.Paragraph

Returns a single paragraph of filler text.

"=VIP.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.

VIP.Lorem.Paragraphs

Returns paragraphs of filler text, the number of which is specified.

!ERROR! illegal character '"'

VIP.Lorem.Review

Returns a random user product review.

"=VIP.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.

VIP.Lorem.Sentence

Returns a single sentence of filler text.

"=VIP.Lorem.Sentence()"

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

VIP.Lorem.Sentences

Returns sentences of filler text, the number of which are specified.

"=VIP.Lorem.Sentences(2)"

Returns:
Autem enim debitis non quisquam deleniti. Labore quibusdam et. Quis aut facere.

VIP.Lorem.Slug

Returns a random slug, the portion of the URL that specifies a resource, of length specified.

"=VIP.Lorem.Slug(4)"

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

VIP.Lorem.Text

Returns text on random lorem methods.

"=VIP.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.

VIP.Lorem.Word

Returns a word on random lorem methods.

"=VIP.Lorem.Word()"

Returns:
nemo
dolorem
accusamus

VIP.Lorem.Words

Returns words on random lorem methods.

"=VIP.Lorem.Words()"

Returns:
dolorum consequuntur assumenda
non consequatur beatae
aliquid est perspiciatis

VIP.Random.RandomStringFixedLength

Returns a random string of a specified, fixed length. The function is formatted =VIP.Random.RandomStringFixedLength(length, includeNumbers, includeSpecialChars

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

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

Data Generation Function List

The Spill Handle - Excel Add-in