Skip to the converter

TSV to JSON converter, without the upload.

Turn TSV spreadsheets into JSON. It is converted in your browser, so the file never leaves your device.

Drop TSV files here

or choose from your computer paste with Ctrl V

Ready · other file types work too0 bytes uploaded, ever

Convert to

How to convert TSV to JSON

  1. Add your TSV spreadsheets

    Drop TSV files onto the box above, or click it to choose them. ToAny reads the file's contents to detect the type, so a wrong extension does not matter.

  2. JSON is already chosen

    Press Convert. There is nothing else to set. The work happens in this tab.

  3. Download

    Save the JSON, or download everything as one ZIP if you converted several files.

Why ToAny

  • Private by construction

    The TSV to JSON converter is part of this page and runs inside your browser. Your spreadsheets are never sent to ToAny or to anyone else.

  • No upload, no queue

    Nothing has to travel to a server and back, so the conversion starts the moment you press Convert, even on a slow connection.

  • Free, without an account

    No sign-up, no email address and no watermark. Add several files and download them together as a ZIP.

TSV to JSON: what to expect

TSV is less widely recognised by double-click than CSV or XLSX. JSON is what APIs and most programming languages read natively. TSV is at home in tabular data whose values contain commas; JSON is the usual choice for APIs and data exchanged between programs.

The first row is read as column names, and every row after it becomes one object, keyed by those names. A header such as address.city is turned back into a nested address with a city. Numbers and true/false in the cells are written as real numbers and booleans, but values such as ZIP codes with a leading zero, phone numbers and very long ids stay text so nothing is altered; empty cells become null.

TSV vs JSON

TSV

TSV spreadsheet

TSV is the same idea as CSV with tabs between values, which avoids quoting problems when the data itself contains commas. It is common in scientific and export tooling.

Opens in Excel, Google Sheets, databases and any text editor

TSV converter
JSON

JSON data

JSON represents data as nested objects and lists in plain text. It is the default language of web APIs. Unlike a spreadsheet it can be nested to any depth, which is also why turning it into rows and columns takes a decision about how to flatten it.

Opens in Any text editor, every programming language, browser developer tools

JSON converter
TSV compared with JSON
TSVTSV spreadsheetJSONJSON data
Stands forTab-Separated ValuesJavaScript Object Notation
TypePlain-text tableStructured data (text)
CompressionNoneNone
IntroducedThe 1970s, by no single author (registered with IANA in 1993)2001, by Douglas Crockford
Opens inExcel, Google Sheets, databases and any text editorAny text editor, every programming language, browser developer tools
Best forTabular data whose values contain commasAPIs and data exchanged between programs
File extension.tsv, .tab.json

Questions

Are my spreadsheets uploaded anywhere?

No. The TSV to JSON conversion runs inside your browser, on your own phone or computer. The file is not sent to ToAny or to anyone else.

Is anything lost when converting TSV to JSON?

The values are kept. Anything JSON has no way to express, such as formatting, formulas or nesting, is simplified or left out.

Can I convert several TSV files at once?

Yes. Add as many as you like, convert them together and download each result or all of them as one ZIP.

How do I convert TSV to JSON on Windows, Mac, iPhone or Android?

The steps are the same everywhere because ToAny runs in the web browser: open this page in a current version of Chrome, Edge, Safari or Firefox, add the TSV file, press Convert and save the JSON. There is nothing to install.

Is there a file size limit?

Yes. Data files up to 300 MB are accepted; a larger file is refused with a message. Beyond that the limit is your device's memory, since nothing is uploaded; a computer copes with large files better than a phone.