import excel

  • 3
  • Idea
  • Updated 5 years ago
"Have the user follow a simple protocol for import directly from Excel into Maps! In many cases detailed analysis is done in Excel, but needs to be visualized in ways not readily available with Excel charts and tables. Mindjet Mindmaps could be a powerful tool. Here's what I recommend. Each column in Excel represents a Level in the maps. The items are imported from top row to bottom row. Each row contains one topic, placed at the level you want it to display. The only rule is that lower rows are grafted to the higher ranking ones above.

See below, and email me if you have questions. Another great feature for my users.

Tim L1 L2 L3 L4 Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text "
(from Tim Jones)
Photo of Mindjet

Mindjet

  • 558 Posts
  • 54 Reply Likes

Posted 6 years ago

  • 3
Photo of Chia Ling

Chia Ling

  • 2 Posts
  • 0 Reply Likes
We have seen this request from at least two customers in the past two months. While there are some manual ways to accomplish this, it would be easier to have this built into the solution.

This would also help convince people who are managing projects or other data in Excel to move into Mindjet since they won't have to re-create this content.

Source:
https://community.mindjet.com/mindjet...

https://community.mindjet.com/mindjet...
Photo of Alex Gooding

Alex Gooding, Champion

  • 827 Posts
  • 208 Reply Likes
@ Chia Ling - while I think this would be a good idea I can appreciate that it could be quite difficult to accomplish.

Excel spreadsheets come in many different shapes and sizes, as I indicated in my post that you linked to regarding using Excel's pivot table feature to assist in "manual" importing. I imagine that it would be relatively easy to build in a simple import facility that could essentially replicated what I did with the pivot table, but that assumes a relatively straight-forward table structure with a single main topic created for each group of repeating items in the first column of the spreadsheet.

However trying to build in the ability to deal with tasks and topic notes properly, eg, being able to recognise automatically and import successfully table cells containing task start and end dates, resources, topic notes, text tags, etc could be a lot trickier as these don't have any obvious distinguishing features in Excel (apart from date formatting in the case of start and end dates).

One option might be to develop an import facility that could recognise certain column names and also provide a simple spreadsheet template containing these. The template could have say five colums which would match descending topic levels in the mind map. The last three or four columns to the right of these would be set up with column names and the appropriate formatting to handle start and end dates, notes, etc.

The user would insert additional columns to the left of these to cater for additional columns - deletion of unwanted columns would not be strictly necessary as the import could be set to apply the conversion of the task and other special columns to the last topic level column in which there is an entry.