Forum Discussion

Copper Contributor

Sep 02, 2022

Using Visio Brainstorming data in Excel

Hello, I need some help using data that I export from Visio Brainstorming into Excel. When exporting a mind map to excel, it dumps the data as an XML file with one column of text designating the leve...

excel

mtarler

Silver Contributor

Sep 02, 2022

CDav044 Here is 1 option assuming the number of "." is indicative of the level. Assume level is in col A, name is in col B, and this is put in col C and fill down:

EDIT: deleted prior formula for this to preserve some of that formatting (maybe?) and a cleaner/easier formula in general:

=LET(level,A1,name,B1,
     CC,LEN(level)-LEN(SUBSTITUTE(level,".",""))+1,
     LL,SEQUENCE(,CC), 
     IF(LL=CC,name,""))

CDav044

Copper Contributor

Sep 08, 2022

mtarler great thank you, this is very helpful.