Custom Spreadsheet

To import a Local Code System from a custom spreadsheet go to:

📥 File > Import > Snow Owl > Local Code System from custom spreadsheet.

📥 The wizard prompts for the Excel file to be imported as well as the Excel sheet to be selected from the imported Excel file. The Code system short name and Code system name fields are automatically populated based on the name of the selected sheet. This data can be overwritten to be changed to the required names. Additionally, the following fields need to be specified:

  • Code system OID: Local Code System metadata

  • Concept ID columns: Excel column containing the IDs of the codes

  • Concept Term column: Excel column containing the terms of the codes

After the import, the wizard closes and the imported content will be displayed in the Local Code Systems View.