Importing Column Values from MS Excel Files

You can import reference data from MS Excel files into reference tables. First, you need to add columns to a reference table and then import column values from an MS Excel file. For more information on adding columns to reference tables, refer to the Adding Columns to Reference Tables topic.

To import column values from MS Excel files, follow these steps:

  1. In the Workspace pane, click a reference table.

    2. Columns in the reference table appear.

  2. Click .
  3. Click .

    4. The Import Table Data page appears.

  4. Click Choose File and browse and select the XLSX file.
  5. Click .

    6. The Import Table Data page appears.

  6. Double-click the Select Column to Import cell of the required column.

    7. Column names added by you in the previous steps appear as options.

  7. Select the appropriate <Column_Name>.

    8. You can select multiple columns.

  8. Click .

    9. The column values are imported from the XLSX file.