Convert TSV to JSON

Want to convert TSV file to JSON file?

Try Withdata Data File Converter, a desktop TSV to JSON converter for Windows, MacOS, and Linux, Convert TSV to JSON, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Convert files locally and privately, avoid uploading large TSV file(s) to online services.
• Support Windows, Linux, and macOS.

Download Withdata DataFileConverter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Convert TSV to JSON

Choose TSV file -> Set JSON file -> Convert TSV to JSON

“Start a New Convert” for “TSV to JSON”.

Select From “File” “TSV” To “File” “JSON”.

1. Open source TSV file.

Support large TSV file ( > 4GB ).

Source TSV file’s content is like this:

2. Config target JSON file.

3. Set rows options.

4. Convert TSV to JSON.

After converting, you can view the output JSON file.

---

More about TSV to JSON converter

See Video: Convert TSV file to JSON file without coding

See also:

• Merge multiple TSV files into one JSON
• Batch convert TSV files to JSON files

TSV → JSON reference

Type mapping

Value kind	in TSV	in JSON
Int	1234	1234 (number)
Decimal	1234.56	1234.56 (number)
Float	1.234e+10	1.234e10 (number)
Text	unquoted; a tab in the value splits the column	"text" (string)
Long text	unquoted; newlines break the row	"multi-line\ntext" (escaped newline inside a string)
Date	2026-09-18	"2026-09-18" (string)
Datetime	2026-09-18 14:30:00	"2026-09-18T14:30:00Z" (string)
Binary	not representable	"base64:..." (string)
Boolean	TRUE / FALSE	true / false (boolean)
JSON	the whole JSON value as-is (its own quotes stay)	nested object or array, kept as structure

Dialect differences

Both TSV and JSON are file formats, so what differs below is how each one chooses to represent a value.

Property	in TSV	in JSON
identifiers	Rarely used, which is exactly why tabs in data break it	Double quotes; backslash escapes
dates	Conventional text: 2026-09-18 or 2026-09-18 14:30:00	No date type: dates arrive as strings and the reader must p...
binary	Not supported - must be encoded	Not supported natively - base64 inside a string
separator	Tab	Braces and commas
encoding	No declaration - UTF-8 works only with a BOM	UTF-8 by definition
typing	None - every field is text	string, number, boolean, null, object, array - no date type
shape	Flat table, optional header row	Nested objects and arrays
ceiling	No formal limit	Whole document is usually parsed into memory

Convert TSV to JSON the easy way

Use the TSV to JSON converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).

New to the format? Read what a TSV file is (and how it differs from CSV).