Importing data from excel

Question

Hello,

 

I am new to the yEd and so far I really like the program. But I have one issue. 

I have a very large tree structure in excel in the form of text which per 'tree level' is shifted one colomn to the right.  The issue is that this is a very large data set (1250 items devided over about 21 levels of dept) Now I already found that this cannot be imported to yEd directly. My quenstion is: is there some way to import this data, maybe using a transformation step in between?

as an example a structure from excel could look like this:

 

top level
	some level below top level
		sub level1
		sub level2
			subsublevel1
	some other level below the top
		sub level 0
	some level below top level3
		sub level3
		sub level4
			subsublevel2
				subsubsublevel
	some other level below the top
		sub level 0

 

 

Kind regards,

 

Quinten 

Answer 1

Well, yes - if the "transformation step" is reorganizing your data.

With unique names (which are necessary), your example structure corresponds to
n0
      n1.1
            n2.1
            n2.2
                  n3.1
      n1.2
            n2.3
      n1.3
            n2.4
            n2.5
                  n3.2
                        n4
      n1.4
            n2.6
This data has to be reorganized into two columns as follows:

The first row is optional (depending on whether or not you have "Property Names in First Row" enabled). The order of the remaining rows does not matter. With "Layout" set to "Hierarchical", this data will result in the following diagram:

 

Edit: Removed duplicate row.

Comments

Thomas thank you. I am going to try this. I will have to write a script to transform my data into such a table but I think I'll be able to do this.