How is this different from JSON to CSV?

Only the delimiter changes: fields are separated by tabs instead of commas. The flattening and column-collection logic are identical.

What happens to nested objects?

They're flattened using dot notation, so {"user":{"name":"Ada"}} produces a column named user.name.

What if different objects in the array have different keys?

The output includes every key seen across all objects as a column; rows missing a given key get an empty cell there.

What if a value is itself an array?

Array values are serialized as a compact JSON string within their single cell, rather than being split across multiple columns.

JSON to TSV Converter - Convert Online

Overview

Introduction

Pasting data into a spreadsheet often goes more smoothly as tab-separated text than comma-separated, especially when values might contain commas. This tool flattens a JSON array directly into that format.

It handles nested objects by flattening them into dot-notation column names, so structured JSON becomes a flat, spreadsheet-friendly table.

What Is JSON to TSV Converter?

A JSON-to-TSV converter that treats a top-level JSON array as a set of rows (or wraps a single object as one row), collects every key seen across all rows as a column, and writes tab-separated output with a header row.

It's the tab-delimited sibling of JSON to CSV, sharing the same flattening logic.

How JSON to TSV Converter Works

Each object in the array is recursively flattened: nested object keys are joined with dots (user.name), while array values are serialized as a compact JSON string rather than expanded into more columns.

The union of all flattened keys across every row becomes the column list, and each row's cells are written in that consistent column order, tab-separated, with values needing escaping wrapped in quotes.

When To Use JSON to TSV Converter

Use it when you want to paste JSON API data directly into a spreadsheet application as neatly aligned columns.

It's also useful for quickly eyeballing a JSON array's shape as a table rather than nested braces.

Often used alongside TSV to JSON Converter, JSON to CSV Converter and JSON to Properties Converter.

Features

Advantages

Automatically flattens nested objects into readable dot-notation columns.
Collects a consistent column set even when rows have differing keys.
Tab delimiting avoids quoting issues for values that already contain commas.

Limitations

Array values within a row are serialized as a JSON string in one cell, not expanded into further columns.
Very deeply nested objects can produce long, unwieldy column names.

Examples

Converting an array of records

Input

[{"id":1,"name":"Ada Lovelace","active":true},{"id":2,"name":"Alan Turing","active":false}]

Output

id	name	active
1	Ada Lovelace	true
2	Alan Turing	false

Each object becomes one row, with a shared header row of column names built from the object keys.

Best Practices & Notes

Best Practices

If your target system expects comma-separated values instead, use JSON to CSV.
Check for arrays nested inside your objects; they'll appear as a single JSON-string cell rather than separate columns.
Flatten deeply nested structures manually first if the auto-generated dot-notation column names get unwieldy.

Developer Notes

This tool is a thin wrapper around the JSON to CSV converter's core logic, passing "\t" as the delimiter option; sharing one flattening implementation between the CSV and TSV variants keeps their behavior (column collection, nested-object flattening, array serialization) guaranteed identical.

JSON to TSV Converter Use Cases

Pasting a JSON API response directly into a spreadsheet as a table
Preparing tab-separated data for a system that expects TSV specifically
Quickly reviewing a JSON array's shape in tabular form

Common Mistakes

Expecting nested arrays to expand into multiple columns; they're serialized as a single JSON-string cell.
Converting a single JSON object (not wrapped in an array) and being surprised the output is just one data row.
Assuming column order is guaranteed to match key order in the original objects; it follows first-appearance order across all rows.

Tips

If you plan to re-import the TSV, keep the same delimiter choice consistent across export and import.
Pair with TSV to JSON to confirm the round trip preserves your data as expected.

JSON to TSV Converter