Free online GEOJSON to CSV converter

GeoJSON is a widely used geospatial data format based on JSON, designed to store geographic features such as points, lines, polygons, and their properties. CSV is a simple comma-separated values format used for tabular data, where each row represents a record and columns store attributes. Converting GeoJSON to CSV is useful when you want to analyze feature attributes in spreadsheets, databases, or BI tools, while keeping only the tabular information from the geographic dataset.

Why convert GeoJSON to CSV

GeoJSON files often contain both geometry and attribute data. CSV is better when you need to:

• Inspect feature properties in Excel or Google Sheets
• Import data into databases or reporting tools
• Share tabular records without map geometry
• Clean and filter attribute values more easily

Keep in mind that CSV does not preserve geometry in native spatial form. Coordinates may be exported into columns, but spatial structure is usually flattened.

How the conversion works

During conversion, each GeoJSON feature typically becomes one CSV row. Common fields include:

• Feature properties such as name, type, category, or ID
• Geometry columns such as longitude, latitude, or coordinate arrays
• Nested attributes flattened into separate columns when possible

If the GeoJSON contains Point features, conversion is straightforward because coordinates can be split into longitude and latitude. For LineString or Polygon features, the geometry may need to be simplified, summarized, or exported as WKT or JSON strings depending on the converter.

Best software for conversion

The best choice depends on whether you want a quick online conversion or a professional desktop workflow:

• QGIS — best free desktop option for accurate geospatial conversion and attribute export
• GDAL/ogr2ogr — best command-line tool for batch conversion and automation
• Mapshaper — excellent for fast browser-based conversion and geometry cleanup
• MyGeodata Converter — convenient online converter for simple workflows

Recommended choice: QGIS is the most reliable all-around solution if you need control over fields, geometry handling, and export settings.

How to convert in QGIS

1. Open QGIS and load the GeoJSON file.
2. Right-click the layer and choose Export → Save Features As...
3. Select Comma Separated Value [CSV] as the format.
4. Choose the output location and configure geometry export options.
5. Click OK to create the CSV file.

If you want coordinates in separate columns, choose the appropriate geometry export setting, such as AS_XY for point data.

How to convert with ogr2ogr

For command-line users, ogr2ogr is a powerful and efficient option. A typical conversion command looks like this:

ogr2ogr -f CSV output.csv input.geojson

This creates a CSV file from the GeoJSON source. For point data, you may need additional options to include geometry columns in a useful form.

Things to watch for

• Nested properties may be flattened or lost depending on the converter
• Multiple geometries can be difficult to represent in a single CSV row
• Coordinate reference systems may need checking before export
• Large files are better handled with desktop tools or command-line utilities

If your goal is to preserve full spatial information, consider exporting to GeoPackage or Shapefile instead. If your goal is analysis in spreadsheets, CSV is a practical and lightweight choice.

Summary

GeoJSON to CSV conversion is ideal when you need to turn geographic features into a tabular format for analysis, reporting, or data exchange. For the best balance of accuracy and flexibility, QGIS is the top recommendation, while ogr2ogr is excellent for automation and batch processing.