GeoJSON to CSV
Flattens a GeoJSON FeatureCollection, single Feature or array of Features to CSV: one row per feature, properties as columns, longitude and latitude for points and an optional WKT column.
Use the tool
Why this tool exists
GeoJSON is the format for web maps, but analysts, spreadsheets and databases want rows and columns. Opening a file with nested properties in Excel is no help, and a quick script is more effort than it should be. Paste the GeoJSON here and each feature becomes a row. Properties become columns, with nested objects flattened into dotted names. Point features get longitude and latitude columns, and every geometry can also be written as WKT, which many databases can import. You can pick the delimiter. It does not reproject coordinates or simplify shapes, so output is in the coordinate system of the source, normally WGS 84. The conversion runs in your browser and your data is not uploaded.
How to use it
- Paste the GeoJSON, a FeatureCollection, a Feature or an array of Features, into the input box.
- Choose whether to include a WKT geometry column and set the delimiter.
- Copy the CSV or save it for use in a spreadsheet or database.
Frequently asked questions
How are nested properties handled?
Nested objects are flattened into dotted column names, such as tags.capital. Features with different properties get all columns, left empty where missing.
What happens to lines and polygons?
They have no single longitude and latitude, so those columns stay empty. Use the WKT column to keep the full geometry.
Does it change coordinates?
No. Coordinates are written exactly as they appear in the file. GeoJSON normally uses longitude then latitude order in WGS 84, so check the column order if you import the CSV elsewhere.
Can I convert CSV back to GeoJSON?
Yes, for points with the CSV to GeoJSON tool on this site, which reads latitude and longitude columns or a WKT POINT column.