Convert ESRIJSON to XLSX

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

One row per feature, shape included.Each feature becomes a row in an Excel workbook, with its shape as WKT 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 gets 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. Times with a time zone are written in UTC.

  2. What changes

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

    Lists and nested values become JSON text. A column already named WKT is renamed WKT_1, so the shape column keeps its name.

  3. Gaps and limits

    A feature without a geometry keeps its row, and its WKT cell is empty. A shape longer than the 32,767 characters a cell holds also leaves its cell empty, and the conversion gives a warning.

    A map of more than 1,048,575 features fails with resource_limit. For other formats, see every XLSX conversion.

ESRIJSON and XLSX.What each format is.

The formats

From · ESRIJSON

Esri JSON

Features with their attributes, geometry type and spatial reference, as ArcGIS REST services return them for a query with f=json.

Extensions
.esrijson
MIME type
application/x-esri+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 ESRIJSON to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.esrijson report.xlsx
$ cv convert report.esrijson report.xlsx

Questions.What people ask about ESRIJSON to XLSX.

01OF 04

It holds each feature's shape as WKT. It is the first column, and the attributes come after it.

WGS 84 longitude and latitude. Coordinates are converted from the source's system, such as EPSG:5186. If the source names no system, they are left as they are.

They keep their row. Only the WKT cell is empty.

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

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