GeoJSON to CSV Converter

How to convert GeoJSON to CSV

1. Load the file. Drop a .geojson or .json file onto the box above, or click it to browse. It can be a FeatureCollection, a single Feature or a bare geometry.
2. Check the preview. The page shows the first rows of the table it will write: coordinates, geometry type and one column per property.
3. Choose the options. Decide what the longitude and latitude columns hold for lines and polygons, whether to add a WKT column, how nested properties are handled, and which separator to use.
4. Download. Click Download CSV. Open it in Excel, Google Sheets or any database tool.

What the CSV contains

Every feature becomes one row. The columns are:

Lines and polygons

A spreadsheet row holds one pair of coordinates, so a line or polygon cannot be written out vertex by vertex in the longitude and latitude columns. The page keeps the shape in the WKT column and puts one representative position in longitude and latitude, so you can still map or sort the rows. Treat that position as a label point, not as a measurement: the mean of the vertices is not guaranteed to lie inside a polygon.

Nested properties

GeoJSON properties can contain objects and lists, which a flat table cannot. With Flatten nested properties ticked (the default), an object such as {"address": {"city": "Bhilwara"}} becomes a column called address.city. Lists are written as JSON text in one cell. Untick the option to write each nested object as JSON text in a single column instead.

Common problems and how to fix them

Accented characters look broken in Excel

Leave Excel-friendly UTF-8 ticked. It adds a byte-order mark so Excel reads names such as Café correctly.

Everything lands in one column

Some regional versions of Excel expect a semicolon as the separator. Change the separator to Semicolon and download again.

Text starting with an apostrophe

Text that begins with =, +, - or @ gets an apostrophe in front, so a spreadsheet does not run it as a formula. Plain numbers are not changed.

Polygons have only one coordinate

That is how a table works. Tick Add a WKT column to keep the full shape.

The page says the coordinates are not longitude/latitude

GeoJSON uses WGS 84 longitude and latitude. Large numbers mean the file is in a projection. Reproject it first with the CRS Converter.

What this converter does and does not do

• One row per feature. A MultiPoint or MultiPolygon is one row, with its first vertex or centre in the coordinate columns and every part in the WKT column.
• Elevation is written only for the first vertex, and is not part of the WKT.
• CSV only. For an Excel workbook, open the CSV in Excel and save it as .xlsx.
• Runs in your browser. Nothing is uploaded and there is no signup, so the practical size limit is your computer's memory.

GeoJSON or CSV: what is the difference?

GeoJSON is a map format with real geometry and nested properties. A CSV is a flat table that opens in any spreadsheet or database. Convert to CSV to work with the attributes in a spreadsheet, to count or filter features, or to share the data with someone who does not use GIS software. To make a map from a table again, use CSV to GeoJSON.