Convert TSV to JSON

This tool converts files in TSV (Tab Separated Values) format to JSON (JavaScript Object Notation) format. TSV is a text-based data storage format where values are separated by tabs. As tabs are almost never present in the data, the tab separator makes it very easy to parse (it's just a split via the tab symbol) and import such data into data processing applications. JSON is also a text-based data storage format but it's more widely used in programming as it supports structured data (with keys and values). It's much harder to parse as it has special syntax rules but it's equally readable by both humans and machines. Converting between these formats makes it easier to work with data in systems where JSON is the standard data format. The conversion process starts with setting the column delimiter symbol and the quotation symbol. For TSV the delimiter is usually a tab "\t" but this application also supports commas, semicolons, pipes, and other symbols. The quotation symbol is the standard double quotes (") but it can also be adjusted to single quotes or other symbols. In the options, you can also specify a comment symbol (usually "#") to identify comment lines to skip. Then, you can enable or disable the "Treat First Row as Headers" option. When enabled, TSV is converted to a JSON array with nested objects, using the headers from the first row as object keys. If headers are disabled, TSV becomes a JSON array with nested arrays, where the values of tab-separated rows become sub-arrays. The "Ignore Empty Lines" option excludes empty lines from the resulting JSON, and the "Detect Data Types" option avoids quoting numeric and boolean values. Additionally, you can pretty-print the output JSON – you can use two spaces or one tab for indentation, or disable indentation altogether to create a minified JSON file. For reverse data conversion, you can use our Convert JSON to TSV tool. Json-abulous!