Map2Excel Add-in Available

The Map2Excel tool has been converted to an easily installable MindManager add-in. More information is available here. The add-in also incorporates Map2Table and Map2Outline.

To download the add-in, visit http://map2excel.com.

Note that the ActivityOwner Tools Add-in is also fairly functional now and ready for testing and feedback.

SAMPLE INPUT:

SAMPLE OUTPUT:

162 Comments »

  1. ActivityOwner said,

    December 9, 2012 @ 9:13 pm

    Thanks Nick — There was a stray line of code in there setting a hyperlink that should not have been. Should be fixed now in 1.0.0090.

  2. Nick Huang said,

    December 9, 2012 @ 10:12 pm

    Hi, AO

    Sorry for my poor English. For normal output to excel file with Table function, it becomes different result between previous version and now. I send the result files for your reference.

    Thanks.

  3. ActivityOwner said,

    December 10, 2012 @ 8:43 am

    Thanks for the testing Nick. I had added a bug in the process of fixing another on the tabular report. 1.0.0091 fixes it, but please keep bug reports coming. I don’t have much time for testing.

  4. Nick Huang said,

    December 10, 2012 @ 12:29 pm

    Hi, AO

    Thanks for fixing the code. It exports to excel file with Table function works great. Another problem is the Hyperlink pointed to wrong destination when I import the exported excel file. I send files for your reference.

    Thanks.

  5. ActivityOwner said,

    December 10, 2012 @ 8:01 pm

    Thanks Nick — I got files but am having trouble replicating the problem. The issue is that your excel file has a relative link created in it (..\test.txt). I did have this issue in the code at one point, but it should have been fixed in the recent versions to export absolute link.

    Can you confirm this excel file was created with the latest version (1.0.0091)?

  6. Nick Huang said,

    December 11, 2012 @ 10:35 am

    Hi, AO

    I try to explain this situation as I known. My Mindmanager file save in D:\Dropbox\My Maps. Then I export excel file in the same folder and then I import this excel file back to Mindmanager is correct for Hyperlink. But if I export excel file to D:\, then I import it back to Mindmanager the Hyperlink is error. The attachment is at the same place in above situations. sorry for all questions.

    Thanks.

  7. ActivityOwner said,

    December 11, 2012 @ 8:52 pm

    Thanks for your patience Nick. Your detailed example allowed me to figure out the problem. I thought I had addressed it earlier but there was a line of code missing. The problem is with relative links. Your file links are relative links so they are stored in mindmanager as “..\..\test.txt”. I need to temporarily change the link to absolute so that it is exported as “d:\test.txt”. That is why if we stored the excel file in the same directory it worked OK, but it didn’t when stored in a different directory. The latest version 1.0.0094 should finally address this.

  8. Nick said,

    December 11, 2012 @ 11:06 pm

    Hi, AO

    I test the new version 1.0.0094, but there are some problems as below.
    1.Import excel with hyperlinks into Mindmanager are same result(miss link).
    2.Export to excel file lose all the link.
    sorry for all questions.

    Nick

  9. Nick Huang said,

    December 12, 2012 @ 10:19 am

    Hi, AO

    I test the newest version 1.0.0094, but still there are some problems as below.
    1. Import excel file to Mindmanager the hyperlinks are the same(missing link).
    2. Export to excel all the hyperlinks are dissapear.
    sorry for all questions.

    Nick

  10. Nick Huang said,

    December 12, 2012 @ 10:34 am

    Hi, AO

    The second question is my falut. I forgot to select “Add external hyperlinks”. sorry…
    And the first question, it seems lack of disc path(ex:”D:\” or “C:\”). Could you check it.
    Thanks for your patience.

    Nick

  11. ActivityOwner said,

    December 12, 2012 @ 10:51 pm

    Hi Nick — I looked at this for a couple of hours and there isn’t a simple general solution to getting the absolute path to a file hyperlink from Excel. There are some code snippets available, but it will take time to adapt into my code. If you can put the excel file on a different drive, keep it in the same directory, or actually not save it, I think it can work for now.

  12. Nick Huang said,

    December 13, 2012 @ 11:52 am

    OK, I know. Thanks AO.

    Nick

  13. ActivityOwner said,

    December 13, 2012 @ 9:42 pm

    OK — I figured out how to make hyperlinks work. Try 1.0.0098. You have to do a fresh export — it won’t import hyperlinks in the old format.

    This version also breaks out tags into individual columns.

  14. Nick Huang said,

    December 14, 2012 @ 7:42 am

    Wow, it works great now. Thanks AO.

    Nick

  15. ActivityOwner said,

    December 14, 2012 @ 4:00 pm

    I’ve made several changes that with latest version 1.0.0100 that folks that have been using the program should be aware of.

    * The tag, icon, and customproperty columns now have “tag:”, “icon:”, “custom:” pre-pended to their names to aid in identifying them on import.

    * The centraltopic text is exported as “Table:text” if the export is in tabular format so that it can be recognized easily on import. I found answering the “do you want to import an outline” question annoying. I’m open to other ideas to get around that.

    * If a saved excel spreadsheet is imported, it will be closed after import.

    * The “import last export” and “overwrite last export” functions went away as they leave a connect to excel in place that leaves mindmanager and excel in memory after they are closed. I’m still seeing issues with both mindmanager ane excel staying in memory, so use your task manager to kill them off for now as I work out what pointer is being left in memory to leave them there.

    Please comment on how you think this should work. Working with last export is handy for rapid testing, but in practice I think working on saved files makes sense. Also what do you think of possible approach of defaulting export to be same name/path as map but xls?

  16. Nick Huang said,

    January 3, 2013 @ 1:29 pm

    Hi, AO

    Could you please add the function that text retain excel colors when importing to Mindmanager? That can be useful for my job. Sorry for the request.

    Nick

  17. Andreas said,

    January 23, 2013 @ 10:43 am

    Hi there,

    is there a trick or switch to prevent Map2Excel to export for each topic an individual row?
    Having this as an option would be very helpful to reduce excessive formatting and deleting in the excel table.

    For the time beeing I would be fine using the version 1.0.0012. Is there any place where I can downlod it?

    Andreas

  18. admin said,

    March 21, 2013 @ 10:38 pm

    Hi Andreas — sorry, I missed this comment when it came in. What type of output format are you looking for? Have you tried the tabular output?

  19. KG said,

    February 27, 2013 @ 2:58 pm

    I installed v1.0.0104 for Mindmanager 11. When trying to export, I get this error:

    System.Runtime.InteropServices.COMException (0x8002000B): Invalid Index. (Exception from HRRESULT: 0x800200B (DISP_E_BADINDEX) at Microsoft.Office.Interop.Excel.Sheets.get_item(Object Index) at Map2Excel.Module1.Map2Excel(Application& m_app, Boolean& fillin, Boolean& addextended) at Map2Excel.MindManagerRibbon.M2ERibbonGroup.tLock_Click4()

    I am running Excel 2013 64 bit. Excel open, but nothing exports and I get this error.

    Any ideas?

  20. admin said,

    February 27, 2013 @ 6:17 pm

    Hi KG — I compile Map2Excel to work with Office 2010, so I don’t think it will work with 2013 at this point.

    I can compile different versions for each version of mindmanager as I have all 4 versions installed on my system, but it might be more complicated to compile for 2013 (unless I upgrade and abandon 2010).

    I wonder what the typical user is using these days? Most corporations tend to lag in adopting latest software.

  21. Moritz said,

    May 3, 2013 @ 12:19 pm

    I am running Office 2013 and Map2Excel doesn’t work. Big pain. AO, I am willing to buy you a subscription for Office 365 Home Premium, if that would help you to fix it. Please let me know? Thanks!

  22. ActivityOwner said,

    May 14, 2013 @ 10:27 pm

    I think I’d need to get Excel 2013 rather than Office 365. It goes for about $110.

  23. Matt said,

    September 19, 2013 @ 6:42 am

    Hi Alex,

    I’ve upgraded to MM14 (from 11) and I now get a script error window when opening MM, and Map2Excel doesn’t load up / show in the add-ins either. MM14 looks pretty similar to MM11, seems like a soft upgrade. Is anyone else experiencing problems?

    Thanks!
    Matt

  24. ActivityOwner said,

    September 19, 2013 @ 7:36 am

    Map2Excel has yet to be compiled for MM14. The MM11 version won’t work. What version of Excel are you using? What is the script error you are getting?

  25. Matt said,

    September 25, 2013 @ 9:10 am

    Hi There, sorry about the delay in responding,

    I see that you posted at MM14/Excel2013 version in the meantime, and I have downloaded and installed that on my system. I am using Excel 2010.

    The latest version works fine in MM14/Excel2010, with one small bug that I have spotted thus far: the add-in will ONLY export expanded branches. I wondered why it was only exporting a small amount of the data (I only had one small branch expanded), and realized that only the expanded branch data was appearing in XL. When I expanded all branches to all levels, all of the data from the MM was successfully exported to XL.

    Thanks again!

    M

  26. ActivityOwner said,

    September 29, 2013 @ 11:03 am

    Hi Matt — I didn’t realize it might be backward compatible with 2010. That’s good news.

    The “one small bug” is a feature :-).

    If you want invisible topics exported, un-check the “limit to visible topics” option in the options menu.

  27. Matt said,

    November 2, 2013 @ 11:42 am

    Hi,

    A feature it is, then :) Thanks for the options tip.

    And thank you for this very useful utility and your responsiveness. I am very grateful.

    Matt

  28. Marcel said,

    November 26, 2013 @ 11:19 am

    Hi,

    is there also an application for MindManager Pro 6 and Excel 2010 available?

    thx
    Marcel

  29. ActivityOwner said,

    November 27, 2013 @ 12:18 am

    Hi Marcel — Unfortunately the add-ins go back to MMM8, but not as far back as MM6 (2006).

  30. Eric said,

    May 15, 2014 @ 5:33 pm

    Hi – I just purchased and loaded this add in for MM14/Excel 2013. I have Excel 2010. Add-in seems to be working in MM, but I can’t get an existing Excel file to import (i.e. Excel2Map).

    What adjustments need to be made to my existing excel workbook to make it importable?

    Thanks,

  31. Alex said,

    July 9, 2014 @ 10:33 am

    Hi,

    I’ve just upgraded to version 14.3.192 of MindManager and Map2Excel has stopped working. Is there an upgrade available? I’m exporting to Excel 2010.

    Thanks

    Alex

  32. ActivityOwner said,

    July 18, 2014 @ 6:55 am

    Hi Eric — Excel2Map needs the Excel sheet to look just like the output of Map2Excel. It just reverses the process. There are an infinite number of possibilities of what an excel sheet can look like that can’t be anticipated, so I had to just program it to look for the outline structure of a Map2Excel output.

  33. ActivityOwner said,

    July 18, 2014 @ 6:56 am

    Hi Alex — I’ll have to look into that and recompile it. It might be a week or 2.

  34. LU said,

    September 9, 2014 @ 5:32 am

    Hi

    I confirm map2excel crashed when working on MM 14.

    Cheers

    LU

  35. LU said,

    October 6, 2014 @ 5:42 pm

    Hi

    I tried MM14 and MM11 and office 2013. The same error in both versions.

    https://dl.dropboxusercontent.com/u/16605325/map2excel/map2excel_error.jpg

    Any idea about that ?

    Cheers

    LU

  36. Arjen said,

    January 27, 2015 @ 11:10 am

    Hello,
    I looked for a tool to export maps to Excel – while keeping all the attributes. I use MM14, but it does not export Tags, and I need those too. I stole your Map2Excel code you put together which does 95% of what I wanted – ** thank you so much for that **.

    I added some features that are relevent to me, but also corrected one or two bugs:

    The line “sheet.Cells(rownum,9) = sheet.Cells(rownum,9) & t.TextLabels.Item(1).Name” must be “sheet.Cells(rownum,9) = sheet.Cells(rownum,9) & t.TextLabels.Item(i).Name” (so i, not 1) – otherwise it exports only the first Tag (but multiple times)

    I also found that your code did not export the properties of a topic that is not the last topic in a tree, so moved some if/then logic around to make sure it exports the properties of all the topics in a tree (not just the outer ones).

    As I want every topic on a separate row in Excel, I also added an Increase-Row-Number-By-One statement to make sure that each topic gets its own row (the ‘outline’ spacing as MM14 puts it).

    Small changes, but maybe it can help someone. Obviously happy to share the modified code with you or anyone else!

    Many thanks for making the code available – I can read-and-change it as I did, but would have never been able to come up with the bulk of the code.

  37. DJ said,

    October 30, 2015 @ 9:59 am

    Trying to purchase but getting a response from Paypal stating: We were unable to decrypt the certificate id.

    Should the Map2Excel for MindManager 2016 be fully functional upon download?

    Looking forward to it
    Thanks!

  38. ActivityOwner said,

    October 31, 2015 @ 7:33 am

    Thanks for pointing this out. Buy button should now be fixed. The software has a 7 day trial period.

  39. AF said,

    November 5, 2015 @ 2:03 pm

    Hi. I downloaded and installed Map2Excel for MM 2016 and Excel 2013. Installer appears to work (at least it shows no errors), but when opening MInd Manager, the Map2Excel tab does not show. Any ideas? Thank you.

  40. ActivityOwner said,

    November 7, 2015 @ 12:54 pm

    Sorry about that. In recompiling it for various versions I may have missed a step. Try the latest upload.

  41. Mark Smitg said,

    October 19, 2016 @ 3:27 am

    Hi, I get an error trying to download the Map2Excel for Mindmanager 2017:

    Not Found

    Sorry, but the page you requested cannot be found.

    Not Found

    Sorry, but the page you requested cannot be found.

    Please fix – Thanx!

  42. ActivityOwner said,

    October 19, 2016 @ 8:35 pm

    Whoops — sorry about that. Link fixed.

  43. Daniel said,

    October 29, 2016 @ 2:04 am

    When I download for Mindmanager 2017 and Excel 16, the download link says Mindmanager 2016 and Excel 16, could the link be incorrect? Thank you!

    Daniel

  44. ActivityOwner said,

    October 31, 2016 @ 7:24 am

    Hi Daniel — Sorry that was leftover title in the download html. The 2017 link goes to the 2017 installer.

  45. Thomas said,

    November 25, 2016 @ 3:39 am

    Hello,

    I just downloaded and installed Map2Excel and nothing happens. MindManager 2017 ist starting normally und the add in does not show up. In the add in list it does not appear neither. Can you tell me what I can do to make it run?

    Thanks Thomas

  46. Thomas said,

    November 25, 2016 @ 3:51 am

    Hi again,

    my MindManager Version on my desktop is 17.0.290 (64bit)
    and the downloaded Map2Excel is Map2ExcelSetupExcel2016-MM2017-1.0.0123

    A restart of the PC did not help neither. I use Windows 7.

    Thanks for helping me
    Thomas

  47. ActivityOwner said,

    November 25, 2016 @ 11:53 am

    Hi Thomas — I’m not sure what is wrong. I just recompiled a new version 0124. Give it a try.

  48. Thomas said,

    November 25, 2016 @ 4:15 pm

    Hello again,

    I downloaded the new file 0124. I tried it on my desktop (windows 7) and on my laptop (windows 10). It is installing and telling me that the installation was successful. But when I open MM17 it is still invisible.

    Do you have an idea?

    yours Thomas

  49. ActivityOwner said,

    November 25, 2016 @ 4:43 pm

    Hi Thomas — Sorry you are having trouble. This occurs most often for me when I’m running a different version of mindmanager than I have installed the add-in for, but it sounds like you have this ruled out given that you have provided version information (available under file, help).

    Can you try running the installation program as administrator? That seems unlikely root cause if you are having trouble installing on two different machines, but perhaps give that a try.

    Does the add-in show up if you try to uninstall the add-in under add/remove programs?

  50. Thomas said,

    November 25, 2016 @ 5:49 pm

    Hi Ao,

    I am Administrator and as such I have installed it. Yes it shows up, wenn I go to uninstall and it uninstalls properly.

    It is really installing and uninstalling properly, no failure message. It makes a folder in Programms where I can find a dll-file and some jpegs. But it doesn’t show up and it is not in mm add ins list.

    I am thinking about if there is some issue because of the German version I am using?

    The MM version is:
    Laptop
    Produkt: Mindjet MindManager (64-Bit)
    Version: 17.0.290
    Modus: Normal

    OS: Windows 10 Pro 64-Bit Version 6.3.14393

    and Desktop PC
    Produkt: Mindjet MindManager (64-Bit)
    Version: 17.0.290
    Modus: Normal

    OS: Windows 7 Professional 64-Bit Service Pack 1 Version 6.1.7601

    That’s all.
    :-)

  51. Thomas said,

    November 25, 2016 @ 5:52 pm

    I will leave here for today – is is late evening here and I will finish my day soon

    I hope you will find a solution, wish you the best

    Thomas

  52. ActivityOwner said,

    November 25, 2016 @ 8:37 pm

    Hi Thomas — Thanks for the detailed comments — it is now solved!

    You have the 64bit version of MindManager and I had compiled for 32 bit version installed on my machine. I don’t think I’ve encountered 64bit users previously. Apologies for not noticing the difference when you posted your version information.

    I added a new installer for 64bit version of Mindjet 2017 and have tested the install.

    Thanks for your patience!

  53. Thomas said,

    November 26, 2016 @ 5:58 am

    Hey,

    the installation was now very easy and it is integrated in MindManager 2017 in the ribbon and as well in the add ins list.

    Thank you very much. :-)

    Yours Thomas

  54. ActivityOwner said,

    November 26, 2016 @ 4:15 pm

    Note that I have made a few revisions based on feedback from Thomas and earlier bug report. The icon columns in the export now include the group they are associated with. This still needs to be done for tag groups.

  55. George Kochanowski said,

    February 5, 2018 @ 7:11 am

    Greetings

    Is there an alternate email address where I can send you a mind map and an excel spreadsheet that show the issue I am having using the 2018 version 32 bit?

    It appears that only the first topic gets its tag information imported into excel.
    George

  56. ActivityOwner said,

    February 8, 2018 @ 6:18 am

    info AT activityowner.com

  57. Cesar Acevedo said,

    September 28, 2018 @ 2:35 pm

    Hi,

    I downloaded the and paid for Map2Excel – MindJet 2018 – 64bit and my Admin installed but when I run Mindjet it just say …’unable to load the “Map2Excel.Connect” Add-In. This Add-In will be disable.

    I restarted the laptop but did not work

    Mindjet MindManager Version 18.2.109 (64-bit)

    Microsoft Excel 2016 (16.0.9226.2114) 64-bit

RSS feed for comments on this post · TrackBack URI

Leave a Comment

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 2.5 License.