VERIFIED SOLUTION i

Working with Excel files in MapInfo Pro

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)
 
User-added image

In the resultant dialog box, select Microsoft Excel (*.xls, *.xlsx) at the "Files of Type" drop-down.

User-added image

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

User-added image

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

User-added image

The "Set Field Properties" dialog box displays - leave the default settings and click OK and the spreadsheet will in a browser view.

User-added image

User-added image


Saving a newly created .TAB file

Under the Home tab select the Save drop down menu

User-added image

From the menu, choose Save Copy As


User-added image

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

User-added image

The Save Copy of Table As dialog displays, type desired file name in File Name box and click Save

User-added image


Opening the newly created .TAB file in MapInfo Pro

At the Home tab, select "Open Table"

User-added image

From the File Open menu, select the desired .TAB file and click "Open".

User-added image


A browser window will open with the contents of the table displayed as expected:

User-added image


Tip:
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