Create a Basic MS Excel Spreadsheet Structure

Working with CSV Text Files to Upload Data : Creating a CSV Text File from an MS Excel Spreadsheet : Create a Basic MS Excel Spreadsheet Structure

Create a Basic MS Excel Spreadsheet Structure

1

Open MS Excel.

2

From the File menu, select New.

3

Select Blank workbook. A blank worksheet displays.

4

Create a header row by typing attribute names into row 1 of the spreadsheet. The header row must contain the mandatory fields SELCODE, PRODUCT, ITEM_NUMBER, and ITEM_NUMBER_TYPE.

For a complete list of attribute names, please refer to the OpenText Active Catalogue Attributes Guide.

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF