For: MapInfo Pro/MapBasic
By: Peter Horsbøll Møller
Rated: 4 Stars (11 ratings)
MapInfo2Excel is an easy to use tool that helps you to export data from a MapInfo table into an Excel file. New version 1.7 adds support for seven additional languages.
MapInfo2Excel provides a quick and easy way to export a table from MapInfo Professional to Microsoft Excel.
This data can be an entire MapInfo table, a query or the data that you currently is viewing in your browser window.
MapInfo2Excel lets you also export a map window to an open MS Excel file.
To get the most out of this tool it’s recommended that you add this tool to the Tool Manager and sets it to Autoload.
The features of this tool have all been made in response to requests from customers.
As this tool takes advantage of the new browser window added in MapInfo Professional 11.5 you need to be running MapInfo Professional 11.5 or later to be able to use MapInfo2Excel.
The sourcecode for this tool is hosted on Github. You can find the sourcecode here:
June 14th, 2013: In response to David's comment we have uploaded a new version that includes the template. Thanks for letting us know.
September 24th 2013: A new version has been uploaded. This update improves how images are saved within the document. The update was needed because Office 2010 includes a link to images instead of the image itself.
September 15th, 2014: Version 1.7 released
Version 1.7 adds support for the following languages: Danish, Dutch, Finnish, French, Italian, Spanish and Swedish.
October 19th, 2013: Version 1.5 released
In this release the speed of exporting data from MapInfo Professional to MS Excel has been improved. Previously the data was sent from MapInfo Professional to MS Excel one value at a time using basic DDE communication. Now we have changed this to writing the data into a semicolon separated text file and using a macro in MS Excel to import this data in this file into the sheet. A basic test showed that exporting approximate 70 000 records to MS Excel now can be done in close to 20 seconds.
MS Excel template file
Also notice that we have changed the template file between version 1.0 and version 1.5 and now again in version 1.5. Between the two versions we had to update the macro that inserted images into a sheet in MS Excel as Microsoft had changed the way an image was stored.
For v1.5 we have added a new macro that allows a very fast import of the data from MapInfo Professional, (see above).
Menu item to take you to the Community Downloads site
The tool now also has a new menu item that will take you directly to the Community Download site where you can find other useful tools – and even rate this tool.
Hugo Sørensen (06-16-2015)5 Stars
Used a previous version, which was great.
itchyeyeballs (05-13-2015)5 Stars
Should be part of the core functionality of MapInfo!!
David@fire (06-13-2013)1 Star
This tool sounds really useful as I often export to Excel. I have not been able to try it out as the Excel template was not included in the zip file
File name: MapInfo2Excel.zip
File size: 971KB
File type: zip
Rate & Review
You must be registered and logged in to submit a rating for this entry.