Knowledge Skill Data Template Requirements

To create a knowledge skill, you must upload your data using one of provided templates. You can download the necessary template from the developer portal when you create your knowledge skill. This topic lists the requirements that apply to all templates, as well as requirements that are specific to each template.

For general information about knowledge skills, see Understand Knowledge Skills.

General requirements

The following requirements apply to all templates:

  • Save your file in CSV format.
  • Include the required column(s). Each template has at least one required column, as described later in this topic.
  • Do not include spaces in the CSV column headers. Instead, use underscores (that is, "_").
  • Do not include capital letters in the CSV column headers.
  • Be consistent in the way you refer to the same item. For example, if two users in a People Directory are from the United States, do not set the "country" field to "United States" for one user and "USA" for another user.

Although not required, you can also:

  • Remove unneeded columns.
  • Reorder columns.

Template-specific requirements

In addition to the general requirements listed previously, your data must meet the following requirements for the specific template that you use:

Glossary

The Glossary template is used to provide term-definition pairs so that the user can ask your skill to define terms.

The following list shows the requirements for the columns in your data spreadsheet file for the Glossary template:

term

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
bar raiser

leadership principles

Return to Glossary.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting Notes Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
b.r.^br amazon

l.p.^amazon l.p.s^amazon leadership principles^l.p.^l.p.s^lp^lps^amazon lps

Return to Glossary.

definition

Required.

Data TypeText
Max Length/Value65,535 characters
Accepts List Values No
Formatting Notes N/A
Example
Values
An interviewer at Amazon who is brought into hiring loops to be an objective third party. By bringing in somebody who's not associated with the team, the best long-term hiring decisions are made to ensure the company is always serving, surprising, and innovating for customers. The role of the Bar Raiser is to be a steward of Amazon's 14 Leadership Principles.

A set of standards ingrained in Amazon's culture. There are fourteen, including: Customer Obsession, Ownership, Invent and Simplify, Are Right, A Lot, Learn and Be Curious, Hire and Develop the Best, Insist on the Highest Standards, Think Big, Bias for Action, Frugality, Earn Trust, Dive Deep, Have Backbone; Disagree and Commit, and Deliver Results.

Return to Glossary.

How To

The following list shows the requirements for the columns in your data spreadsheet file for the How To template:

action_name

Required.

Data TypeText
Max Length/Value65,535 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Log on to the WiFi
book a conference room

Return to How-To.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List ValuesYes
Formatting NotesSeparate list values with the ^ symbol. Trailing ^ values are removed on import.
Example
Values
log on to the internet^sign on to the WiFi^sign on the internet^get online^sign online^log on to the web^get on the web^access the internet^get on the WiFi^get on the internet^

reserve a room^book a room^reserve a conference room^book a meeting room^reserve a meeting room^book a meeting^reserve a meeting^

Return to How-To.

instructions

Required.

Data TypeText
Max Length/Value65,535 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
To sign on to the WiFi, choose the network NETWORK and enter the password PASSWORD.

To reserve a meeting room, visit meetings.corporation.example.com while on the corporate WiFi network.

Return to How-To.

People Directory

The following list shows the requirements for the columns in your data spreadsheet file for the People Directory template:

person_unique_id

Required. Each value must be unique.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
12345
54321

Return to People Directory.

full_name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Megan Manager
Sam Subordinate

Return to People Directory.

first_name

Optional.

Data TypeText
Max Length/Value75 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Megan
Sam

Return to People Directory.

last_name

Optional.

Data TypeText
Max Length/Value75 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Manager

Subordinate

Return to People Directory.

alternate_names

Optional.

Data TypeText
Max Length/Value250 characters. Each individual list value must be 200 characters or less.
Accepts List ValuesYes
Formatting NotesSeparate list values with the ^ symbol. Trailing ^ values are removed on import.
Example
Values
Meg Manager

Samuel Subordinate^Sammy Subordinate

Return to People Directory.

user_name

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List Values
Formatting NotesN/A
Example
Values
managerm
subordinates

Return to People Directory.

description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Megan Manager is the founder and CEO of XYZ Corp. She has been with XYZ Corp. since September 2015. Her extension is 4566.

Sam Subordinate is an Operations Analyst. He has been with XYZ Corp. since October 2015. His extension is 4568.

Return to People Directory.

start_date

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List ValuesNo
Formatting NotesAccepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example
Values
2015-09-15
2015-10-15 00:00:00

Return to People Directory.

end_date

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List ValuesNo
Formatting NotesAccepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example
Values
2019-09-15
2019-10-15 00:00:00

Return to People Directory.

tenure

Optional.

Data TypeInteger
Max Length/Value65,535
Accepts List ValuesNo
Formatting NotesUnits are days. Decimal values are not accepted.
Example
Values
1115
2085

