logo
logo

Import option lists using Excel

You can import option lists using Excel. A single Excel file can hold several option lists.

Important

The name of the Excel file must be OptionLists, with no space between Option and Lists.

At a minimum, the Excel spreadsheet must contain the following columns:

  • Name
  • Identifier
  • Label

You import option lists using the Creation component.

Import an Excel file using the Creation component

To create a page or subpage:

  1. On the menu bar, click Manage .

  2. On the Manage page, click Pages.

  3. In the Pages portal, do one of the following:

    • To create a page, click + Page.
    • To create a subpage, in the list of pages, click More actions and select + Add subpage.
  4. In the Page dialog box, in the Name field, enter a name for the page or subpage.

  5. From the Page type list, select Blank page.

  6. From the Master layout list, select the layout you want to use.

  7. Click Add.

  8. On the page or subpage, in the Main Zone, click Add component and, in the Add component dialog box, select the Creation component.

  9. Enter a name for the new component and turn the Visible switch to On.

  10. Click Add.

To modify the Creation component:

  1. On the page or subpage, on the Creation component, click More actions and select Edit.

  2. On the Creation component detail page, turn the Upload files switch to On.

  3. Turn the Import Excel switch to On.

  4. Click Save and close.

  5. To view the page or subpage, on the Layout tab, click View Page.

  6. In the page preview, click + Add and select Import Excel.

  7. In the Import Excel dialog box, click Select files.

  8. Select the file you want to import and click Open.

  9. When the file is imported, click Done.

To verify that the option lists was imported successfully:

  1. On the Manage page, click Option lists.

  2. Search for the imported file and select it.

  3. Click the option list to open it and verify that the import was successful.

Spreadsheet ValuesOption list nameOption list valuesIdentifier and label

Import multilingual labels

You can include multiple languages in the option list import. In the following example, the Excel file contains two language columns: Label#en-US and Label#ga-IE.

The label used for each column is not the Name, Culture or Label name that is provided during the creation of a portal language. It is the auto-generated Path value that is generated from the Culture field. To see it, from the Manage menu, select Portal languages and next to the language of interest, click Quick edit.

You can also see the path value in the option list dialog box. From the Manage menu, select Option lists and click an option list.

Can we improve this article ? Provide feedback