Home / JSON ⇄ CSV Converter
JSON ⇄ CSV Converter
Convert JSON arrays and CSV/TSV in either direction. You can also paste straight from Excel or Google Sheets.
Choose a mode and paste your data to try it.
Convert between JSON and CSV
Convert an array of objects (JSON) and tabular CSV/TSV in either direction. Use the tabs above to switch the direction.
Paste straight from Excel
When you select a range in Excel or Google Sheets and copy it, the cells are tab-separated (TSV). Choose “Delimiter = Tab” and paste to convert it directly into JSON.
Handling nested JSON
For JSON → CSV, nested objects are flattened into dotted column names such as parent.child. Values that are arrays are stored in the cell as a JSON string.
Automatic type detection
For CSV → JSON, numbers, true/false and null are detected and converted automatically (values like zero-padded numbers are kept as strings).
FAQ
Can I turn data copied from Excel into JSON?
Yes. Copying from Excel produces tab-separated data, so choose “Delimiter = Tab” and paste to convert it into JSON.
Can nested JSON be converted to CSV?
Nested objects are flattened into “parent.child” column names. Arrays are stored in the cell as a JSON string.
Are numbers and booleans in CSV detected automatically?
Yes. Numbers, true/false and null are detected automatically. Values like zero-padded numbers are kept as strings.
Is it free to use?
Yes. It is free, requires no sign-up, and all processing happens in your browser.