JSON to TSV
Convert to
Tools for this file
Your files never leave your device.
Every key becomes a column. Nested objects and lists are written into their cell as JSON text.
Questions about JSON to TSV
How does JSON to TSV work?
JSON to TSV turns JSON data into a tab-separated table, with the keys as the header row. The file is UTF-8 with Windows line endings, and values are quoted only where they need it.
What happens to nested objects?
They aren't spread across extra columns. A value such as {"city": "Leeds"} or ["a", "b"] is written into a single cell as compact JSON text, for example {"city":"Leeds"}.
Can I convert a single JSON object rather than a list?
Yes. An object whose values are plain values becomes one row, with its keys as the header. An object whose values are all arrays is treated differently: each key becomes its own table and its own TSV file.
What about an array of plain values like [1, 2, 3]?
Each value goes on its own row in a single column, with no header row added.