Data Masking Function List - Excel Add-in
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: |
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: |
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: |
VIP.Random.RandomDouble | Returns a random double value less than 1. | "=VIP.Random.RandomDouble()" Returns: |
VIP.Random.RandomInt | Returns a random integer value within a specified integer range | "=VIP.Random.RandomInt(1, 6)" Returns: |
VIP.Random.RandomLong | Returns a random, long and big integer value within a specified long range. | "=VIP.Random.RandomLong(1,50000)" Returns: |
Address
Functions that mask addresses and place names.
Function Name | Description | Example |
---|---|---|
VIP.Address.StreetName | Returns a random street name. | "=VIP.Address.StreetName()" Returns: When Locale is set to fr. |
VIP.Address.BuildingNumber | Returns a random building number. | "=VIP.Address.BuildingNumber()" Returns: |
VIP.Address.City | Returns a random city name. | "=VIP.Address.City()" Returns: |
VIP.Address.CityPrefix | Returns a random city prefix. | "=VIP.Address.CityPrefix()" Returns: |
VIP.Address.CitySuffix | Returns a random city suffix. | "=VIP.Address.CitySuffix()" Returns: |
VIP.Address.Country | Returns a random country. | "=VIP.Address.Country()" Returns: |
VIP.Address.CountryCode | Returns a random country code. | "=VIP.Address.CountryCode()" Returns: |
VIP.Address.County | Returns a random English county. | "=VIP.Address.County()" Returns: |
VIP.Address.FullAddress | Returns a random full address. | "=VIP.Address.FullAddress()" Returns: 71186 Eichmann Gateway, North |
VIP.Address.Latitude | Returns random latitudinal coordinates. | "=VIP.Address.Latitude()" Returns: |
IP.Address.Longitude | Returns random longitudinal coordinates. | "=VIP.Address.Longitude()" Returns: |
VIP.Address.SecondaryAddress | Returns a random secondary full address. | "=VIP.Address.SecondaryAddress()" Returns: |
VIP.Address.State | Returns a random state. | "=VIP.Address.State()" Returns: When Locale is set to en_IND. |
VIP.Address.StateAbbr | Returns a random state abbreviation. | "=VIP.Address.StateAbbr()" Returns: When Locale is set to en_US. |
VIP.Address.StreetAddress | Returns a random street address. | "=VIP.Address.StreetAddress()" Returns: When Locale is set to SV. |
VIP.Address.StreetSuffix | Returns a random street suffix. | "=VIP.Address.StreetSuffix()" Returns: When Locale is set to nl. |
VIP.Address.ZipCode | Returns a random zip code. | "=VIP.Address.ZipCode()" Returns: 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: |
VIP.Commerce.Color | Returns a random product color. | "=VIP.Commerce.Color" Returns: |
VIP.Commerce.Price | Returns a random product price. | "=VIP.Commerce.Price(1,4,2,"$")" Returns: 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: When the cell is formatted to currency, with the symbol “$” set. |
VIP.Commerce.Product | Returns a random product type. | "=VIP.Commerce.Product()" Returns: |
VIP.Commerce.ProductAdjective | Returns a random product adjective. | "=VIP.Commerce.ProductAdjective" Returns: |
VIP.Commerce.ProductMaterial | Returns a random product material. | "=VIP.Commerce.ProductAdjective" Returns: |
VIP.Commerce.ProductName | Returns a random product name. | "=VIP.Commerce.ProductName()" Returns: |
VIP.Company.CompanyName | Returns a random company name. | "=VIP.Company.CompanyName()" Returns: When Locale is set to en_GB |
VIP.Company.CompanySuffix | Returns a random company suffix. | "=VIP.Company.CompanySuffix()" Returns: |
VIP.Company.bs | Returns a random piece of company jargon or management speak. | "=VIP.Company.Bs()" Returns: |
VIP.Company.CatchPhrase | Returns a random company catch phrase. | "=VIP.Company.CatchPhrase()" Returns: |
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: 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: |
VIP.Date.MonthAbbr | Returns a random month abbreviation. | "=VIP.Date.MonthAbbr" Returns: |
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: 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: 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: |
VIP.Date.WeekdayAbbr | Returns a random weekday abbreviation. | "= VIP.Date.WeekdayAbbr()" Returns: |
VIP.Random.RandomDate | Returns a random date within a specified date range. | "=VIP.Random.RandomDate("1/1/1900", "7/19/2018")" Returns: 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: |
VIP.Finance.AccountName | Returns a random account name like Savings, Checkings and Home Loans etc. | "=VIP.Finance.AccountName()" Returns: |
VIP.Finance.AccountOfSpecifiedLength | Returns a random account number of a specified length. | "=VIP.Finance.AccountOfSpecifiedLength(12)" Returns 12 Digit Account Numbers: |
VIP.Finance.Amount | Returns a random amount of money. | "=VIP.Finance.Amount()" Returns: |
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: |
VIP.Finance.Bic | Returns a random bank identifier code (Bic). | "=VIP.Finance.Bic()" Returns: |
VIP.Finance.BitcoinAddress | Returns a random bitcoin address. | "=VIP.Finance.BitcoinAddress()" Returns: |
VIP.Finance.CreditCardNumber | Returns a random valid credit card number. | "=VIP.Finance.CreditCardNumber()" Returns: |
VIP.Finance.Currency.Code | Returns a random currency code. | "=VIP.Finance.Currency.Code()" Returns: |
VIP.Finance.Currency.Description | Returns a random currency with a description. | "=VIP.Finance.Currency.Description()" Returns: |
VIP.Finance.Currency.Symbol | Returns a random currency symbol. | "=VIP.Finance.Currency.Symbol()" Returns: |
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: When Locale is set to sv |
VIP.Name.JobArea | Returns a job area. | "=VIP.Name.JobArea()" Returns: |
VIP.Name.JobDescriptor | Returns a job descriptor. | "=VIP.Name.JobDescriptor()" Returns: |
VIP.Name.JobTitle | Returns a job title. | "=VIP.Name.JobTitle()" Returns: |
VIP.Name.JobType | Returns a job type. | "=VIP.Name.JobType()" Returns: |
VIP.Name.LastName | Returns a last name. | "=VIP.Name.LastName()" Returns: 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: |
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: |
VIP.Internet.DomainName | Returns an internet domain name. | "=VIP.Internet.DomainName()" Returns: |
VIP.Internet.DomainSuffix | Returns an internet domain name suffix (".com; .net; .org"). | "=VIP.Internet.DomainSuffix()" Returns: |
VIP.Internet.DomainWord | Returns an email address. | "=VIP.Internet.DomainWord()" Returns: |
VIP.Internet.Email | Returns an email address. | "=VIP.Internet.Email()" Returns: |
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: |
VIP.Internet.IP | Returns an internet IP address. | "=VIP.Internet.Ip()" Returns: |
VIP.Internet.IPv6 | Returns an internet IP V6 address. | "=VIP.Internet.Ipv6()" Returns: |
VIP.Internet.Mac | Returns a Mac address. | "=VIP.Internet.Mac()" Returns: |
VIP.Internet.Password | Returns a random internet password. | "=VIP.Internet.Password()" Returns: |
VIP.Internet.PasswordWithDetails | Returns a random internet password of a specified length. | "=VIP.Internet.PasswordWithDetails(6)" Returns: |
VIP.Internet.Protocol | Returns a random internet protocol (http or https). | "=VIP.Internet.Protocol()" Returns: |
VIP.Internet.URL | Returns a random internet URL. | "=VIP.Internet.Url()" Returns: |
VIP.Internet.UserAgent | Returns a random internet UserAgent. | "=VIP.Internet.UserAgent()" Returns: |
VIP.Internet.UserName | Returns a random internet UserName. | "=VIP.Internet.UserName()" Returns: |
VIP.Internet.UserNameWithDetails | Returns a random internet UserName with details. | "=VIP.Internet.WithDetails(“first”, “last”)" Returns: |
VIP.Phone.PhoneNumber | Returns a random phone number, specified by the locale. | "=VIP.Phone.PhoneNumber()" Returns: +910245048269 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: 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: |
VIP.Hacker.Adjective | Returns an abbreviation for a random word. | "=VIP.Hacker.Adjective()" Returns: |
VIP.Hacker.IngVerb | Returns a random '-ing' verb, a present participle. | "=VIP.Hacker.IngVerb()" Returns: |
VIP.Hacker.Noun | Returns a random word which, in this case, is a noun. | "=VIP.Hacker.Noun()" Returns: |
VIP.Hacker.Phrase | Returns a phrase. | "=VIP.Hacker.Phrase()" Returns: |
VIP.Hacker.Verb | Returns a random word which, in this case, is a verb. | "=VIP.Hacker.Verb()" Returns: |
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. |
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. |
VIP.Lorem.Sentence | Returns a single sentence of filler text. | "=VIP.Lorem.Sentence()" Returns: |
VIP.Lorem.Sentences | Returns sentences of filler text, the number of which are specified. | "=VIP.Lorem.Sentences(2)" Returns: |
VIP.Lorem.Slug | Returns a random slug, the portion of the URL that specifies a resource, of length specified. | "=VIP.Lorem.Slug(4)" Returns: |
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. |
VIP.Lorem.Word | Returns a word on random lorem methods. | "=VIP.Lorem.Word()" Returns: |
VIP.Lorem.Words | Returns words on random lorem methods. | "=VIP.Lorem.Words()" Returns: |
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: |
TEST DATA AUTOMATION DATA GENERATION