TSV 到 JSON

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

Use HeadersFirst row is treated as column headers

Dynamic TypesConvert 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

Use HeadersFirst row is treated as column headers

Dynamic TypesConvert 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

Use HeadersFirst row is treated as column headers

Dynamic TypesConvert numbers and booleans to their proper types

Output Formatting

Use Spaces for indentation

Number of spaces for indentation

Use Tabs for indentation

Minify JSON

What is a TSV 到 JSON?

Basic TSV to JSON Array

Turn TSV to JSON without Headers

Transform TSV to JSON with Headers

全部 CSV 工具

将 CSV 转换为 JSON

将 CSV 转换为 XML

将 CSV 行转换为列

将 CSV 转换为 TSV

交换 CSV 列

将 CSV 转换为 YAML

更改 CSV 分隔符

查找不完整的 CSV 记录

转置 CSV

插入 CSV 列