Import Org Outline or Directory/Sub Directory Info into yED?

Question

I was looking for a tool to quickly create a diagram for a organization or a file structures in our sim.  I am new to this tool (and diagramming terminology).  The following is am Excel file I am trying to import ( originally a tab deliminated file).

MANAGER
    SUPERVISOR 1
        WORKER 1
        WORKER 2
        WORKER 3
    SUPERVISOR 2
        WORKER 4
        WORKER 5
        WORKER 6
    SUPERVISOR 3
        WORKER 7
        WORKER 8
        WORKER 9

I have experimented around with the open dialog, but have not found settings which correctly construct the diagram.  I really appreciate any help.  Thanks in advance.

 

Dennis

Answer 1

It's not possible to use the Excel import for data in this format. I recommend to transform it into yEd's Edge List format instead, in which each line explicitly specifies the source and target node of an edge.

For your example, it would look like this (the ordering of the lines doesn't matter, commas separate table cells):

MANAGER, SUPERVISOR 1
SUPERVISOR 1, WORKER 1
SUPERVISOR 1, WORKER 2
SUPERVISOR 1, WORKER 3
MANAGER, SUPERVISOR 2
SUPERVISOR 2, WORKER 4
...
MANAGER, SUPERVISOR 3
...