Open GeoJSON as a table
GeoJSON is the format of web maps and open data APIs: city bike stations, building permits, flood zones. Opened in a text editor it is a wall of brackets, and in a generic JSON viewer the coordinates swallow the screen. What you usually want is the list of features with their properties — a table.
Free to use. The file is read in your browser and never uploaded. Windows version — 4.9 MB, no installation: details. Pro — $29 once: price.
What the table looks like
A file with "type": "FeatureCollection" — named .geojson or plain .json — opens with one row per feature:
| Column | Where it comes from |
|---|---|
id | The feature’s id, when the file has one |
| Each property | properties of the feature; nested objects become columns with a dot, e.g. address.city |
geometry | The type: Point, LineString, Polygon, MultiPolygon… |
lon, lat | The coordinates of a Point (GeoJSON always stores longitude first) |
points | How many vertices the other geometries have |
Columns appear only when needed: a layer of polygons gets no empty lon/lat. If a property already has one of these names, the geometry column becomes geometry.lat and so on — nothing is overwritten.
Useful checks
- Features without geometry have an empty
geometrycolumn: filter on it to find them. - Swapped coordinates. Sort by
lat: values outside −90…90 mean the file stores latitude and longitude the wrong way round. - Heavy shapes. Sort by
pointsto find the polygons that make a web map slow. - The original feature. “Record bytes” in the side panel shows the feature exactly as it is in the file, coordinates included.
Export
Export to Excel, CSV or Parquet takes the table as you see it: properties, geometry type, point coordinates. That is the quick way to turn a GeoJSON of points into a spreadsheet with latitude and longitude columns. Polygons are exported as their summary, not as coordinates.
For other JSON shapes see nested JSON to a table and JSON to CSV.
FAQ
Can I edit the GeoJSON and save it?
No, it opens read-only: the geometry is shown as a summary, and writing the table back would lose the shapes.
Does it read GeoJSON Lines (one feature per line)?
Such a file opens as JSON Lines: a row per line, with the geometry as nested columns rather than the summary.
How large a file can it open?
The whole document is parsed in memory, so files of a few hundred megabytes are the practical limit.
Is the file uploaded?
No. It is parsed in your browser tab.
Free to use. Your file is not uploaded to a server. Windows version — 4.9 MB, no installation: details. Pro — $29 once: price.