Developer
Encoders, converters & dev utilities
JSON to TSV Converter
Convert a JSON array of objects into TSV (tab-separated values) — the format spreadsheets and data tools accept when you paste directly into a grid, and the safe choice when your data itself contains commas. TSV works exactly like the CSV conversion but uses a TAB character between fields instead of a comma: the header row is the union of all object keys, each object becomes a record, and nested objects are flattened into dotted-path columns (a.b) so nothing is dropped. Fields are quoted following the RFC 4180 rules only when they contain the delimiter, a quote, or a newline. JSON is parsed per RFC 8259. Runs 100% in your browser — nothing is uploaded. Free, no login.
Like JSON→CSV but fields are separated by a TAB (\t) instead of a comma
- Worked example — [{"id":1,"name":"Ada"}] → id⇥name then 1⇥Ada (⇥ = tab)
- Header = union of all object keys; nested objects flatten to dotted columns (a.b)
- RFC-4180-style quoting only when a field contains a tab, a quote, or a newline
- JSON parsed per RFC 8259; 100% client-side — paste-ready into Excel/Sheets, nothing uploaded
Frequently asked questions
What is the difference between TSV and CSV?
They are the same tabular format with a different field delimiter: CSV separates fields with a comma, TSV separates them with a tab character. TSV is handy when your values themselves contain commas (so you avoid heavy quoting) and because pasting tab-separated text straight into Excel or Google Sheets fills cells automatically. This converter produces the same header-plus-rows structure as the CSV conversion, just tab-delimited.
How do I convert JSON to TSV?
Paste a JSON array of objects. The header row is the union of every object's keys and each object becomes one tab-separated record — so [{"id":1,"name":"Ada"}] becomes id⇥name followed by 1⇥Ada (where ⇥ is a tab). Nested objects are flattened into dotted-path columns so no data is lost, and the whole conversion happens in your browser without uploading anything.
Are values with tabs or newlines quoted?
Yes — the same RFC 4180 quoting rules apply, just with the tab as the delimiter. A field is wrapped in double-quotes only if it contains a tab, a double-quote, or a line break, and inner quotes are escaped by doubling them (""). Plain values are written unquoted, which keeps the output clean and paste-friendly for spreadsheets.