Sending data to Word and Excel
You can send brainstorming data directly to Word and Excel and in fact to any program that accepts input XML. The data in the Plan window is exported to a Word or Excel document and is opened as an XML file. All changes can be saved to this XML file, which can then be imported back into Visio.
To export data as an XML file, in the Manage section of the Brainstorming tab, click Export data and select Microsoft Word or Microsoft Excel. Note that these options are only available if the 2016 versions of Word and Excel are installed on your computer. For other versions of Word and Excel or to use any other compatible program, select To XML instead…
For example, when you export the data to Excel,Visio automatically opens Excel after you save the XML file. In Excel, data is organized into field levels. For example, T1 represents the main topic, T1.1 represents the first subtopic under the main topic, T1.1.1. represents other sub-topics under the sub-topic and so on. You can add or remove topic hierarchies here and save the XML file, which can then be imported back into Visio.