Free online TSV to JSON converter. Just load your TSV in the input field and it will automatically get converted to JSON. In the tool options, you can customize the format of the input TSV – choose whether to convert column headers into JSON object keys and disable quoting of numeric and boolean values. Additionally, you can adjust the formatting of the output JSON by indenting it with spaces or tabs, or print it minified with no indentation. Created for developers by developers from team Browserling.
Free online TSV to JSON converter. Just load your TSV in the input field and it will automatically get converted to JSON. In the tool options, you can customize the format of the input TSV – choose whether to convert column headers into JSON object keys and disable quoting of numeric and boolean values. Additionally, you can adjust the formatting of the output JSON by indenting it with spaces or tabs, or print it minified with no indentation. Created for developers by developers from team Browserling.
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!
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!
In this example, we convert a simple TSV file with three tab-separated columns into an array of JSON objects. We activate the "Treat First Row as Headers" option, which creates an array of objects. Each object has three keys corresponding to the column names found on the first row of the input TSV data.
In the input of this example, we load a TSV with three unnamed columns, two tab-separated rows, and one comment. In the options, we specify that the comments start with the symbol "#" and, as a result, all lines starting with "#" are skipped during the conversion. In the output, we get a JSON array of two other arrays, where each subarray represents a row in the TSV.
In this example, we transform TSV data with headers into a JSON array of objects and, additionally, we automatically detect JSON data types. As we're using the headers, the first row of TSV data ("item", "material", "quantity") becomes the JSON object keys, and the subsequent rows become JSON object values. As we're detecting JSON data types, the numeric values don't get quoted in the output JSON. Additionally, we skip empty lines during the conversion process.
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
Find keys and/or values that interest you in a JSON file.
Create a text list from a JSON array or object.
Create a JSON array from a text list.
Generate HTTP form data from a JSON object.
Generate JSON object from HTTP form data.
Create a HTML table from keys and values of a JSON object.
Convert a JSON file to a CSON file.
Convert a CSON file to a JSON file.
Convert a JSON config to a TOML config.
Convert a TOML file to a JSON file.
Convert a JSON data structure to Bencode encoding.
Convert Bencode data to JSON data.
Convert a JSON file to a JSONL file.
Convert a JSONL file to a JSON file.
Convert binary JSON data structure (BSON) to JSON.
Convert a JSON file to a universal binary JSON (UBJSON).
Convert universal binary JSON (UBJSON) to regular JSON.
Serialize JSON data to binary MessagePack format.
Unserialize binary MessagePack to a JSON struct.
Serialize JSON data to binary Protobuf format.
Unserialize binary Protobuf to a JSON struct.
Generate a LaTeX table from a JSON object.
Convert a JSON data file to an INI configuration file.
Convert an INI configuration file to JSON data file.
Loop over JSON structure and truncate all values or keys.
Find the nesting depth of a JSON data structure.
Convert a JSON data structure to a data URL.
Create a PHP data structure from a JSON data structure.
Create a JSON data structure from a PHP data structure.
Diff JSON files and show differences visually.
Lexicographically sort the order of JSON object keys.
Exchange keys with values in a JSON file.
Create a JSON array with random values.
Create a JSON object with random keys and values.
Randomly change the positions of array elements.
Randomly change the order of key, value pairs.
Add random spaces and newlines in a JSON file.
Tokenize a JSON data structure.
Remove all JSON syntax and leave just the values.
Change curly braces, commas, and quotes to other symbols.
Fix incorrectly quoted (usually single quote) keys and values.
Make all keys and values in a JSON to be single-quoted.
Make all keys and values in a JSON to be double-quoted.
Create JSON that looks real but is fake (FakeSON).
Execute a jq query on a JSON data structure.
Filter keys and values that match a pattern.
Create a JSON array from a string.
Create groups of JSON array items.
Merge two or more JSON arrays together.
Find differences in two or more JSON arrays.
Merge two or more JSON objects together.
Introduce errors in a JSON data structure.
Try to fix a damaged JSON to the best of our ability.
Convert images to valid JSON strings that look like ASCII art.
Create an abstract visualization of JSON's complexity.
Subscribe to our updates. We'll let you know when we release new tools, features, and organize online workshops.
Enter your email here
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling, our mission is to make people's lives easier, so we created this collection of JSON tools. Our tools have the simplest user interface that doesn't require advanced computer skills and they are used by millions of people every month. Behind the scenes, all JSON tools are actually powered by our web developer tools that we created over the last couple of years. Check them out!
