MotionShine01 / Records
The list is found
A top-level list of objects becomes the rows. If the JSON wraps it, as in {"data": [...]}, that list is used.
Free tool
JSON to CSV, and back.
Paste JSON from an API, an export or a log and get a CSV that opens in Excel, Numbers or Google Sheets. Nested objects become their own columns, lists are joined in one cell, and the list of records is found even when it sits inside the JSON. Paste a CSV instead and it becomes JSON, with numbers and true or false typed for you. A table shows the result before you download.
Your data is converted in your browser. It is never uploaded.
How it is read
Records in, rows out.
02 / Columns
Every key, once
Each key seen in any record becomes a column, in the order first seen. A record without it gets an empty cell.
03 / CSV rules
Quotes done right
Cells with commas, quotes or line breaks are quoted the standard way, so spreadsheets read them as one cell.
Questions
Good to know.
Why do accents look wrong when I open a CSV in Excel?
Excel often guesses an old encoding for CSV files. The Excel-safe option adds a small UTF-8 mark at the start of the file, so names like José and Zoë come through intact.
Excel puts everything in one column. Why?
Where a comma is the decimal mark, as in much of Europe, Excel expects semicolons between cells. Pick Semicolon as the separator and download again.
Can it handle large files?
Files of several megabytes convert in a moment. The table shows the first 100 rows to keep the page quick; the download holds everything.
How does CSV to JSON treat numbers?
Cells that are plain numbers become numbers, true and false become true and false, and empty cells become null. Untick the option to keep every value as text, which is safer for codes like 007 or long ID numbers.
Is my data uploaded?
No. Everything happens in this tab, so exports with customer data stay on your computer.