GeoJason

GeoJSON to Lat/Long Extractor

Extract latitude and longitude coordinates from GeoJSON features into a table or CSV.

How Coordinate Extraction Works

This tool reads all Point geometries from your GeoJSON and outputs their coordinates as a CSV table with latitude and longitude columns. For non-point geometries (LineStrings, Polygons), vertex coordinates are extracted individually.

The output uses latitude, longitude order (the conventional format for spreadsheets and most non-GIS applications), reversing the [longitude, latitude] order used internally by GeoJSON.

Output Format

The result is a CSV with a header row followed by one coordinate pair per line:

CSVlatitude,longitude
40.7484,-73.9857
34.0522,-118.2437

You can download this as a .csv file and open it directly in Excel, Google Sheets, or any data analysis tool.

Common Use Cases

  • Exporting GeoJSON point data to a spreadsheet for reporting
  • Creating address lists from geocoded GeoJSON features
  • Feeding coordinates into geocoding or reverse-geocoding APIs
  • Sharing coordinate data with team members who do not use GIS tools

To convert coordinates back to GeoJSON, use the lat/long to GeoJSON converter.

Try It

Paste this GeoJSON FeatureCollection containing two US landmarks. The tool extracts each Point coordinate and outputs a CSV:

GeoJSON{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      "properties": { "name": "Empire State Building" },
      "geometry": {
        "type": "Point",
        "coordinates": [-73.9857, 40.7484]
      }
    },
    {
      "type": "Feature",
      "properties": { "name": "Hollywood Sign" },
      "geometry": {
        "type": "Point",
        "coordinates": [-118.3217, 34.1341]
      }
    }
  ]
}

The resulting CSV output:

CSVlatitude,longitude
40.7484,-73.9857
34.1341,-118.3217

The GeoJSON [longitude, latitude] order is reversed to the more common latitude-first order that spreadsheets and non-GIS tools expect.

How the Extraction Works

The tool iterates over every Feature in the input GeoJSON. For Point geometries, it reads the coordinate array and swaps the values to latitude-first order. For LineString and Polygon geometries, each vertex coordinate is extracted as a separate row. The output includes a header row (latitude,longitude) followed by one row per coordinate pair.

This tool pairs well with the GeoJSON viewer for verifying point locations before export. For details on coordinate ordering conventions, see the GeoJSON Specification Guide.