Convert GEOJSON to XLSX

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

Map features as rows in a sheet.Each feature becomes one row, with its shape as WKT and its attributes in 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 is named WKT and holds the feature's shape as WKT. Every attribute follows as its own column. Numbers, dates and true and false values are written as typed cells.

    Coordinates are written in WGS 84 longitude and latitude.

  2. What changes on the way

    Lists and nested values become JSON text in their cells. Times with a time zone are written in UTC.

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

  3. Limits

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

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

GEOJSON and XLSX.What each format is.

The formats

From · GEOJSON

GeoJSON

Points, lines and polygons as JSON, the web's map data format.

Extensions
.geojson
MIME type
application/geo+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 GEOJSON to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.geojson report.xlsx
$ cv convert report.geojson report.xlsx

Questions.What people ask about GEOJSON to XLSX.

01OF 04

Into the first column, named WKT, as WKT text. Every attribute gets its own column after it.

They keep their row. The WKT cell is empty.

That attribute's column is renamed WKT_1. The shape column keeps the name WKT.

When the map has more than 1,048,575 features. A smaller map does not stop for that reason.

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