GeoJSON to CSV Converter
Convert web JSON spatial objects into spreadsheet rows.
Export web-based geodata into easy-to-use tabular formats. This upcoming converter parses nested JSON properties and formats them as flat CSV spreadsheet columns, complete with coordinate fields.
Drag file here to convert, or select file
Supported file extension: .geojson, .json • Max 50MB
Specification Rules
- Analyze crowdsourced map parameters in spreadsheets
- Format JSON databases for bulk database imports
- Process spatial data in statistical analysis software
- Lines and polygons convert to complex WKT strings
- Deeply nested JSON structures are flattened during processing
- Special characters are subject to encoding issues
GDAL Direct Equivalent Terminal Command
When to use this conversion
Convert when GeoJSON attribute data needs to be opened in Excel or fed into a statistical package. Useful for handing web-collected data to non-GIS analysts. Note that geometry must be flattened to coordinates or WKT, which limits this conversion to point-like data.
Technical Details
CSV is typically 40–70% the size of the source GeoJSON. Dropping JSON structural markup saves a lot; the savings shrink if WKT geometry is included.
Common Errors & Fixes
- Nested JSON stringified ugly: arrays and objects become quoted strings. Fix: flatten the source GeoJSON's properties first.
- Polygon WKT enormous: GeoJSON polygons become very long WKT strings in CSV. Fix: drop geometry or use GeoPackage if you need it.
- Decimal separator locale issue in Excel: same as csv-to-X conversions. Fix: configure Excel locale or use semicolon separator.
- Mixed-geometry FeatureCollection breaks AS_XY: only points work. Fix: filter to point features first.
Alternative Tools
- QGIS: open .geojson, export as CSV
- ogr2ogr CLI: ogr2ogr -f CSV output.csv input.geojson -lco GEOMETRY=AS_XY
- Python: geopandas.read_file then .to_csv (or .drop('geometry').to_csv to drop geometry)
- jq + custom shell: jq '.features[] | .properties' for properties-only export
Frequently Asked Questions
Can I convert complex nested properties?
Yes, nested JSON tags flatten out, mapping to custom column structures dynamically.
Does this tool support spatial lookups?
Our upcoming interface will offer options to preserve spatial variables within coordinate entries.
Is the output compatible with office software?
Yes, the generated CSV files are structured cleanly, ensuring compatibility with tools like Microsoft Excel.