How to Input Data from MS Excel Into a Mind Map

ConceptDraw MINDMAP supports inputting external data from many different file formats. If you keep your data in Microsoft Excel, you can import it into ConceptDraw MINDMAP, converting the rows and columns into a hierarchically structured mind map. If you have multiple individual sheets within your Excel workbook, ConceptDraw MINDMAP will convert it into a single multi-page mind map. If you need to input just the selected cells, the best way to do this is to copy-and-paste.

If you need to import your MS Excel file to ConceptDraw MINDMAP, follow these steps.

1. Prepare the source file. Consider that the first column in the file will be transformed into the Main Idea, the second - to Main Topics, the third - to subtopics, etc.


2. Run ConceptDraw MINDMAP.
3. Open the File menu, select Import and then choose MS Excel Document.
4. The Open dialog appears. Select a XLSX file and click Open.
5. Your MS Excel spreadsheet will be converted to Mind Map structure.

1. Open MS Excell file.
2. Copy the selected cells in an Excel Spreadsheet.

3. Run ConceptDraw MINDMAP.
4. Paste the selected cells into your mind map.
5. Your table will be converted into topics and subtopics:

• Rows of the first column are converted to topics.
• Columns are converted into sub-topics, corresponding to column numbers.

Result: Now the data from your Excel spreadsheet is ready to be presented and discussed with your team.