Organisational chart

Question

I am trying to replicate this graphic generated by Google Sheets in PlantUML. The input is CSV like:

Bread,Products
Jam,Products
Products,Home
Privacy Policy,About Us
Sustainability statement,About Us
About Us,Home

Answer 1

Hello H,

For that, you can use WBS, as:

@startwbs
* Home
** Products
*** Bread
*** Jam
** About Us
*** Privacy Policy
*** Sustainability statement
@endwbs

If that can help,
Regards,
Th.

Comments

Thank you Th, though how do I programatically get the CSV into that format you proposed? Ideally plantuml could take in the CSV.

Answer 2

For a full Excel way to format your data:

First add a few columns:

ROOT        -> =ISBLANK([@Parent])
DEPTH       -> =IF([@ROOT],   0, VLOOKUP([@Parent], Table1, 4, FALSE) + 1) 
//                                                          ^ the DEPTH column index
PARENT_PATH -> =IF([@ROOT],  "", VLOOKUP([@Parent], Table1, 6, FALSE))
//                                                          ^ the PATH column index
PATH        -> =IF([@ROOT], "/", CONCAT([@PARENT_PATH],[@Item],"/"))
PLANTUML    -> =CONCAT(REPT("*",[@DEPTH]+1), " ", [@Item])

And then, sort the table by the PATH column

Item	Parent	IS_ROOT	DEPTH	PARENT_PATH	PATH	PLANTUML
Home		TRUE	0		/	* Home
About Us	Home	FALSE	1	/	/About Us/	** About Us
Privacy Policy	About Us	FALSE	2	/About Us/	/About Us/Privacy Policy/	*** Privacy Policy
Sustainability statement	About Us	FALSE	2	/About Us/	/About Us/Sustainability statement/	*** Sustainability statement
Products	Home	FALSE	1	/	/Products/	** Products
Bread	Products	FALSE	2	/Products/	/Products/Bread/	*** Bread
Jam	Products	FALSE	2	/Products/	/Products/Jam/	*** Jam

Then you can copy-paste the PLANTUML column directly for plantuml usage.