Analysing location data
Convert a GeoJSON of points to CSV and open it in a spreadsheet to sort, filter or join the locations to other data.
GeoJSON to CSV
Convert GeoJSON point features to CSV in your browser, with longitude, latitude and properties as columns.
Maintained by Roshan.
Use GeoJSON to CSV
Converts geojson to csv in this tab, with nothing sent anywhere.
Runs entirely on your deviceThe conversion happens in this browser tab. Nothing you type is uploaded, logged or stored, which is worth knowing for anything you would not paste into a search box.
Explore developer and data tools
Find related browser-local tools for nearby tasks without starting another search.
Browse all developer and data toolsAbout GeoJSON to CSV
GeoJSON is the format mapping tools speak - a structured way to describe geographic features and their properties - but to analyse location data in a spreadsheet, join it to other records, or feed it into a tool that expects a table, you need it flattened into rows. This converts the point features of a GeoJSON document into CSV, with a longitude and latitude column and a column for each property the features carry. It gathers the union of properties across all features, so a field present on only some of them still gets a column, and every point lands in a tidy table. Location traces and datasets can be sensitive - where people or assets are - so like the other interchange tools, this runs entirely in your browser.
Work through the input
- The GeoJSON is parsed and its feature collection read.
- The properties across all features are gathered, so a field on only some features still becomes a column.
- Each point feature becomes a row, leading with its longitude and latitude.
- The remaining columns are filled from each feature's properties, blank where a feature lacks one.
- Values containing commas or quotes are escaped so the CSV stays valid.
When geojson to csv is useful
Preparing points for import
A tool that takes CSV but not GeoJSON accepts the flattened table, with coordinates and properties in columns.
Check the output
- It converts point features. Lines and polygons, which have many coordinates rather than one, are not flattened into this simple lat/lon table.
- Longitude comes before latitude in the output, matching GeoJSON's coordinate order, which is the reverse of how people often say 'lat, long'.
- Nested property values are written as their JSON text, since a CSV cell is flat.
- A feature with no geometry, or a non-point geometry, is skipped.
- The output flattens points for analysis; the full geometry of complex features is not represented.
Questions about GeoJSON to CSV
Does it handle lines and polygons?
No. It flattens point features. Lines and polygons have many coordinates and do not fit a single lat/lon row.
What order are the coordinates?
Longitude then latitude, matching GeoJSON. Note that is the reverse of the common spoken 'lat, long'.
What happens to properties?
Each becomes a column, gathered across all features so partial fields are still included.
What about nested property values?
They are written as JSON text, since a CSV cell is flat.
Related tools
CSV to GeoJSON
Convert a CSV with latitude and longitude columns to GeoJSON in your browser, ready for mapping tools.
GPX to GeoJSON
Convert a GPX GPS track or waypoints to GeoJSON in your browser, ready for mapping tools.
JSON to CSV Converter
Convert JSON objects to UTF-8 CSV in your browser. Union columns, quote values, and protect formula-like strings.