Importing Attribute Types and Attribute Values is a quick way to populate the attributes necessary to improve the website user experience in Optimizely \<\<product-nam. For more information on the benefits of Attributes, review the Overview of Attribute Management article. This article explains how to organize and use an Excel spreadsheet to import Attribute data. Even though an Import Template is provided within the Admin Console, this template is intended for importing products and related data. Because of this, using the full Import Template to import Attributes can be cumbersome. Therefore, Insite recommends beginning with a blank Excel spreadsheet or an export of the existing Product list. There are four steps to import Attributes:

1. Create or Isolate the Required Columns

2. Create the Attribute Type Columns

3. Populate the Attribute Values

4. Assign the Attribute Types to Categories

## Create or isolate the required columns

The first three columns of the template are **Product Number**, **Product Title**, and **URL Segment**, all of which are required. Capture this data in one of two ways: go to the **Product** list and copy data, then paste it into the blank spreadsheet; or export the **Product** list, including only the **Product Number**, **Product Title**, and the **URL Segment** columns. Use the following steps to create or isolate the required columns:

### Start from a blank Excel file

1. Open Excel and create a blank workbook

2. Create the following column headings

   • **Column 1** – Product Number

   • **Column 2** – Product Title.

   • **Column 3** – URL Segment

### Start from an exported product list

1. Export the Product list using **Export** on the **Product** page.

2. Select only the **Product Number**, **Product Title**, and **URL Segment** columns.

3. Click **Export,** then click **Download File.**

4. Open the exported file, and ensure the following columns exist:

   1. **Column 1** – Product Number

   2. **Column 2** – Product Title.

   3. **Column 3** – URL Segment

5. Delete the **Modified On** and **Id** columns.

## Create the Attribute Type Columns

The next column headings are the Attribute Types. The proper syntax for these columns is Attribute.\[AttributeTypeName\]. For example, if selling office supplies, a column heading may be **Attribute.Size** or **Attribute.OrganizerType**.

1. Attribute.\[AttributeTypeName\]

2. Attribute.\[AttributeTypeName\]

3. Attribute.\[AttributeTypeName\]

4. and so on

Continue adding the necessary Attribute Types.

## Populate the Attribute Values

After the column headings have been created, go back and fill in the Attribute Values for each Product record.

📘

Note

If the Attribute Value contains a comma, the Attribute Value and the comma must be enclosed with quotation marks. See the example below for a 20V Battery Pack.

Return to the Admin Console, and import the updated spreadsheet under **Catalog** \> **Products**. Ensure **Update Existing Records** is checked at the bottom of the screen.

## Assign the attribute types to the categories

After the Attribute Types and Values have been imported successfully, they need to be assigned to the proper Categories. Assigning the Attributes to the Categories is what allows the website to display faceted filtering on the Category page.

This can be accomplished manually, but is most frequently done via an integration job.

### Assign the attribute types manually

1. Go to **Admin Console** \> **Catalog** \> **Categories**.

2. Click **Edit** for the desired Category.

3. Click the **Attributes** finger tab.

4. Click **Add Category Attribute**.

5. The correct **Category** should display in the drop-down.

6. From the **Attribute Type** drop-down menu, select the desired Attribute Type.

7. Use the **Yes/No** toggle to indicate if the Attribute Type should be Active on the site.

8. In the **Sort Order** field, enter the value to determine the positioning of the Attribute.

9. Click **Save,** or click **Save and Add New** to continue making additional assignments.

10. Click **Back** if additional Categories need Attribute assignments.

11. To see the Attributes on the website, rebuild the product search index: **Admin Console** \> **Marketing** \> **Search** \> **Indexing**. Click **Full Rebuild** for Category Search Index.