Skip to content
Wololo
Menu
Language:English

Data

Convert JSON to TSV

Turn your JSON files into TSV in seconds. Everything happens in your browser: nothing is uploaded to any server.

JSONTSV

Drag your files here

Or paste them with Ctrl+V. They never leave your device.

Why convert JSON to TSV?

For a person, a table in JSON is harder to read than a spreadsheet. As TSV it pastes straight into a spreadsheet, with no trouble from commas.

About the formats

JSON, structured data for software

JSON is the data format of APIs and web apps: nested lists and objects as text.

Strengths: Every programming language reads it and it is easy to validate.

Limits: For a person, a table in JSON is harder to read than a spreadsheet.

TSV, tab-separated tables

TSV is like CSV but separates columns with tabs, so commas inside the text are not a problem.

Strengths: It pastes straight into a spreadsheet and is common for scientific data.

Limits: Like CSV: a single sheet and no formatting.

How to convert JSON to TSV

  1. 1Drop your JSON files in the box, paste them or pick them from your device.
  2. 2Check that the target is TSV and open the options if you want to adjust it.
  3. 3Press “Convert” and download each TSV, or all of them in a ZIP.

Frequently asked questions

Is my JSON uploaded to a server to turn it into TSV?

No. The JSON to TSV conversion runs entirely in your browser, with code downloaded from this site and executed on your device. You can check it in the Network tab of the developer tools or by going offline after the page loads.

Which JSON can become TSV?

One that is a list of records, like [{"name": "Ana"}, {"name": "Luis"}]: each record becomes a row and each field a column. If the data is not table-shaped, you are told.

Is there a size limit?

Up to 1 GB on desktop and about 200 MB on mobile, although a huge spreadsheet may take a few seconds.

Can I convert several JSON files at once?

Yes. Drop as many JSON files as you like: several are converted at the same time, depending on your processor cores, and when they finish you can download each TSV or all of them in a ZIP.

Related conversions

All data conversions