Preserve XML parent-child relationships in CSV

Why generated identifiers are needed

XML expresses relationships through nesting. CSV has no nesting, so exporting a parent and its repeated children into separate files requires a join key.

orders.csv                 items.csv
_row_id,order_number      _row_id,_parent_row_id,sku
1,1001                    1,1,BK-101
                          2,1,NT-204

In this example, each item points back to its order through _parent_row_id. The relationship remains explicit without repeating all order values in every item row.

Using the related CSV files

You can join the files in a database, data-processing script, or tools such as Excel and Power BI. Keep the generated identifier columns when you need to reconstruct the hierarchy; remove them only when the relationship is no longer relevant.

The preview shows detected relationships before conversion so you can verify whether the proposed tables match your intended analysis.

Preview your relationships