Convert JSON to CSV
Turn a list of JSON records into a CSV table, read back and checked, without uploading it.
The text is read in this browser tab and kept only while the page is open. Nothing is uploaded or stored.
Structured Data Converter
Paste JSON here
Opening Structured Data Converter…Not responding? Reload the page.
How it works
Three steps, all in your browser
- Step 1Paste the JSONA list of records, or open a .json file
- Step 2Keys become columnsEach record becomes one row
- Step 3Save the CSVRead back and checked, then copy or download
Good to know
The honest limits, before you spend time on it
The JSON it takes
A list of records — [{"name": "Ada", "city": "London"}, …] — or a single object, which becomes one row. Anything else, such as a list of plain values, is refused with the reason, and nothing is converted.
Nested values are set aside
A CSV cell holds one value, so a record that contains an object or a list is not flattened by guesswork. It is left out of the table and listed in Needs Review. If every record is nested, nothing is converted.
Missing keys and null
A record without one of the keys gets an empty cell there, and null becomes an empty cell too; the tool counts both. Columns keep the order in which the keys first appear.
Broken JSON is not guessed at
If the text isn't valid JSON, AMGlide says what is wrong with it and converts nothing. The CSV it does write is read back and compared with the records before it's offered.
Limits
Up to 1,000,000 characters of text, or a text file up to 2 MB.
Beyond this one task
Give AMGlide the text. It works out the rest.
Smart Drop reads what you brought and suggests what fits — then carries it into the next step without asking for it again.