You may have existing codeframes in Excel that you wish to import into your project.  codeit allows you to import a codeframe from an Excel file using four alternative formats.  This video and article explains how to use this functionality.



Codeframe Layout options

See below for the layout options available for setting up your codeframes and nets in Excel as referenced in the video guide.  At the bottom of this help guide is an example file containing the required syntax for your reference.

There is no arbitrary limit to the codeframe depth in the formats described below and in the example file as long as the format specified for each layout type is respected.


Layout TypeSyntax Required
Flat

2-column flat layout, with:  
- Net/Code label in Column 1 

- Net indicator ("NET","SUB-NET", "SUB-SUB-NET" etc..) or Code Entry Code in Column 2

Symbols

2-column flat layout, with:
- Net depth "symbol" indicator or Code Entry Code in Column 1. One distinct symbol for each depth level
- Net / Code Label in Column 2

Flat with Depth Column

3-column flat layout, with:

- Numeric Depth/Level indicator in Column 1

- Net/ Code Entry Code in Column 2. This is an optional column. 

- Net/Code Label in Column 3

Indented 

Code followed by Label layout. Hierarchy is interpreted from the indentation. In this layout Net/ Code Entry Codes are optional. Code Entry Codes are generated if not provided. Please refer to the attached Codeframe Import Examples.xlsx for examples of this layout.


Each of the steps and options covered in this video has a tooltip that is shown in the software itself and listed in the Coding & Codeframe Wizard Guide or Codeframe Panel Overview guide. You can also find out more about the coding and codeframe settings that you can change at project level administration and company level settings.