Creating multilevel hierarchies in CSV
When working with CSV data, you can define multilevel hierarchies directly in the file.
To create a multilevel hierarchy
Step 1. Choose fields that will be the levels of the hierarchy.
Step 2. For each level, specify the full path to its parent fields using colons.
Example
Here is an example of a Country > City > District hierarchy:
Country, Country:City, Country:City:District, Invoice Date
France, Nice, Port, 8/17/2025
Germany, Munich, Schwabing, 1/5/2025
France, Nice, Port, 9/26/2025
Italy, Naples, Posillipo, 4/8/2025
USA, Los Angeles, Downtown, 5/25/2025
This demo is also available on our CodePen.