jsonecho

JSON to TSV

Convert JSON records to tab-separated values that paste cleanly into a spreadsheet.

Loading the tool...

How to use JSON to TSV

Paste your JSON array.
Copy the TSV output.
Paste into Excel, Google Sheets or Numbers.

About JSON to TSV

TSV is CSV with tabs in place of commas. That sounds minor, but it solves a real problem: tabs almost never appear inside normal text, so you rarely run into quoting issues, and spreadsheets understand tab-separated text when you paste it. Select the result, copy, click into cell A1 and paste.

Nested JSON is flattened to dotted column names, the same way as in the JSON to CSV tool. Columns are collected from every record.

Frequently asked questions

Why use TSV over CSV?

Because commas are common in real data (addresses, descriptions) and tabs are not. TSV avoids most escaping trouble and pastes straight into spreadsheet cells.

What if my data contains tabs?

Fields with tabs, quotes or line breaks are quoted, so the table stays aligned.

Can I save it as a file?

Yes, Download gives you a .tsv file, which Excel and Google Sheets can both import.

More in Converters

All tools →

JSON to XMLConvert JSON to indented XML with a custom root element.Convert JSON to YAMLConvert JSON to clean, readable YAML.Convert JSON to StringConvert JSON into an escaped string for code and configs.Convert String to JSONUnescape a JSON string and format it as readable JSON.Convert JSON to Markdown TableConvert JSON into a neatly aligned Markdown table.Convert XML to JSONConvert XML to JSON, keeping attributes and repeated elements.Convert XML to CSVConvert repeating XML elements to CSV rows.Convert XML to YAMLConvert XML to readable YAML.Convert