ID/TO columns, a small import step
asks which column is the name, which is the manager, and
(optionally) which is the employee number. Nothing is guessed: anyone
whose manager can't be matched is listed by name in the Chart health panel.+N (people hidden below).#detached:<manager ID> carries the
branch memory; plain #detached means no memory) so branches
survive export and re-import intact.? in the heading and
keeps everything else exactly where it is, so every box on the chart
stays the same shape.VACANT column marks empty posts —
x, yes, ja, true or
1 means vacant; anything else means filled. The column is part
of every chart automatically and travels with your CSV.SOURCE ("Finance chart, merged
2 Aug 2026") and SOURCE_ID (their number in the source file) —
provenance for an auditor, visible in the editor.#detached) and everyone lands in Detached in one act — no
questions, duplicates skipped — ready to attach or to fill vacant
posts.ID: unique number or code for each person/position
(e.g. 101 or E001).TO: the ID they report to. The top person has
TO equal to their own ID, or empty.VACANT: reserved — x/yes/ja/true/1
marks the row as an empty post (see Vacant posts above).COUNTER is calculated automatically — total positions in each branch.
Semicolon-separated files (non-US Excel) work too. Detached people are stored
with #detached in the TO column (see the Detached notes above) —
leave those rows alone and they round-trip perfectly.
After every import the panel in the top-right lists anything that needs attention: people not shown (with the reason — missing manager, circular reporting line), skipped rows, and import reconciliation ("Imported 41 of 43 source rows"). An organogram used for an audit should show a clean bill of health.