GeoJSON to CSV Converter
LocalExport GeoJSON feature attributes to CSV with centroid lon/lat columns — free, no sign-up, nothing uploaded, all in your browser.
Sample data loaded — click "Export CSV" to try it.
Centroid columns are named centroid_lon / centroid_lat. If your attributes already include lon/lat columns, they are kept as-is and no longer collide with the centroid columns.
What is it? GeoJSON to CSV exports feature attributes to a CSV table with centroid longitude/latitude columns (6 decimals, lon,lat or lat,lon order); property columns are unioned across all features with missing values left blank.
TL;DR: Export GeoJSON feature attributes to a CSV table with centroid lon/lat columns — pick lon,lat or lat,lon order, property columns are unioned across features, and the summary line reports the row count and any rows without a centroid. Free with no sign-up; everything runs locally in your browser and nothing is uploaded.
How to use
- Paste your GeoJSON into the input box (a sample is pre-filled), or click "or load a file" to pick/drop a .geojson/.json file.
- Choose the coordinate column order (lon,lat or lat,lon) and click "Export CSV" (or press Ctrl/Cmd+Enter).
- Copy the CSV text or download features.csv — the summary line reports the exported row count and how many rows have no centroid.
FAQ
How is geometry handled?
Geometry is not exported; each row gets centroid columns named centroid_lon / centroid_lat.
What if my attributes already have lon/lat columns?
They are kept as ordinary attribute columns and no longer collide with the centroid columns (previously the duplicate header was written and attribute values were overwritten — fixed).
What happens to nested attributes?
They are not flattened: nested objects show as "[object Object]" and arrays as comma-joined text — flatten your properties before exporting.
Is it local?
Yes.
Can I open the CSV in Excel?
Yes — the output is UTF-8 CSV without a BOM, which Excel, QGIS and Google Sheets all read. For Chinese or other non-ASCII attributes, import via Data → From Text/CSV so the encoding is applied; opening the file directly can garble those cells.
Is there a row or file-size limit?
No upload limit — nothing is uploaded, so the real bound is your device's memory. Parsing and the CSV export run entirely in the browser, and the summary line reports the exported row count.
Which coordinate system are the centroid columns in?
WGS84 (EPSG:4326) longitude/latitude — no reprojection happens and the CSV carries no CRS field. Pick lon,lat or lat,lon order for the centroid columns before exporting.
Examples
- Paste GeoJSON → pick coordinate order → get a CSV attribute table (centroid lon/lat + property columns)
Supported formats
Limitations
- Coordinates are per-feature centroids (fixed 6 decimals, ~0.1 m precision); the centroid columns are named centroid_lon / centroid_lat.
- Existing lon/lat attribute columns are preserved as-is (no longer clobbered by centroid values).
- Nested objects/arrays are not supported: cells show "[object Object]" or comma-joined text — flatten attributes first.
- Attribute columns are the union across all features; missing values are empty, and geometry-less features leave the centroid columns blank — the output summary line reports the row count and how many rows have no centroid (no longer silent).
- For features crossing the ±180° antimeridian, centroid columns are computed in a shifted continuous longitude space and the longitude is renormalized to ±180 (spherical continuity approximated by shifting; a disclosure line appears when it applies).
- The CSV carries no CRS field: the lon/lat columns are WGS84 (EPSG:4326).
- A GeometryCollection is folded into a single centroid row (sub-geometries are not expanded).
- Output is UTF-8 CSV (no BOM); for Chinese text in Excel, import via Data → From Text/CSV.
- No hard MB cap — processing runs locally in your browser, bounded by your device's memory; very large files may be slow or fail to open.
Privacy
Privacy first: this tool runs entirely in your browser — your input and files never leave your device, and everything is cleared when you close the page.