JSON to TSV

Your files never leave your device.

Choose a format
Choose a format

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.