WebToolsPlanet
Converter Tools

JSON to TSV Converter

Paste a JSON array of objects and get Tab-Separated Values — ready to paste into Excel, Google Sheets, or any tab-delimited consumer.

Last updated: May 27, 2026

Client-Side Processing
Input Data Stays on Device
Instant Local Execution
Something wrong with this tool? Report it

Find this tool useful? Support the project to keep it free!

Buy me a coffee

What is JSON to TSV Converter?

Tab-Separated Values (TSV) is the simplest table format: rows are separated by newlines and columns by tab characters. It has no quoting rules (unlike CSV), which makes it easy to parse but means any tab or newline inside a value must be escaped before being written. Spreadsheets like Excel and Google Sheets accept TSV out of the box, so it's the format of choice for "paste this data into a sheet" workflows.

This converter reads a JSON array of objects, collects every unique key across all rows to form the column header, and writes each row's values in the same column order. Missing keys produce empty cells. Tabs, carriage returns, and newlines inside string values are escaped (`\t`, `\r`, `\n`) so the output stays parseable.

How to Use JSON to TSV Converter

1

Paste a JSON array of objects into the input panel.

2

Toggle "Include header row" to add or remove the column names line.

3

Choose how to render nested objects: as JSON strings, or flattened with a dotted-path separator.

4

Copy the TSV output and paste into your spreadsheet.

Common Use Cases

  • Pasting JSON data into Excel, Google Sheets, or Numbers.
  • Producing a tab-delimited file for a downstream load script.
  • Exporting an API response as a quick table for reporting.
  • Generating tab-delimited fixtures for tests.

Example Input and Output

A JSON array becomes a TSV table with a header row.

JSON input
[{"id":1,"name":"Alice"},{"id":2,"name":"Bob"}]
TSV output
id	name
1	Alice
2	Bob

Privacy

All conversion happens in your browser. No JSON is sent to a server.

Pasting into Excel

After copying the TSV output, select a starting cell in Excel and paste — Excel will split tab-separated values across columns automatically. No "Text to Columns" needed.

Frequently Asked Questions

What if my rows have different keys?

The tool collects all unique keys across all rows and uses that as the column set. Rows missing a key produce empty cells for that column.

How are nested objects handled?

Two modes: "Render as JSON string" embeds the nested object as a JSON string in the cell; "Flatten" expands nested keys into dotted-path columns like address.city, address.zip.

Why TSV instead of CSV?

TSV has no quoting rules, so it is simpler to read and write. The trade-off is that any embedded tab or newline must be escaped. If your data already contains literal tabs, CSV may be a better fit.

Does this send my JSON anywhere?

No. All conversion happens locally in your browser.

Related Tools

Part of a Collection