Displaying your Excel (.XLS or .XLSX) Data - MapInfo_Pro - 2023

You can create a .TAB file from an Excel file that is up to 64K in size.

To create a .TAB file from your Excel (.XLS or .XLSX) data:

1. On the HOME tab, in the File group, on the Open list, click Table to open the Open dialog box.
2. In the Files of Type list select (.XLS or .XLSX), navigate to your data, and click Open.
3. Select the worksheet you want in your MapInfo data table. Make sure that this data includes either postal codes or longitude/latitude coordinate values.

   The default data range for an Excel file is the entire worksheet.

   • If you select the Use Row Above Selected Range for Column Titles check box, the default data range begins at A2 (row 2).
   • If you clear the Use Row Above Selected Range for Column Titles check box, both the Named Range and Current Value fields revert to their previous values on the Entire Worksheet.
4. Click OK to display the Set Field Properties dialog box.

   This dialog box allows you to reset the name, type and properties of any field (column) that you import from the Excel table. The top of the Set Field Properties window shows the Fields (column names) and Type (character, date, etc.) from the Excel spreadsheet. When you select one of these fields, the Field Information box entries at the bottom allow you to specify the field name, data type, number of characters (for character and decimal fields) or number of decimals (for decimal fields only).

   
   

   

   
   
   Note: If you click Cancel, MapInfo Pro cancels the import operation.
5. Click OK to convert the data to a MapInfo table (.tab) format. Now that you have converted your data, you can plot your data; see the next section to continue.

You can only read information from these files. When you want to do other tasks, see Working with Spreadsheets.