Return to People Directory.

seniority

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
executive
non-executive

Return to People Directory.

contact_information

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
You can reach Megan Manager by contacting her assistant, Alex Assistant. Alex Assistant is available via phone at (123)555-4567 and via email at assistanta@example.com.

Sam Subordinate is currently out of the office. For urgent messages, please call or email Jane Junior.

Return to People Directory.

email

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
managerm@example.com

subordinates@example.com

Return to People Directory.

phone_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123)555-1230
123-555-1232

Return to People Directory.

phone_extension

Optional.

Data TypeText
Max Length/Value25 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
4566
ext. 4568

Return to People Directory.

cell_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123)555-1230
123-555-1232

Return to People Directory.

pager_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Megan Manager's pager number is (123) 321-6543. Megan's pager email is page-managerm@example.com.

Sam Subordinate is currently out of the office. For urgent issues, please page Jane Junior.

Return to People Directory.

pager_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123)789-1230
123-789-1232

Return to People Directory.

manager_email

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
managerm@example.com
managerm@example.com

Return to People Directory.

manager_phone_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123)789-1230
123-789-1232

Return to People Directory.

assistant_email

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
assistanta@example.com
assistant@example.com

Return to People Directory.

assistant_phone_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123)789-1230
123-789-1232

Return to People Directory.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Megan Manager is located on the seventh floor of the Headquarters building.

Sam Subordinate sits in seat 3 on the seventh floor of the Headquarters building in New York.

Return to People Directory.

continent

Optional.

Data TypeText
Max Length/Value25 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
North America

Return to People Directory.

country

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
United States

Return to People Directory.

state

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
California

Return to People Directory.

city

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Santa Barbara

Return to People Directory.

zipcode

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
10019

Return to People Directory.

campus

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
east campus
west campus

Return to People Directory.

building

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
headquarters
California branch

Return to People Directory.

floor

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesNo unit is included, so use your preferred units in your data.
Example
Values
ground floor
second floor

Return to People Directory.

room

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesBecause we have not added a unit, use your preferred units in your data.
Example
Values
6A
engineering pod

Return to People Directory.

seat

Optional.

Data TypeText
Max Length/Value25 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
one
three

Return to People Directory.

address

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
123 7th Avenue

123 Operations Way

Return to People Directory.

role_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Megan Manager is the founder and CEO of XYZ Corp. Megan is on the Leadership team and is the company's only manager.

Sam Subordinate is a full-time Operations Analyst.

Return to People Directory.

status

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
full-time
part-time

Return to People Directory.

job_type

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
manager
Individual contributor

Return to People Directory.

job_title

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Founder and CEO
Operations Analyst

Return to People Directory.

job_category

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Executive
Analyst

Return to People Directory.

team

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Leadership
Operations

Return to People Directory.

department

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Senior Management
Team Engineering

Return to People Directory.

organization

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Example Corp.
Legal

Return to People Directory.

specialty

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesYes
Formatting NotesSeparate list values with the ^ symbol.
Example
Values
databases^analytics

marketing^account management

Return to People Directory.

vacation_day_balance

Optional.

Data TypeNumber
Max Length/Value99,999
Accepts List ValuesNo
Formatting NotesUnits are days. Decimal values are permitted.
Example
Values
10
3.5

Return to People Directory.

manager_name

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Megan Manager

Return to People Directory.

manager_unique_id

Optional. However, if present, the value must match a person_unique_id value.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
12345

Return to People Directory.

assistant_name

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Alex Assistant

Return to People Directory.

assistant_unique_id

Optional. However, if present, the value must match a person_unique_id value.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
56789

Return to People Directory.

direct_report_names

Optional.

Data TypeText
Max Length/Value65,535 characters
Accepts List ValuesYes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
Alex Assistant^Sam Subordinate^Jane Junior

New Nancy

Return to People Directory.

direct_report_unique_ids

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List ValuesYes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
56789^54321^98765
65734

Return to People Directory.

number_of_direct_reports

Optional.

Data TypeInteger
Max Length/Value4,294,967,295
Accepts List ValuesNo
Formatting NotesUnits are employees. Decimal values are not permitted.
Example
Values
3
1

Return to People Directory.

number_of_indirect_reports

Optional.

Data TypeInteger
Max Length/Value4,294,967,295
Accepts List ValuesNo
Formatting NotesUnits are employees. Decimal values are not permitted.
Example
Values
4
1

Return to People Directory.

date_of_birth

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List ValuesNo
Formatting NotesAccepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS.
Example
Values
9/25/1978
12/28/1987

Return to People Directory.

education_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Megan Manager received her B.A. from the University of Delaware and her M.B.A. from the Wharton School of the University of Pennsylvania.

Return to People Directory.

Company Locations

The following list shows the requirements for the columns in your data spreadsheet file for the Company Locations template:

