Setting hierarchy with color in Excel
When you import items from an Excel worksheet, you can use cell color to determine hierarchy of imported items. This method allows only one tier of hierarchy and doesn't differentiate between colors.
In your Excel worksheet, you can select the cell you want to use as a parent container and use a color to indicate hierarchy.
![Example Excel worksheet shows color cell as parent item, indicating hierarchy.](../../../../image/166db6274c7b1a.png)
When you import the document, the Data Import Wizard prompts you to select the column that will determine hierarchy. In this example, Name column is selected.
![Example of using colored cells for hierarchy in Data Import Wizard.](../../../../image/166db6274cf5c9.png)
The resulting import shows the colored cells as parent containers.
![Example of resulting import using colored cells for hierarchy.](../../../../image/166db6274d5f76.png)