JSON to TSV Converter - Prepare Spreadsheet Rows

JSON to TSV Converter

The JSON to TSV Converter turns a JSON array of objects into tab-separated rows. Use it to prepare data for Excel, Google Sheets, or another tool that accepts tab-delimited input.

Worked Example

This JSON contains two records:

[
  { "name": "Alice", "age": 30, "city": "London" },
  { "name": "Bob", "age": 25, "city": "Paris" }
]

The corresponding table is shown below. The example uses spaces to display columns; actual TSV uses tab delimiters:

name    age    city
Alice   30     London
Bob     25     Paris

How to Convert JSON to TSV

1. Paste an array into JSON Input (Array of Objects), or choose a JSON file.
2. Review TSV Output and compare the headers and rows with the source.
3. Use Copy or Download TSV. If pasting into a spreadsheet, start at the top-left destination cell.

Prepare Data for a Table

An array of flat objects with consistent keys is easier to map to columns than nested or irregular data. Check how the output handles missing keys, null values, and fields that appear only in later records.

Tabs and line breaks inside values need care because they can affect row and column boundaries. TSV avoids using commas as delimiters, but it does not eliminate every escaping or import issue. Check the spreadsheet's interpretation before relying on the table.

Related Tools

For the reverse direction, use the TSV to JSON Converter. For SQL output, try the JSON to SQL Converter.