name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values N/A
Formatting NotesEach value must be unique.
Example
Values
Headquarters

Warehouse One

Return to Company Locations.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting Notes Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
HQ^

Fulfillment Center^

Return to Company Locations.

building_categories

Optional.

Data TypeText
Max Length/Value250 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting Notes Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
corporate^

distribution^

Return to Company Locations.

building_type

Optional.

Data TypeText
Max Length/Value250 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting Notes Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
corporate office

distribution center^distribution facility

Return to Company Locations.

city

Optional.

Data TypeText
Max Length/Value 50 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
Seattle

Bellevue

Return to Company Locations.

contact_information

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
To contact the reception of the Headquarters, call (123) 555-0100.

To contact the reception of the Warehouse, call (123) 555-0101.

Return to Company Locations.

country

Optional.

Data TypeText
Max Length/Value 50 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the United States

Return to Company Locations.

description

Optional.

Data TypeText
Max Length/Value 500 characters
Accepts List Values No
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
The Headquarters is the largest AnyCompany location and is home to 300 employees. Teams that work here include Engineering, Product, Sales, and Operations.

Warehouse One is the largest distribution center and is home to 1000 Operations employees.

Return to Company Locations.

fax_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123) 555-0199

(123) 555-0198

Return to Company Locations.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
Headquarters is located at 123 Main Street in Any Town, Washington.

Warehouse One is located at 123 Any Street in Any Town, Washington.

Return to Company Locations.

phone_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123) 555-0100

(123) 555-0101

Return to Company Locations.

state

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
Washington

California

Return to Company Locations.

zipcode

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
98121

98402

Return to Company Locations.

Property Information

The following list shows the requirements for the columns in your data spreadsheet file for the Property Information template:

name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesEach value must be unique.
Example
Values
the pool
room 301

Return to Property Information.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting Notes Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
drink^alcohol

exercise^workout^yoga^run

Return to Property Information.

building

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the hotel california
the cottages

Return to Property Information.

business_hours

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesEach value must be unique.
Example
Values
open 24/7
open weekdays 6am to 10pm

Return to Property Information.

check_out_time

Optional.

Data TypeText
Max Length/Value250 characters
Accepts List Values No
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
The standard checkout time for all rooms is 10am. To request a late check out, call the front desk at extension 0-1-2.

Checkout time is 10am.

Return to Property Information.

contact_information

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
To make a reservation or order room service, call 5-6-7.

To call the concierge, dial 0-1-2 or email them at front_desk@hotelcalifornia.example.com.

Return to Property Information.

description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
The front desk is available to assist you 24/7. If you have any questions or need assistance, dial 0-1-2.

Room 30 offers numerous conveniences like refrigerators and microwaves, free WiFi, flat-screen TVs with cable channels, premium bedding, coffee/tea makers, and free newspapers.

Return to Property Information.

directions

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
To get to the front desk, take the elevator to the lobby and walk to the main entrance.

Bathrooms can be found on every floor next to the elevator.

Return to Property Information.

email

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
front_desk@example.com

workout_center@example.com

Return to Property Information.

fax_number

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesStandard telephone number formats
Example
Values
(123) 555-0199
(123) 555-0198

Return to Property Information.

floor

Optional.

Data TypeText
Max Length/Value50 characters
Accepts List ValuesNo
Formatting NotesNo unit is included, so use your preferred units in your data.
Example
Values
the 2nd floor
the roof

Return to Property Information.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
The restaurant is located in the lobby, next to the bar.

Ice machines can be found on every floor next to the elevator.

Return to Property Information.

wifi_instructions

Optional.

Data TypeText
Max Length/Value250 characters
Accepts List ValuesNo
Formatting NotesThis field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example
Values
To connect to the WiFi, use the network 'building-guest' and enter the password 'buildingguest,' with no spaces or capital letters.

Use the network 'anycompany' and enter the password 'anycompanypw,' with no spaces or capital letters.

Return to Property Information.

wifi_network

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
building-guest
anycompany

Return to Property Information.

wifi_password

Optional.

Data TypeText
Max Length/Value100 characters
Accepts List ValuesNo
Formatting NotesN/A
Example
Values
'buildingguest', with no spaces or capital letters

anycompany, with no spaces or capital letters

Return to Property Information.

In-Store Assistant

The following list shows the requirements for the columns in your data spreadsheet file for the In-Store Assistant template:

name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
Midnight Moon Vegan Cheese Alternative

Atlantic Salmon

Return to In-Store Assistant.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
Midnight Moon Vegan Cheese

Atlantic Salmon^Farm-Raised Salmon^Farm Salmon

Return to In-Store Assistant.

description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
Who needs cheese when you have Midnight Moon's vegan cheese alternative? It takes just like the real thing - but vegan!

