Conversion

JSON to TSV

Convert a JSON array to tab-separated values. Paste the result directly into Excel or Google Sheets.

JSON Input

TSV Output

id	name	city	score
1	Alice	New York	98
2	Bob	London	87
3	Charlie	Tokyo	92

Paste Into Sheets

Copy the TSV output and paste it into any spreadsheet application. Excel, Google Sheets, Numbers, and LibreOffice Calc all accept tab-separated clipboard data natively.

Tab Characters in Data

If a value contains a tab character, it is replaced with a space to preserve the TSV structure. For data with many special characters, use JSON to CSV instead. To go back from TSV to JSON, use TSV to JSON.

Nested Values

Nested objects and arrays are stringified as compact JSON within the cell. For a flat structure, flatten your JSON before converting.