The TSV to JSON Converter turns tab-separated data — often copied straight from a spreadsheet — into a clean JSON array of objects. Paste your TSV, and the tool uses the header row as keys to build one object per data row, giving you JSON that is ready for APIs, config, and code.

How the Conversion Works

Tab-separated values are a simple grid: the first line names the columns, and each following line holds values separated by tabs. The converter reads the header to determine the object keys, then walks each row and pairs every value with its column name, producing an array of objects that mirrors your table.

From Spreadsheet to Structured Data

Spreadsheets are where a lot of real-world data lives, but applications and APIs want structured JSON, not a grid of cells. When you select a range in Excel or Google Sheets and copy it, the clipboard holds tab-separated text — which is exactly what this converter consumes. That makes it the fastest path from a maintained spreadsheet to usable JSON: no export step, no custom parser, just copy, paste, and convert. It is especially handy for turning a table of settings, test data, or content into JSON your code can load directly.

Worked Example

Given this TSV (tabs between values):

name    age    city
Alice   30     London
Bob     25     Paris

the converter produces:

[
  { "name": "Alice", "age": "30", "city": "London" },
  { "name": "Bob", "age": "25", "city": "Paris" }
]

Each row became an object keyed by the header names, ready to use in code.

Key Features

Converts TSV into a JSON array of objects
Uses the header row as object keys
Handles data pasted directly from spreadsheets
Copy or download the JSON output
Runs entirely in your browser — no upload

Common Use Cases

App imports: load spreadsheet data into applications as JSON.
API testing: build request bodies from tabular data.
Config generation: turn a table of settings into structured JSON.
Data pipelines: feed JSON-based tools from tab-delimited sources.

Tips for Reliable Output

Always include a header row, since those labels become the JSON keys — without it, the first data row would be mistaken for headers. Confirm your columns are separated by actual tab characters rather than multiple spaces, which spreadsheets handle automatically when you copy cells but which can differ if the text was hand-typed. Keep in mind that every value is read as text; if you need numbers or booleans as native JSON types, cast them in your code after import, since the converter preserves the exact characters from the table.

FAQ

What input is expected?

Tab-separated rows with a header line; each subsequent row becomes an object keyed by the headers.

Can I paste from Excel or Sheets?

Yes — copying cells usually produces tab-separated text that pastes in directly.

Are numbers converted to number types?

Values are mapped to their columns as text; cast them to numbers or booleans in your code if needed.

Do I need a header row?

Yes — the header supplies the object keys, so include it for correct output.

Can I download the JSON?

Yes — copy it or download it as a file.

Is my data private?

Yes. Conversion runs locally in your browser.

Related Tools

Reverse it with the JSON to TSV Converter, or explore the CSV to XML Converter for other formats.

TSV to JSON Converter