TSV to JSON converter

Trusted by over 20,000 every month

Convert TSV to JSON online

With our online TSV to JSON converter you can convert your files without downloading any software or writing code. Unlike other services, you can make graphs from your converted data or perform analysis. Just click the navigation on the left hand side.

Convert TSV to JSON online

Works with large TSV files that have millions of rows

View your converted JSON data before downloading it

TSV

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.

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.

How to convert TSV to JSON

  1. Upload your TSV file
  2. Your TSV file will be converted to JSON
  3. Download your JSON file
  4. Click the view button to view your file

How to convert TSV to JSON in Python

We can convert TSV to JSON in Python using Pandas or DuckDB

How to Convert TSV to JSON using Pandas

First, we need to install pandas

pip install pandas

Then we can load the TSV file into a dataframe

df = pd.read_csv('path/to/file.tsv', sep='\t')

Finally, we can export the dataframe to the JSON format

df.to_json('path/to/file.json', index=False)

How to Convert TSV to JSON using DuckDB

First, we need to install duckdb for Python

 pip install duckdb

The following DuckDB query will read a TSV file and output a JSON file

duckdb.sql("""COPY (select * from 'path/to/file.tsv') TO 'path/to/file.json' (FORMAT 'json')""")

TSV viewer

View and explore TSV files.

TSV graph maker

Make graphs from TSV files

Merge TSV

Combine TSV files.

Filter TSV

Filter TSV files online

Sort TSV

Sort TSV files online

TSV bar graph maker

Make bar graphs from TSV files

TSV scatter plot maker

Make scatter plots from TSV files

MT cars

Motor Trends Car Road Tests dataset.

filename

mtcars.json

rows

32

Flights 1m

1 Million flights including arrival and departure delays.

filename

flights-1m.json

rows

1000000

Iris

Iris plant species data set.

filename

iris.json

rows

50

House price

Housing price dataset.

filename

house-price.json

rows

545

Weather

Weather dataset with temperature, rainfall, sunshine and wind measurements.

filename

weather.json

rows

366