Examples
-
Array of objects
[{"id":1,"name":"A"},{"id":2,"name":"B"}]
About JSON to CSV
A REST API happily returns arrays of objects; a spreadsheet only understands rows and columns. Getting from one to the other by hand means a lot of copy-pasting into the wrong cells.
Paste a JSON array of objects and get back comma-separated rows ready for Excel, Sheets, or a quick data review. It works best on uniform arrays - deeply nested objects get flattened, so simplify complex trees first if the output looks sparse.
FAQ
- What about nested objects?
- Deep nesting may produce wide or sparse columns; flatten complex trees in JSON first if needed.