Sample Data
+
Google Sheets
+
Microsoft Excel

Sample data in your spreadsheet

Import live, refreshable sample data in Microsoft Excel and Google Sheets.

Import sample data in your spreadsheet

Sample data, also called mock data or fake data, is used often used in place of real data for testing. Using sample data is also a great way to avoid privacy issues during presentation and demonstrations. This sample data spreadsheet integration for Google Sheets and Microsoft Excel enables you to generate fake data on command and is generated using the Python Faker library. This add-on will enable you to integrate on-demand, refreshable mock data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Import sample bank data, including account number (BBAN) and international account number (IBAN)
  • Import sample company data, including name, suffix and catchphrase.
  • Create sample contact data, including address, email, phone and website.
  • Create sample credential data, including email, username, and password.
  • Import sample credit card data, including credit card provider, number, expiration date and security code.
  • Import sample ID data, including unique identifier and slug.
  • Create sample person data, including first name, last name, prefix and suffix.
  • Create fake profile information, including id, email, username, password, name, address, phone number and homepage.

Click here to learn more about the specific syntax for each of the Sample Data spreadsheet functions.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the sample data function collection with Microsoft Excel or Google Sheets.

Need Help?

Have questions? Need help with installation? Need other sample data functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Sample Data Bank

Returns a list of fake bank information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-bank", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-bank", 1, "iban")
=FLEX("YOUR_TEAM_NAME/sampledata-bank", 10, "bban, iban")

Notes

The following properties are allowed:

  • iban: International Bank Account Number; this number uniquely identifies a bank internationally
  • bban: Basic Bank Account Number; this number identifies a bank within a specific country

Sample Data Company

Returns a list of fake company information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-company", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-company", 1, "company")
=FLEX("YOUR_TEAM_NAME/sampledata-company", 10, "company, company_catchphrase")

Notes

The following properties are allowed:

  • company: The name of a company
  • company_suffix: The suffix for the company
  • company_catchphrase: The catch phrase for the company

Sample Data Contact

Returns a list of fake contact information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-contact", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-contact", 1, "street1, city, state, zip")
=FLEX("YOUR_TEAM_NAME/sampledata-contact", 10, "city, state, zip")

Notes

The following properties are allowed:

  • street1: The primary street address for the contact info
  • street2: The secondary street address for the contact info, such as a unit number
  • city: The city for for the address contact info
  • state: The state for the address contact info
  • zip: The zipcode for the address contact info
  • email: A contact email address
  • phone: A contact phone number
  • homepage: A contact website

Sample Data Credential

Returns a list of fake credential information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-credential", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-credential", 1, "email, username")
=FLEX("YOUR_TEAM_NAME/sampledata-credential", 10, "email")

Notes

The following properties are allowed:

  • email: An email address
  • username: A username
  • password: A password

Sample Data Credit Card

Returns a list of fake credit card information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-creditcard", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-creditcard", 1, "cc_provider, cc_number, cc_expire")
=FLEX("YOUR_TEAM_NAME/sampledata-creditcard", 10, "cc_number")

Notes

The following properties are allowed:

  • cc_provider: A credit card provider
  • cc_number: A credit card number
  • cc_expire: A credit card expiration date
  • cc_code: A credit card security code

Sample Data Identifier

Returns a list of fake identifier information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-identifier", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-identifier", 1, "uuid")
=FLEX("YOUR_TEAM_NAME/sampledata-identifier", 10, "uuid")

Notes

The following properties are allowed:

  • uuid: A unique identifier
  • slug: A slug

Sample Data Person

Returns a list of fake person data

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-person", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-person", 1, "name")
=FLEX("YOUR_TEAM_NAME/sampledata-person", 10, "name_prefix, first_name, last_name, name_suffix")

Notes

The following properties are allowed:

  • name: A name for a person
  • name_prefix: A name prefix for a person
  • name_suffix: A name suffix for a person
  • first_name: A first name for a person
  • last_name: A last name for a person

Sample Data Profile

Returns a list of fake profile information

Syntax

=FLEX("YOUR_TEAM_NAME/sampledata-profile", count, [properties])

Parameters

Property Type Description Required
count integer Number of fake records to return, between 0 and 10000 true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/sampledata-profile", 1, "name, email")
=FLEX("YOUR_TEAM_NAME/sampledata-profile", 10, "name, email, phone, homepage")

Notes

The following properties are allowed:

  • uuid: The unique identifier for the profile
  • slug: The slug for the profile
  • email: The email address for the profile
  • username: The username for the profile
  • password: The password for the profile
  • first_name: The first name for the profile
  • last_name: The last name for the profile
  • name: The name for the profile
  • street1: The primary street address for the profile
  • street2: The secondary street address for the profile
  • city: The city of the address for the profile
  • state: The state of the address for the profile
  • zip: The zipcode of the address for the profile
  • phone: The phone number for the profile
  • homepage: The homepage for the profile

Use Sample Data in your spreadsheet now!