Archive for the ‘data. tables’ Category

Converting tables (spreadsheets) into MindManager Maps

Wednesday, February 24th, 2010

Have you ever been frustrated about adding a table of data to your MindManager map? There it is all nicely arranged. It could be a list of meeting attendees e.g. Ecademy 12th Birthday Party. You can copy and paste it (just the attendee table) on to a map but the result is not what I want. Each row gets concatenated into one topic.

Here is how I process it in Word to produce the map I want. Paste part of this attendee list as unformatted text in to Word or use a simple two column table with a few rows of data.

Then Insert > Table > Convert text to table

Now you have a tabulated set of data. In this case the Name column comes with some excess baggage. Use search and replace to remove the guff. Delete any columns you do not need.

Select the Name column apply Heading 1 style
Select the Organization column apply Heading 2 style

You could have Location as the Heading 2 style or make it a sub-sub-topic with Heading 3 style. I also added Ecademy Meeting in Title style.

Open a new map in MindManager.

Select the table contents in Word and then click the MindManager button in Add-Ins. Hey presto.

Alternatively save the Word document and the import in MindManager. Ecademy meeting becomes the central topic. You can also copy and paste Spreadsheets in to Word and process them similarly.

Do you have a better way?