BYTETOOLS

GeoJSON to CSV Converter

Flatten a GeoJSON FeatureCollection into a CSV table with one row per feature, a centroid for lines and polygons, and every property as a column.

Drop a .geojson file here, or click to browseConverted locally — the file is never uploaded

Output options

Paste a FeatureCollection or drop a .geojson file to flatten it into one row per feature.

What is the GeoJSON to CSV Converter?

This converter turns a GeoJSON FeatureCollection into a flat table with one row per feature. Point features keep their exact coordinates; lines get the point half way along their length and polygons get the area-weighted centroid of their outer ring, so every feature ends up with one longitude and latitude you can plot or join on.

  • One row per feature with a plottable longitude and latitude for every geometry type
  • Area-weighted centroid for polygons and length-weighted midpoint for lines
  • Every property key across the file unioned into columns, blank where absent
  • Optional geometry_type column and full WKT geometry column
  • Comma, semicolon, tab or pipe delimiters with RFC 4180 quoting
  • Handles a bare Feature or a bare geometry as well as a FeatureCollection
  • Entirely client-side — your data never leaves the browser

How to use the GeoJSON to CSV Converter

  1. 1

    Drop a .geojson file onto the box, or paste the FeatureCollection into the text area.

  2. 2

    Choose a delimiter and how many decimal places to keep on the coordinates.

  3. 3

    Tick the geometry_type and WKT columns if you need the shape as well as a point.

  4. 4

    Review the preview, then copy the CSV or download the .csv file.

About the GeoJSON to CSV Converter

This converter turns a GeoJSON FeatureCollection into a flat table with one row per feature. Point features keep their exact coordinates; lines get the point half way along their length and polygons get the area-weighted centroid of their outer ring, so every feature ends up with one longitude and latitude you can plot or join on.

Every property key found anywhere in the file becomes a column, with blanks where a feature does not have it — so a mixed collection still produces a rectangular table. Add an optional geometry_type column and a full WKT geometry column when you need to keep the shape as well as the position.

It is the quickest way to get GeoJSON into Excel, pandas, a BI tool or a database load script. The parsing and flattening happen entirely in your browser and nothing is uploaded.

Frequently asked questions

How do I open a GeoJSON file in Excel?

Excel cannot read GeoJSON directly. Convert it to CSV here and open the .csv — each feature becomes a row with its properties as columns and a longitude and latitude you can map or pivot on.

What coordinate is used for a polygon?

The area-weighted centroid of its outer ring, computed with the shoelace formula. For a convex shape that is the visual centre; for a crescent or a doughnut the centroid can fall outside the polygon itself, which is a property of centroids rather than a bug.

Does the conversion lose my geometry?

Only if you want it to. By default each row carries one representative point, which is all a spreadsheet can plot. Tick the WKT column and the full geometry travels with the row, so you can load it straight back into PostGIS or QGIS.

What happens to features with different properties?

Every key found anywhere in the file becomes a column, and any feature that lacks it gets an empty cell. The table stays rectangular, which is what spreadsheets and dataframes need, and no attribute is dropped.

What about features with a null geometry?

The row is still written, with blank longitude and latitude, so the attributes are not lost. The count of such features is shown above the output so you know how many are unmappable.

Related tools