JSON to TSV Converter
Turn a JSON array of objects into tab-separated values for a spreadsheet.
How to use the JSON to TSV Converter
- Paste a JSON array of objects.
- The header row is built from all the keys used.
- Copy the TSV into your spreadsheet.
About the JSON to TSV Converter
The JSON to TSV Converter flattens a JSON array of objects into tab-separated values you can paste straight into a spreadsheet. The header row is built from the union of every key used across all your objects, so even if some records include fields that others omit, no column is silently dropped. Missing values simply leave that cell empty.
Because a spreadsheet cell holds a single flat value, any nested object or array is JSON-stringified into its cell rather than being expanded, which keeps the table rectangular and predictable. The tool expects an array of objects as input, since that is the shape that maps cleanly onto rows and columns; a single object or a bare value has no natural table form.
Everything runs in your browser, so nothing you paste is uploaded. Paste your JSON array, then copy the TSV into Excel, Google Sheets or Numbers. For the reverse trip, the TSV to JSON Converter reads tabbed data back into JSON, and if you prefer comma-separated output the JSON to CSV Converter does the same job with commas.
Frequently asked questions
How is the header row decided?
The header is the union of every key that appears across all objects in your array. If one record has a field the others lack, that field still gets its own column, and rows without it are left blank there.
What happens to nested objects and arrays?
Nested values are JSON-stringified into a single cell rather than being spread across extra columns. This keeps the output rectangular so it drops cleanly into a spreadsheet without misaligned rows.
What input does the converter expect?
It expects a JSON array of objects, since that shape maps directly onto rows and columns. A single object or a plain value has no natural table form, so wrap your records in an array first.
Why TSV instead of CSV?
Tab-separated values paste cleanly into spreadsheet programs and avoid the quoting headaches that commas inside text can cause. If you specifically need commas, use the JSON to CSV Converter instead.
Is my JSON sent anywhere?
No. The conversion is done entirely in your browser and nothing is uploaded, so it is safe for data you would not want to send to a third party.