Convert MAPINFO to XLSX

Turn MAPINFO files into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop MAPINFO files on the dialor turn it to pick what to do

Your MapInfo table as an Excel sheet.One row for each feature, with its shape as text and its attributes as columns.

  1. What you get

    A workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column, named WKT, holds the shape as WKT. Every attribute follows as its own column.

    Numbers, dates and true and false values are typed cells, not text. Lists and nested values become JSON text. Times with a time zone are written in UTC.

  2. Shapes and coordinates

    Coordinates are written in WGS 84 longitude and latitude. They are converted from the source's system, such as Korea's EPSG:5186. If the data names no system, the coordinates stay as they are.

    A feature without a geometry keeps its row, and its WKT cell is empty. If a column in your data is already named WKT, it is renamed WKT_1. A shape longer than the 32,767 characters a cell holds leaves its cell empty, and a warning is given.

  3. Several layers and large maps

    When the source has several layers, they are joined into one sheet. A layer column names where each feature came from.

    A map of more than 1,048,575 features fails with resource_limit.

MAPINFO and XLSX.What each format is.

The formats

From · MAPINFO

MapInfo Table

MapInfo TAB tables zipped with their .dat, .map and .id parts, or MIF and MID interchange files, from MapInfo Pro.

Extensions
.tab.zip .mif.zip
MIME type
application/x-mapinfo+zip
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same MAPINFO to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.tab.zip report.xlsx
$ cv convert report.tab.zip report.xlsx

Questions.What people ask about MAPINFO to XLSX.

01OF 04

It holds each feature's shape as WKT. It is always the first column, and it is empty for features without a geometry.

WGS 84 longitude and latitude. If the source names no system, the coordinates are kept as they are.

Yes. Zip a TAB table with its .dat, .map and .id parts, or use MIF and MID interchange files.

The map has more than 1,048,575 features. The conversion stops with resource_limit at that point.

More conversions.Other ways in and out of MAPINFO and XLSX.