← All tools
// DATA FORMATS

TSV to JSON online

Convert tab-separated values to a JSON array — first row becomes the keys.

TSV to JSON Converter logo
by
CHUNKY
MUNSTER
Indent:
TSV INPUT0 CHARS
JSON OUTPUT0 CHARS

About TSV to JSON

TSV files are commonly produced by spreadsheets. This tool parses each tab-separated row and converts it to a JSON object, using the first row as keys (if enabled). All processing happens in your browser.

How to Use the TSV to JSON Converter

  1. Paste or enter your input into the text field.
  2. Configure any options (format, delimiter, encoding, or mode) using the controls above the output.
  3. The result updates instantly — no submit button required for most operations.
  4. Click Copy or Download to take the output to your next step.

Convert tab-separated data into structured JSON for use in JavaScript, REST APIs, or document stores. By default the first row is treated as an array of keys and each subsequent row becomes an object — the most common shape for fetch() responses and data-binding libraries. Switch to 2D-array mode and the output mirrors the original grid exactly.

How the TSV to JSON Converter Works

Type inference is on by default: integers, decimals, scientific notation, true/false, and empty cells are parsed into native JSON types rather than left as strings. That makes the result usable directly without a second cleanup pass. Output can be pretty-printed for readability or minified to save bytes.

Frequently Asked Questions

How are numeric and boolean values handled?

Cells matching a numeric pattern (integers, decimals, or scientific notation) are output as JSON numbers; "true" and "false" become JSON booleans; empty cells become null. Disable type detection if you need every value to stay a string.

Can I get a 2D array instead of objects?

Yes — turn off the "first row is header" option and the output becomes a flat array of arrays, preserving the original row/column structure.

What if my header row has duplicate column names?

In object mode, later columns with the same key overwrite earlier ones (standard JavaScript object behaviour). Rename duplicates upstream or switch to 2D-array mode to keep all values.

Does the tool send my TSV anywhere?

No. Parsing happens locally with the browser's JSON serializer; nothing is uploaded.

Explore the full suite of DATA FORMATS tools and 290+ other free utilities at Chunky Munster.