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?

Improve this question
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 '15 at 17:00
  • Yes plenty of ways – If you do not know- just GIS Dec 25 '15 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 '15 at 16:58
  • 1
    Please use the edit button beneath your question to revise it with any additional details like these. – PolyGeo♦ Dec 26 '15 at 7:56
  • @EF1897 did any of these solutions work for you? Thanks! – DPSSpatial Jul 6 '16 at 20:51
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)
Improve this answer
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.

Improve this answer
1

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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