VERIFIED SOLUTION i
Products affected: MapInfo Pro™
How do to use Excel Files in MapInfo?This document will help you open Excel files in MapInfo Pro. There will be business needs when attributes stored in tabular format such as Excel files might be required for analysis with geographic data.
This document will help users create a MapInfo tab file using an Excel file, save the excel data as .tab file and finally open the newly created .tab file in MapInfo Pro.
Under the Home tab, select "Open".
In the Workspaces, Tables, Programs dialog, select Table (highlighted in Image below)
In the resultant dialog box, select Microsoft Excel (*.xls, *.xlsx) at the "Files of Type" drop-down.
Browse and select desired file and click Open but first check the box to Select Create copy in MapInfo format for read/write checkbox at the bottom of File Dialog.
This option will automatically make a copy of the original Excel file in MapInfo Professional’s native “.TAB” format and opens the copy
A dialog box will appear prompting users to specify what group of cells you wish to work with. In most instances, you will leave this as default and if you are importing an Excel file with headers be sure to check the Use Row Above Selected Range for Column Titles box
The "Set Field Properties" dialog box displays - leave the default settings and click OK and the spreadsheet will in a browser view.
Under the Home tab select the Save drop down menu
Saving a newly created .TAB file
From the menu, choose Save Copy As
The Step above will display a list of Open tables in the session, as shown below. Choose the Excel file that you opened in MapInfo from the Save Table list and click Save As
The Save Copy of Table As dialog displays, type desired file name in File Name box and click Save
Opening the newly created .TAB file in MapInfo Pro
At the Home tab, select "Open Table"
From the File Open menu, select the desired .TAB file and click "Open".
A browser window will open with the contents of the table displayed as expected:
Note that the tab file created using the process explained above will create files with 2 different file extensions, namely .TAB & .DAT.
If the table is made mappable, additional file types of ".id" and ".map" will be created and if any fields are indexed, then an ".ind" file will also be created.
UPDATED: July 2, 2019