Our Atlantic Salmon has a mild flavor. It has a medium-to-firm texture with large flakes.

Return to In-Store Assistant.

features

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
organic^vegan

farm raised^healthy

Return to In-Store Assistant.

shelf

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
top shelf

middle shelf

Return to In-Store Assistant.

status

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
in-stock^discounted

in-stock

Return to In-Store Assistant.

product_categories

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
dairy^cheese^snack

fish^seafood^salmon

Return to In-Store Assistant.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
The Midnight Moon Vegan Cheese Alternative is located in aisle twelve.

You can find all seafood at the counter behind aisle one.

Return to In-Store Assistant.

release_date

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List Values No
Formatting NotesAccepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example
Values
2015-09-15
2015-10-15 00:00:00

Return to In-Store Assistant.

rating

Optional.

Data TypeNumber
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
3.7
4

Return to In-Store Assistant.

brand

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
Midnight Moon

Fresh Fish

Return to In-Store Assistant.

price

Optional.

Data TypeNumber
Max Length/Value 9,999,999,999
Accepts List Values No
Formatting Notes U.S. dollars
No currency symbol, such as "$."
Can use decimals.
Example
Values
20
4.50

Return to In-Store Assistant.

floor

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
first floor

Return to In-Store Assistant.

aisle

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
aisle 12

aisle 1

Return to In-Store Assistant.

Supply Room

The following list shows the requirements for the columns in your data spreadsheet file for the Supply Room template:

name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
printer paper

power strips

Return to Supply Room.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
printing paper^white paper

electrical socket^plugs

Return to Supply Room.

associated_task

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
printing

battery charging^re-charging

Return to Supply Room.

item_categories

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
paper^copy paper

outlet^wall charger

Return to Supply Room.

description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
The office has printer paper that is 8.5'' by 11''.

The office has power strips with 6-outlets and can be used when you need more power receptacles than are available. These power strips offer surge protection.

Return to Supply Room.

features

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
print^printer

electrical

Return to Supply Room.

instructions

Optional.

Data TypeText
Max Length/Value65,535 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
To re-stock the printer paper, open the paper tray door. Pull out the paper tray and load a stack of plain paper into the tray.

The power strips can be plugged into any wall socket. Make sure that the cord is not in a position where people can easily trip over it.

Return to Supply Room.

room

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the supply room

the storage room

Return to Supply Room.

shelf

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the green shelf

the blue shelf

Return to Supply Room.

storage_area

Optional.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the cabinet

the orange bin

Return to Supply Room.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
The printer paper is located on the green shelf in the cabinet in the supply room. Reach out to IT if the office is out of stock.

The power strips are located in the orange bin on the blue shelf in the storage room. Reach out to IT if you have trouble finding it.

Return to Supply Room.

Events

The following list shows the requirements for the columns in your data spreadsheet file for the Events template:

name

Required.

Data TypeText
Max Length/Value150 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
the Holiday Party

the Team Offsite

Return to Events.

alternate_names

Optional.

Data TypeText
Max Length/Value65,535 characters. Each individual list value must be 200 characters or less.
Accepts List ValuesYes
Formatting NotesSeparate list values with the ^ symbol. Trailing ^ values are removed on import.
Example
Values
Christmas Party^Holiday Party^Office Holiday Party^Office Christmas Party

Off site^Team Off-site^Off-site^Team Off Site^Q1 Team Offsite

Return to Events.

description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
Join us for our upcoming Holiday Party on December 21st, 2020! There will be free fruit punch and pie.

Our upcoming quarterly off-site is from January 8th to January 9th and will involve a review of team goals for the year 2021.

Return to Events.

event_categories

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
celebratory

offsite^off-site^off site

Return to Events.

event_type

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
Office Party

Offsite^Off site^Team Event

Return to Events.

start_date

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List Values No
Formatting Notes Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default timezone is UTC.
Example
Values
12/21/2020 19:00
1/8/2021 09:00

Return to Events.

end_date

Optional.

Data TypeDate
Max Length/ValueN/A
Accepts List Values No
Formatting Notes Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default timezone is UTC.
Example
Values
12/22/2020
1/9/2021 17:00

Return to Events.

location_description

Optional.

Data TypeText
Max Length/Value500 characters
Accepts List Values No
Formatting NotesN/A
Example
Values
The 2020 Holiday Party will take place at AnyCompany Headquarters.

The next off-site will take place at AnyCompany's Expansion Office.

Return to Events.

venue

Optional.

Data TypeText
Max Length/Value500 characters. Each individual list value must be 200 characters or less.
Accepts List Values Yes
Formatting NotesSeparate list items with ^ symbol. Trailing ^ values are removed on import.
Example
Values
AnyCompany Headquarters

AnyCompany's Expansion Office

Return to Events.