RUZIBA TOOLSExplore tools

JSON to CSV converter

Convert an array of objects to CSV.

Stay alertIn development
ScamPause app icon
RUZIBA · IN DEVELOPMENT

ScamPause

A RUZIBA product in development to help people pause before responding to suspicious messages.

Sell simplyAvailable now
SimpleSeller app icon
RUZIBA · ON GOOGLE PLAY

SimpleSeller

Make selling a little simpler. Create listings and keep the details together.

Get it on Google PlayApp Store: coming soon
QR code: scan to open SimpleSeller on Google Play

How the JSON to CSV conversion works

Paste a JSON array of objects into “JSON array of objects” and press Convert to CSV. The CSV result box fills in and a Download CSV button appears, which saves a file named data.csv. The column headers are the object keys in the order they first appear across all objects; an object without a key gets an empty cell. Every cell is wrapped in double quotes with any quote inside it doubled, rows are separated by CRLF line breaks, null becomes an empty cell, and a nested object or array is written into its cell as JSON text. Large whole numbers are kept digit for digit.

For example, [{"id":1,"name":"Ada, L.","tags":["x","y"]},{"id":2,"name":"Sam \"S\"","note":null}] gives the header "id","name","tags","note", the first row "1","Ada, L.","[""x"",""y""]","" and the second row "2","Sam ""S""","","", with the message “2 rows converted.” The comma in “Ada, L.” stays inside its cell because the cell is quoted.

The top level must be an array of objects; a single object or an array of arrays shows “Enter a JSON array of objects.” Nested values are not spread into extra columns, so flat records convert best. Numbers are written as quoted text, so check how your spreadsheet or import tool treats quoted fields. The conversion runs in your browser and the JSON is not uploaded.