CleanorTools
JSON

JSON to TSV Converter

Details

How to use JSON to TSV Converter

What the tool does, how to run it, and what to expect from the result.

How to convert JSON to TSV

TSV is the format that gets data out of an API response and into a spreadsheet with the least friction. Copy tab-separated text to the clipboard, paste it into a sheet, and the columns land where they should without an import dialogue.

The conversion runs in your browser. It reads an array of objects, builds a header row from the union of all keys, and writes one line per record. Tabs and newlines inside values are replaced with spaces, because the format cannot carry them.

  • Paste a JSON array of objects into the input box.
  • Check the generated header row, which contains every key found across all records.
  • Look for fields that contained line breaks, since those have been flattened to spaces and may need CSV instead.
  • Copy the TSV output and paste it directly into Excel, Google Sheets, or Numbers, where it will split into columns automatically.
  • If nested objects appear as JSON text inside a cell, flatten the source JSON first and convert again.
Tips

Getting a better result out of JSON to TSV Converter

Specific settings and thresholds, not general advice.

  • Tabs and newlines inside your values are silently replaced with spaces. They have to be, because TSV has no quoting mechanism and a stray tab would create a phantom column. This is real data loss, so if any of your fields contain multi-line text, convert to CSV instead, which can quote them.
  • The header row is the union of every key seen across every object, in first-seen order. A key that appears only in the last record still gets a column, and every earlier row gets an empty cell for it, so ragged JSON produces a sparse but complete table.
  • Nested objects and arrays are collapsed into a single cell as JSON text. TSV is strictly two-dimensional, so a nested address object becomes one cell containing braces. If you need those fields as columns, flatten the JSON before you convert.
  • TSV pastes straight into Excel, Google Sheets, and Numbers as columns, with no import dialogue and no delimiter guessing. That is the main reason to choose it over CSV, which spreadsheets will interrogate you about.
  • The input should be an array of objects. A single object is treated as a one-row table, and an array of scalars has no keys to become columns, so it produces an error rather than a nameless column.
Limits

What JSON to TSV Converter does not do

The honest boundary, so you do not lose time finding it yourself.

  • It cannot preserve tabs or newlines inside values, because TSV has no quoting or escaping convention.
  • It does not flatten nested structures into columns. Nested objects and arrays are dumped into one cell as JSON text.
  • It does not infer or emit types, so every cell is text and a spreadsheet will apply its own guesses when you paste.
  • It cannot handle an array of scalars, since there are no keys from which to build a header row.
Reference

Terms used on this page

Short, plain-language definitions for the formats and settings above.

Files & formatsJSONJSON (JavaScript Object Notation) is a lightweight, text-based format for storing and exchanging structured data as key/value pairs and ordered lists. It is human-readable, language-independent, and the default format for most web APIs and config files.General
At a glance

Who JSON to TSV Converter is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

Developers, data engineers, and anyone converting between data formats.

Ideal for

Quick JSON to TSV conversion without a backend or install.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Is the JSON to TSV converter free?

Yes. It is completely free to use, with no signup, no account, and no paywall.

Do I need to install anything?

No. It runs in any modern browser on desktop or mobile, with nothing to download and nothing to configure.

Does it stay local?

Yes. Your data is converted entirely in your browser and never uploaded to a server.

Why did the line breaks disappear from my text fields?

Because TSV cannot represent them. Unlike CSV, the tab-separated format has no quoting convention, so a newline inside a value would be read as the start of a new row and a tab would be read as a new column. The converter replaces both with spaces so that the output is a valid table. If your data has multi-line descriptions or addresses and you need them intact, CSV is the correct format because it can wrap those values in quotes.

What happens if my objects have different keys?

Every key from every object gets a column. The header row is built by walking all records and collecting keys in the order they are first encountered, so nothing is dropped. Records that lack a given key get an empty cell for it. This means a JSON array where the shape drifts between records still produces a complete, rectangular table, which is usually what you want when you are loading it into a spreadsheet.

Why TSV rather than CSV?

Because it pastes cleanly. Copy TSV to the clipboard and paste it into Excel, Google Sheets, or Numbers and it lands as columns immediately, with no import wizard and no dialogue asking you to confirm the delimiter. CSV triggers that flow, and it also collides with locales that use the comma as a decimal separator. The trade-off is that TSV cannot carry tabs or newlines inside a value, so it is the better clipboard format and the worse archival one.

My nested objects came out as a wall of braces in one cell. Can I fix that?

Only by flattening the JSON before you convert it. A table has rows and columns and nothing else, so there is no correct place to put a nested object other than inside a cell. If you want an address object to become address_street and address_city columns, you need to restructure the JSON first, either in code or with a jq expression.

Is the data uploaded?

No. The JSON is parsed and the table is built by JavaScript running in your browser, so no records are transmitted or stored. That is worth knowing since exporting a JSON array to a spreadsheet usually means the array contains real customer or order data.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

JSON
UtilityJSON

JSON to XML Converter

Convert JSON to XML

Convert a JSON object or array into equivalent XML. Free, in your browser, nothing is uploaded.

YAML
UtilityJSON

JSON to YAML Converter

Convert JSON to YAML

Convert JSON into clean, indented YAML. Free, in your browser, nothing is uploaded.

CSV
UtilityData

JSON to CSV

Convert flat JSON to CSV

Convert flat JSON rows into CSV locally and reject nested structures with a clear message.

TXT
UtilityJSON

JSON to Text Converter

Flatten JSON to text

Flatten JSON into readable key and value lines of plain text. Free, in your browser, nothing is uploaded.

JSON
UtilityTSV

TSV to JSON Converter

Convert TSV to JSON

Convert tab-separated values with a header row into a JSON array of objects. Free, in your browser, nothing is uploaded.

JSON
UtilityData

CSV to JSON

Convert CSV to JSON

Convert header-based CSV into flat JSON rows locally with a readable output.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon
Get it on the App StoreGet it on Google PlayAll platforms & pricing