Convert JSON to TSV

Convert JSON to TSV in seconds with this free online JSON to TSV converter

Accepts json


Java Script Object Notation (JSON) is a format that was designed for use with the Javascript Programming Language.

JSON files do not have a schema or required columns. Each row can have different field names and types. This can

make JSON files difficult to analyze.


TSV (Tab Separated Values) files are the same as CSV files, except values in a row are separated by a tab.

Values within a row are separated by tabs. Rows are separated by newlines.

TSV files often start with a header row that has column names, but this is not required.

Each row in a TSV file mush have the same number of values as the header row.

TSV files do not enforce types or a schema. This means that each column can have multiple types, which can make analysis difficult and compression inefficient.

Parquet files can be easier to analyze and compress better than TSV files.

Supercharge your data exploration

Open csv, parquet, arrow, json and tsv files straight from your desktop


Share and embed

Share your graphs and data sets.

Share your graphs and data sets. Or embed them directly into web pages.

Work straight from Google Drive

Open csv, parquet, arrow, json and tsv files directly from Drive, Gmail and Classroom by installing the Google Workspace App

How to Convert JSON to TSV

Viewing converted data
  1. Select your input JSON file
  2. Your JSON file will be converted to TSV
  3. Download your TSV file
  4. Click the View button to view your file

How to Convert JSON to TSV in Python using Pandas

First, we need to install pandas

pip install pandas

Then we can load the JSON file into a dataframe

df = pd.read_json('path/to/file.json')

Finally, we can export the dataframe to the TSV format

df.to_csv('path/to/file.tsv', sep='\t', index=False)