TSV

TSV to JSON Converter

Details

How to use TSV to JSON Converter

What the tool does, how to run it, and what to expect from the result.

How to convert TSV to JSON

TSV is what you get when you copy a range of cells out of a spreadsheet, so this conversion is the quickest route from a sheet to something an API or a script can consume. The header row supplies the keys and each subsequent row becomes one object.

Everything runs in your browser. Values are emitted as strings rather than guessed at, which means leading zeros, version numbers, and product codes survive intact, and it is left to you to cast the fields that genuinely are numeric.

  • Copy a range of cells from your spreadsheet, which puts tab-separated text on the clipboard, and paste it into the input box.
  • Check that the first row is the header, since its cells become the JSON keys exactly as written.
  • Look for duplicate header names, because a repeated name causes the later column to overwrite the earlier one.
  • Read the pretty-printed JSON array from the output panel and copy it.
  • Cast the numeric and boolean fields in your own code, because every value in the output is a string.
Tips

Getting a better result out of TSV to JSON Converter

Specific settings and thresholds, not general advice.

  • Every value comes out as a string. The age column becomes "34", not 34, and the active column becomes "true", not true. There is no type inference, which is the safe default (it never mangles a postcode or a leading zero) but it does mean you have to cast the fields you care about.
  • TSV has no quoting convention, so a value cannot contain a tab. If your source data had tabs inside a field, they were already destroyed by whatever produced the TSV, and no parser can recover them.
  • The first line is the header and its cells become the object keys verbatim, including any spaces, punctuation, or trailing whitespace. A header cell of "First Name " gives you a JSON key with a space and a trailing space in it, which is legal JSON and a nuisance to access.
  • Duplicate header names collide. If two columns share a name, the later one overwrites the earlier one in every record and the first column's data disappears without an error. Check the header row before you trust the output.
  • Rows with fewer cells than the header get empty strings for the missing fields rather than null or a missing key, so every object in the output has exactly the same shape. That makes the result easy to feed into a table or a typed struct.
Limits

What TSV to JSON Converter does not do

The honest boundary, so you do not lose time finding it yourself.

  • It does not infer types. Numbers and booleans come out as strings and must be cast by the consumer.
  • It cannot represent tabs inside values, because the format has no escaping mechanism.
  • It silently drops a column when two headers have the same name, keeping only the rightmost.
  • It does not sanitise header names, so keys can contain spaces and punctuation exactly as they appeared in the first row.
Reference

Terms used on this page

Short, plain-language definitions for the formats and settings above.

At a glance

Who TSV to JSON Converter is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

Developers, data engineers, and anyone converting between data formats.

Ideal for

Quick TSV to JSON conversion without a backend or install.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Is the TSV to JSON converter free?

Yes. It is completely free to use, with no signup, no account, and no paywall.

Do I need to install anything?

No. It runs in any modern browser on desktop or mobile, with nothing to download and nothing to configure.

Does it stay local?

Yes. Your data is converted entirely in your browser and never uploaded to a server.

Why are my numbers strings in the output?

Because guessing types is how data gets corrupted. A converter that helpfully turned 007 into 7 would break every product code and postcode in the file, and one that turned 1.10 into 1.1 would break version numbers. TSV carries no type information at all, so the honest thing to do is emit strings and let you cast the specific fields you know to be numeric. If you need typed output, do the conversion in code with an explicit schema.

Can a TSV value contain a tab character?

No, and this is the central limitation of the format. CSV solves the equivalent problem by wrapping a value in quotes, but TSV has no quoting or escaping convention, so a tab inside a value is indistinguishable from a column separator. Whatever produced your TSV either stripped those tabs or produced a file that no parser can read correctly. If your data contains tabs, use CSV or JSON as the interchange format.

Where do the JSON keys come from?

Straight from the first line, split on tabs, with no cleaning. A header cell containing a space produces a key containing a space, which is valid JSON but means you have to use bracket notation rather than dot notation to read it. If two header cells have the same text, the second column silently overwrites the first in every record, so it is worth glancing at the header row before you rely on the output.

What happens to short rows?

Missing trailing cells become empty strings, not null and not absent keys. Every object in the output therefore has the same set of keys as the header row, which keeps the result rectangular and easy to load into a table or map to a struct. It does mean you cannot distinguish a genuinely empty cell from a row that was cut short.

Is my data uploaded?

No. The TSV is split and rebuilt as JSON by JavaScript running in your browser. Data pasted out of a spreadsheet is usually real, so nothing is transmitted, logged, or stored.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon