Welcome to yEd Q&A!
Here you can ask questions and receive answers from other members of the community and yEd developers. And you can tell us your most wanted feature requests.


Import hierarchical tree from excel file (more than two columns)

+2 votes
I have some excel files with hierarchical nodes.

Column A represents the top, column B the second "layer", column C the third...
All rows represent Edges, so an edge is for example from A1 to B1 and from B1 to C1 ...

Now I tried to import that, but it doesn't work out.

The only way I found is to copy column B and C and paste it in column A and B (in the free rows) and then copy column C and D and paste it in column A and B (in the free rows)... Then I could import column A and B as an edge list.

Is there an easier way which doesn't destroy the excel list?
in Help by

1 Answer

0 votes

yEd's Excel Import indeed requires the spreadsheet data to be organized in a specific way. Please see Import of Excel Files in the yEd Manual for more information. However, two columns with each row defining an edge will work - this is essentially what the very first example in section Edge List is all about.

by [yWorks] (161k points)
Legal Disclosure | Privacy Policy