TSV to JSON Converter

Convert tab-separated values into structured JSON arrays or objects with automatic type detection and nested key expansion.

Headers Empty Output Infer typesNested keysPretty

TSV Input

JSON Output

5 rows · 5 cols

[
  {
    "id": 1,
    "name": "Alice Johnson",
    "email": "alice@example.com",
    "department": "Engineering",
    "city": "San Francisco"
  },
  {
    "id": 2,
    "name": "Bob Smith",
    "email": "bob@example.com",
    "department": "Marketing",
    "city": "New York"
  },
  {
    "id": 3,
    "name": "Carol Lee",
    "email": "carol@example.com",
    "department": "Engineering",
    "city": "Austin"
  },
  {
    "id": 4,
    "name": "Dave Wilson",
    "email": "dave@example.com",
    "department": "Design",
    "city": "Seattle"
  },
  {
    "id": 5,
    "name": "Eve Brown",
    "email": "eve@example.com",
    "department": "Marketing",
    "city": "Chicago"
  }
]

How to Use

Paste tab-separated data or upload a .tsv / .txt file in the input panel.
Use the Table preview to verify your data was parsed correctly.
Configure header mode, type inference, empty value handling, and output format.
Copy the JSON output or download it as a .json file.

Why Convert TSV to JSON?

Tab-separated values are a common export format from spreadsheets, databases, and log files. Converting TSV to JSON lets you use that data directly in JavaScript applications, REST APIs, NoSQL databases, and configuration systems that expect structured JSON objects.

Common scenarios include importing spreadsheet exports into web applications, converting legacy flat-file data for modern APIs, and transforming database query results copied from terminal clients into structured payloads.

Features

Automatic type detection for numbers, booleans, and null values
Nested key expansion (dot-notation headers create nested objects)
Three output formats: array of objects, first row only, or keyed object
Input table preview to visually verify parsed data
Handles inconsistent row lengths with warnings
Pretty-print or minified JSON output
One-click copy and .json file download
100% browser-based — no data uploaded

Frequently Asked Questions

Does the first row need to contain headers?

By default, yes — the first row is treated as column headers that become JSON keys. You can switch to auto-generated headers (Column1, Column2, ...) or provide custom header names.

How does type inference work?

When enabled, the tool automatically converts numeric strings to numbers, "true"/"false" to booleans, and "null" to null. You can disable type inference to keep all values as strings.

What are nested keys?

If your headers use dot notation (e.g., "user.name", "user.email"), enabling nested keys will create nested JSON objects instead of flat keys. For example, user.name becomes { "user": { "name": "..." } }.

Can I convert TSV to a keyed JSON object instead of an array?

Yes. Select "Keyed object" as the output format and specify which column to use as the key. Each row becomes a property of the root object, keyed by that column's value.

Is my data uploaded to a server?

No. All parsing and conversion happens entirely in your browser. Your data never leaves your machine.

How are empty cells handled?

You choose: empty cells can become null, empty strings, or the key can be omitted entirely from that row's JSON object.