Diysb Tools

TSV to JSON

Convert TSV (Tab-Separated Values) data to JSON format. Transform tabular data into structured JSON objects.

CSV Tools

What is a TSV to JSON?

Convert TSV (Tab-Separated Values) data to JSON format. Transform tabular data into structured JSON objects.

Input TSV
Output JSON
Tool options
Input CSV Format
Character used to quote TSV values
Symbol to mark comments in the TSV
Conversion Options
First row is treated as column headers
Convert numbers and booleans to their proper types
Output Formatting
Use Spaces for indentation
Number of spaces for indentation
Use Tabs for indentation
Minify JSON
TSV to JSON Examples

Basic TSV to JSON Array

Convert a simple TSV file into a JSON array structure by using spaces as formatting indentation.

Input
name	age	city
John	30	New York
Alice	25	London
Output
[
  {
    "name": "John",
    "age": 30,
    "city": "New York"
  },
  {
    "name": "Alice",
    "age": 25,
    "city": "London"
  }
]
Input CSV Format
Character used to quote TSV values
Symbol to mark comments in the TSV
Conversion Options
First row is treated as column headers
Convert numbers and booleans to their proper types
Output Formatting
Use Spaces for indentation
Number of spaces for indentation
Use Tabs for indentation
Minify JSON

Turn TSV to JSON without Headers

Convert a TSV file in minified JSON file.

Input
Square	Triangle	Circle
Cube	Cone	Sphere
#Oval
Output
[["Square","Triangle","Circle"],["Cube","Cone","Sphere"]]
Input CSV Format
Character used to quote TSV values
Symbol to mark comments in the TSV
Conversion Options
First row is treated as column headers
Convert numbers and booleans to their proper types
Output Formatting
Use Spaces for indentation
Use Tabs for indentation
Minify JSON

Transform TSV to JSON with Headers

Convert a TSV file with headers into a JSON file.

Input
item	material	quantity


Hat	Wool	3
Gloves	Leather	5
Candle	Wax	4
Vase	Glass	2

Sculpture	Bronze	1
Table	Wood	1

Bookshelf	Wood	2
Output
[
  {
    "item": "Hat",
    "material": "Wool",
    "quantity": 3
  },
  {
    "item": "Gloves",
    "material": "Leather",
    "quantity": 5
  },
  {
    "item": "Candle",
    "material": "Wax",
    "quantity": 4
  },
  {
    "item": "Vase",
    "material": "Glass",
    "quantity": 2
  },
  {
    "item": "Sculpture",
    "material": "Bronze",
    "quantity": 1
  },
  {
    "item": "Table",
    "material": "Wood",
    "quantity": 1
  },
  {
    "item": "Bookshelf",
    "material": "Wood",
    "quantity": 2
  }
]
Input CSV Format
Character used to quote TSV values
Symbol to mark comments in the TSV
Conversion Options
First row is treated as column headers
Convert numbers and booleans to their proper types
Output Formatting
Use Spaces for indentation
Number of spaces for indentation
Use Tabs for indentation
Minify JSON

All CSV Tools

Convert CSV to JSON

Convert CSV data to JSON format.

Convert CSV to XML

Convert CSV data to XML format.

Convert CSV Rows to Columns

Convert CSV rows to columns.

Convert CSV to TSV

Convert CSV data to TSV format.

Swap CSV Columns

Reorder CSV columns.

Convert CSV to YAML

Quickly convert a CSV file to a YAML file.

Change CSV Separator

Change CSV file delimiter

Find incomplete CSV records

Quickly find rows and columns in CSV that are missing values.

Transpose CSV

Quickly transpose a CSV file.

Insert CSV columns

Quickly insert one or more new columns anywhere in a CSV file.