Please Help!! Excel to Mindmap

  • 2
  • Question
  • Updated 1 month ago
Help!!! I'm desperately looking for a way to import an excel into Mindjet. I can set up the correct outline structure and paste a file in manually, but I have a spreadsheet with thousands of rows and it is too time consuming to do it manually. Does anyone know of any work arounds to import an excel or csv to a mind map?
Photo of Heather Cunningham

Heather Cunningham

  • 3 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 2
Photo of Jigs Gaton, Consultant

Jigs Gaton, Consultant

  • 110 Posts
  • 14 Reply Likes
Have you tried this: http://www.mindmanageraddins.com/tag/convert-excel-to-mindmap/ I've not used in awhile, but back in the day it worked well.
Photo of Detlef Huß

Detlef Huß

  • 9 Posts
  • 2 Reply Likes
In case the proposal from Jiggy (tx for the hint!) would not work for you, here is  a quite poor solution, by "on board means": Paste the Excel table into Word, which would there create a new table (Word format). Save as Word file and import it into the Map. The Excel content will then appear as notes attached to (empty) branches.
Photo of Alex Gooding

Alex Gooding, Champion

  • 832 Posts
  • 210 Reply Likes
I have written extensively on how to do this. Essentially you import the table to Word, apply Word heading styles to each column in the table starting with level 1 headings for the first column, level 2 for the next and so on, then convert the table to text. The resulting document hierarchy should be reflected in the map hierarchy after the document contents are exported to MindManager.

There is actually a bit more to it than that but I describe the process in part B of the series I wrote on Word/Excel exporting to MindManager: https://sociamind.com/2016/04/12/the-... If however your table has task information look at the instructions in part C.
Photo of Heather Cunningham

Heather Cunningham

  • 3 Posts
  • 0 Reply Likes
Hi Alex,

Thank you for the information, I will take a look at your blog. My only concern is the size of my table and the time it might take to format it in a word doc. I've also found another mindmapping software that will take a excel pivot table directly into a mindmap, that will then import into Mindjet. It is a few steps, but has worked fairly well so far. I'll test your recommendations to see if they work as well.

Thank you again!
Photo of Alex Gooding

Alex Gooding, Champion

  • 832 Posts
  • 210 Reply Likes
Thanks - what is the name of the mind mapping program that you're using to do this?
Photo of Heather Cunningham

Heather Cunningham

  • 3 Posts
  • 0 Reply Likes
Concept Draw. We have a ton of maps in MM and the functionality on MM is better, but as a work around Concept Draw is a good way to get a pivot table into a mindmap format. 

It would be awesome if MM could add this functionality as well.
Photo of Charlie Kimball

Charlie Kimball

  • 1 Post
  • 0 Reply Likes
I had a similar issue. It also depends on which version of Excel and MM you are using. I have Office 365 2016 and MM 2016. the add-ins were visible, but would not display in the Excel ribbon. In general, make sure that you have the Add-Ins from MM in your Excel. This applies to 2007, 2013 and 2016. Open Excel. If you do not see and Icon for MM in the Excel Ribbon, click on File>Options>Add-ins and make sure you see "MindJet Mindmanager Add-in" in the Active Application Add-ins list. If you do, and it did not see the Icon in Excel (which was my issue), make sure that MM is up to date. I had to run an update. If you do see the Icon and MM is not communicating with Excel, call Microsoft Support. Again this is what I had to do. The Tech logged in to my computer and and did some sort of Tech Magic, but it was an Excel Set-up issue. works fine now.
Photo of Alex Gooding

Alex Gooding, Champion

  • 819 Posts
  • 207 Reply Likes
I think the OP was trying to convert an Excel spreadsheet into a map, not insert a linked range from an Excel spreadsheet which is what the Send to MindManager button on the Excel ribbon does.
Photo of Alf Christophersen

Alf Christophersen

  • 47 Posts
  • 6 Reply Likes
Since MM can export a map to Excel with lot of tags it feel a kind of strange that the opposite operation is not implemented at same time :-)
Photo of Alf Christophersen

Alf Christophersen

  • 49 Posts
  • 6 Reply Likes
Maybe a miss at a point, but, TMS software has an Excel/cvs tool that could be embedded into new programs written with .net, C++ or Object Pascal (Delphi) called Flexcel.

Maybe that could be integrated as an add-in ?

http://www.tmssoftware.com/site/searchindex.asp?zoom_query=flexcel&s=s&filtervalue=flexcel
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1237 Posts
  • 182 Reply Likes
The most simple way to import excel rows and columns into a Mmap is to copy the part you want and to paste it in your map. This works
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1237 Posts
  • 182 Reply Likes
And yes, there is an add-in for several years now that does the trick.

http://www.ahacoaching.nl/nl/add-ins/ahaxls-import/

the Button for a free trial is called - Gratis proberen -.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1237 Posts
  • 182 Reply Likes
And another one....

https://mindlogik.com/collections/mindjet-mindmanager-add-ins/products/mindjet-mindmanager-17-excelm...

It is built for those of us who:
When you use Mindjet MindManager you might want to  export your map/project/task data to Microsoft Excel for data manipulation.
You can achieve this using ExcelMapUpdater. 
  • Create a map/project/ task in Mindjet MindManager 
  • Use the Export To Excel function to export directly to Microsoft Excel. 
  • Change and manage your Microsoft Excel Spreadsheet data 
  • Reimport to Mindjet MindManager
  • Full a-synchronous/synchronous functionality
Photo of Zubin Gidwani

Zubin Gidwani

  • 1 Post
  • 0 Reply Likes
Mindlogik ExcelMapUpdater is a step in the right direction, supports notes, but not URL links?
Photo of Bob Levy

Bob Levy

  • 82 Posts
  • 11 Reply Likes
I simply selected the cells, copy, then paste into topic in MM. Worked better than I expected.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1217 Posts
  • 180 Reply Likes
Glad to see that one of my suggestions works for you ;-)