How to use it
- Paste your JSON into the input box, upload a .json file, or drop a file onto the box.
- The TSV appears as you type.
- Copy the result or download it as a .tsv file.
Good to know
- Nested objects become dotted column names, so supplier.city gets its own column. Arrays become numbered columns: tags.0, tags.1 and so on. If the data is a list, each entry becomes one row.
About the formats
JSON
JSON (JavaScript Object Notation) stores data as nested objects and arrays. It is the standard format for web APIs and the config files of most JavaScript projects.
TSV
TSV (tab-separated values) is like CSV but uses tabs between columns. It is what you get when you copy cells out of Excel or Google Sheets, and it avoids quoting problems when your text contains commas.
Questions
- Is my data uploaded anywhere?
- No. The conversion runs in your browser with JavaScript. Your data never leaves your device, and the tool keeps working if you lose your connection after the page has loaded.
- What happens to nested JSON?
- It is flattened. Each nested value gets a column named after its path, such as supplier.city or tags.0. Empty lists and empty objects become empty cells.
- Can I convert TSV back to JSON?
- Yes. Use the TSV to JSON converter, or press the swap button above the editor.