Convert ESRIJSON to CSV

Turn ESRIJSON files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A table of features, one row each.Shapes become WKT in the first column. Attributes follow as columns.

  1. What you get

    A CSV with one row for each feature. The first column is named WKT and holds the feature's shape as WKT. Every attribute then becomes its own column.

    The result is one file.

  2. What changes

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

    Lists and nested values become JSON text, since a CSV cell holds a single value.

  3. Edge cases

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

    To combine several results afterward, see merge CSV.

ESRIJSON and CSV.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 · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

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

terminal
$ cv convert report.esrijson report.csv
$ cv convert report.esrijson report.csv

Questions.What people ask about ESRIJSON to CSV.

01OF 04

It is in the first column, named WKT, written as WKT text.

Yes, when the source names a system. They are converted to WGS 84 longitude and latitude. If no system is named, they stay as they are.

They keep their row. The WKT cell is empty.

Lists and nested values are written as JSON text in their cell.

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