1

I am trying to convert OpenStreetmap data GeoJSON to Excel (or .csv files). Few online converters are there.

However, when the file is big (example: 6Mb Geojson), the browser is becoming unresponsive. So I am looking for converters that will handle big files. My current software, Opal converter, is unresponsive when converting big files.

Is there any windows desktop software available to convert GeoJSON greater than 6Mb to Excel/CSV?

5
  • Welcome to GIS SE. As a new user, please take the Tour. In the words of the Tour: Include details about what you have tried and exactly what you are trying to do. I'm quite sure there are many GIS and non-GIS packages capable of achieving your goal. The exact details are dependent on what you mean by "Excel/CSV", since that encompasses thousands of potential formats.
    – Vince
    Dec 24, 2015 at 17:00
  • Yes plenty of ways Dec 25, 2015 at 0:08
  • 1
    I am actually trying to convert OpenStreetmap data GeoJson to Excel. Few online converters are there. But when the file is big (ex.6MB Geojson), browser is becoming unresponsive. So i am trying to good converters that will handle big files. I have one software Opal converter which is also unresponsive when converting big files!!
    – EF1897
    Dec 25, 2015 at 16:58
  • 1
    Please use the edit button beneath your question to revise it with any additional details like these.
    – PolyGeo
    Dec 26, 2015 at 7:56
  • @EF1897 did any of these solutions work for you? Thanks! Jul 6, 2016 at 20:51

3 Answers 3

4

Using QGIS, load the GeoJSON as a standard vector layer.

Right click - save as - Format = Comma Separated Value (CSV)

If you want to take the geometry with you, you have under Layer Options:

GEOMETRY:

  • as XY (best for point data)
  • as WKT (will write out something you can more easily port back over to geometry later if using lines, polygons, etc)
3

The usual answer to any vector reformatting question is ogr2ogr. It will work here too. Use OSGeo4w to install it on a windows box.

1

http://geojson.io/ lets you upload a file and save it as a CSV (as well as TopoJson, KML, WKT and so on)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.