Skip to the converter

JSON to TSV converter, without the upload.

Turn JSON data files into TSV. It is converted in your browser, so the file never leaves your device.

Drop JSON files here

or choose from your computer paste with Ctrl V

Ready · other file types work too0 bytes uploaded, ever

Convert to

How to convert JSON to TSV

  1. Add your JSON data files

    Drop JSON files onto the box above, or click it to choose them. ToAny reads the file's contents to detect the type, so a wrong extension does not matter.

  2. TSV is already chosen

    Press Convert. There is nothing else to set. The work happens in this tab.

  3. Download

    Save the result. When one file produces several TSV files they come as a single ZIP.

Why ToAny

  • Private by construction

    The JSON to TSV converter is part of this page and runs inside your browser. Your data files are never sent to ToAny or to anyone else.

  • No upload, no queue

    Nothing has to travel to a server and back, so the conversion starts the moment you press Convert, even on a slow connection.

  • Free, without an account

    No sign-up, no email address and no watermark. Add several files and download them together as a ZIP.

JSON to TSV: what to expect

JSON is hard to read in bulk and cannot be opened as a table without flattening. TSV avoids the quoting problems commas cause in CSV. JSON is at home in APIs and data exchanged between programs; TSV is the usual choice for tabular data whose values contain commas.

One JSON can produce several TSV files; when it does, they are offered together as a ZIP download.

A list of records becomes a table with one row per record. Nested keys turn into columns named like address.city, list items into columns like tags.0, and a key that only some records have leaves empty cells in the others. If the top level holds several lists of records, each becomes its own table, saved as a separate file; a document that is a single object becomes one row.

JSON vs TSV

JSON

JSON data

JSON represents data as nested objects and lists in plain text. It is the default language of web APIs. Unlike a spreadsheet it can be nested to any depth, which is also why turning it into rows and columns takes a decision about how to flatten it.

Opens in Any text editor, every programming language, browser developer tools

JSON converter
TSV

TSV spreadsheet

TSV is the same idea as CSV with tabs between values, which avoids quoting problems when the data itself contains commas. It is common in scientific and export tooling.

Opens in Excel, Google Sheets, databases and any text editor

TSV converter
JSON compared with TSV
JSONJSON dataTSVTSV spreadsheet
Stands forJavaScript Object NotationTab-Separated Values
TypeStructured data (text)Plain-text table
CompressionNoneNone
Introduced2001, by Douglas CrockfordThe 1970s, by no single author (registered with IANA in 1993)
Opens inAny text editor, every programming language, browser developer toolsExcel, Google Sheets, databases and any text editor
Best forAPIs and data exchanged between programsTabular data whose values contain commas
File extension.json.tsv, .tab

Questions

Are my data files uploaded anywhere?

No. The JSON to TSV conversion runs inside your browser, on your own phone or computer. The file is not sent to ToAny or to anyone else.

Is anything lost when converting JSON to TSV?

The values are kept. Anything TSV has no way to express, such as formatting, formulas or nesting, is simplified or left out.

Can I convert several JSON files at once?

Yes. Add as many as you like, convert them together and download each result or all of them as one ZIP.

How do I convert JSON to TSV on Windows, Mac, iPhone or Android?

The steps are the same everywhere because ToAny runs in the web browser: open this page in a current version of Chrome, Edge, Safari or Firefox, add the JSON file, press Convert and save the TSV. There is nothing to install.

Is there a file size limit?

Yes. Data files up to 300 MB are accepted; a larger file is refused with a message. Beyond that the limit is your device's memory, since nothing is uploaded; a computer copes with large files better than a phone.