Code Lists

Colectica is able to import multiple code lists from an Excel (*.xlsx) file.

  1. Navigate to a ResourcePackage to which you would like to add the new code lists.

  2. Click the Import Code Lists button on the ribbon.

  3. Select an Excel file that contains your code lists.

  4. The code lists will be added to the ResourcePackage.

Excel File Format

The Excel file should be in the following format:

  • Each sheet contains one code list

  • The first row of each sheet is a header row. The headers may be anything you like.

  • The first column is mapped to the code’s value.

  • The second column is mapped to the code’s category label.

  • The third column, if present, is mapped to the code’s category description.