Convert TOPOJSON to XLSX

Turn TOPOJSON 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 TOPOJSON files on the dialor turn it to pick what to do

Map features as rows in a spreadsheet.One row per feature, with its shape as text and every attribute in its own column.

  1. What you get

    An XLSX workbook with one sheet. The sheet is named after the file and cut to 31 characters. Each feature in the map becomes one row.

    The first column is named WKT and holds the feature's shape as WKT text. Every attribute follows as its own column. Numbers, dates and true and false values are stored as typed cells, so Excel can sort and calculate with them.

  2. What changes on the way

    Coordinates are written in WGS 84 longitude and latitude. Lists and nested values become JSON text. Times with a time zone are written in UTC.

    A feature without a geometry keeps its row, with an empty WKT cell. If the file already has an attribute named WKT, that column is renamed WKT_1 so the shape column stays first.

  3. Limits to know

    A cell holds at most 32,767 characters. When a shape is longer than that, its cell is left empty and a warning is given. The rest of the row is kept.

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

    If the file has several layers, they are joined into one sheet. A layer column names the layer each feature came from. To join workbooks afterward, see merge XLSX.

TOPOJSON and XLSX.What each format is.

The formats

From · TOPOJSON

TopoJSON

TopoJSON, GeoJSON's compact cousin that shares borders between shapes, as D3 maps use it.

Extensions
.topojson
MIME type
application/topo+json
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 TOPOJSON to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.topojson report.xlsx
$ cv convert report.topojson report.xlsx

Questions.What people ask about TOPOJSON to XLSX.

01OF 04

As WKT text in a first column named WKT. Features without a geometry have an empty WKT cell.

No. Several layers are joined into one sheet, and a layer column names where each feature came from.

A cell holds at most 32,767 characters, and that shape is longer. The cell is left empty and a warning is given.

The map has more than 1,048,575 features. That is more rows than the workbook can hold, so the conversion stops with resource_limit.

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