Simple and free online TSV to JSON converter. Just paste a TSV table and turn it into JSON data. You can use headers as JSON keys, detect numbers and booleans, skip empty lines, set TSV parsing characters, and choose JSON indentation. Created by programmers from team Browserling.
Simple and free online TSV to JSON converter. Just paste a TSV table and turn it into JSON data. You can use headers as JSON keys, detect numbers and booleans, skip empty lines, set TSV parsing characters, and choose JSON indentation. Created by programmers from team Browserling.
This online tool transforms Tab Separated Values (TSV) files to JavaScript Object Notation (JSON) data structures. The output JSON can either be an array of objects or an array of arrays. You can control whether it's objects or arrays via the "Convert Headers to JSON Keys" option. If this option is on, then the first row of your TSV data with column names will be used as keys for the JSON objects (one TSV row will be converted to one object with as many keys as there are columns). Otherwise, the data will simply be converted as arrays (one TSV row will be converted to one array with as many elements as there are columns). If your TSV data doesn't have headers, then you can disable this option. Numbers and boolean values can be represented in JSON without quotes using the "Unquote Numbers and Booleans" option. The "Remove Empty Lines" option can be used to eliminate empty lines from the output. You can also change JSON indentation to spaces, tabs, or output compressed JSON. If your input TSV uses a different delimiter, quote, and comment characters than tabs (\t), double quotes ("), and hashes (#), you can customize them in the options. These options make the tool very flexible, and it can work with non-standard TSV file formats. To convert JSON back to TSV, you can use our Convert JSON to TSV tool. Tsv-abulous!
This online tool transforms Tab Separated Values (TSV) files to JavaScript Object Notation (JSON) data structures. The output JSON can either be an array of objects or an array of arrays. You can control whether it's objects or arrays via the "Convert Headers to JSON Keys" option. If this option is on, then the first row of your TSV data with column names will be used as keys for the JSON objects (one TSV row will be converted to one object with as many keys as there are columns). Otherwise, the data will simply be converted as arrays (one TSV row will be converted to one array with as many elements as there are columns). If your TSV data doesn't have headers, then you can disable this option. Numbers and boolean values can be represented in JSON without quotes using the "Unquote Numbers and Booleans" option. The "Remove Empty Lines" option can be used to eliminate empty lines from the output. You can also change JSON indentation to spaces, tabs, or output compressed JSON. If your input TSV uses a different delimiter, quote, and comment characters than tabs (\t), double quotes ("), and hashes (#), you can customize them in the options. These options make the tool very flexible, and it can work with non-standard TSV file formats. To convert JSON back to TSV, you can use our Convert JSON to TSV tool. Tsv-abulous!
This example translates TSV to JSON and sets JSON indentation to 2 spaces. The input data contains 3 columns and 3 rows. The first row defines column titles ("pet", "name", "age") and the remaining 2 rows contain the data ("cat", "Luna", "3", etc). When the input TSV is converted into JSON, the column titles are used as JSON keys, and the data are used as JSON values.
In this example, we convert a TSV file into an array of JavaScript objects. The input contains a list of video games organized by year. The first column contains the years, and the second column contains the game titles. After converting this two-column list to JSON, each row becomes a separate object with the keys "Year" and "Video Game". Additionally, we activate the "Unquote Numbers and Booleans" option and use tabs to add hierarchical indentation to the output JSON.
In this example, we transform TSV data into a minified JSON array. By disabling the option to convert headers into JSON keys, we obtain a bunch of arrays as output, where each array represents one tab-separated record. Additionally, we remove empty lines and comments from the input TSV data. The comments are removed because they start with the hash symbol "#", and we entered this symbol in the tool settings.
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 the complexity of a TSV file.
Create an abstract drawing that shows the structure of a TSV.
Show a TSV file in a neat editor and allow easy editing.
Convert a TSV file to a double-TSV file.
Convert a double-TSV file to a regular TSV file.
Convert a Tab Separated Values file to an HTML table.
Convert an HTML table to a Tab Separated Values file.
Convert a TSV file to a Markdown table.
Convert a Markdown table to a TSV file.
Convert a Tab Separated Values file to a PDF document.
Convert a PDF document to a Tab Separated Values file.
Draw Tab Separated Values as a table and output it as an image.
Extract data in an image and format it as a TSV file.
Convert a Tab Separated Values file to an Excel spreadsheet.
Convert an Excel file to a Tab Separated Values file.
Convert a TSV file to LaTeX code that generates a table.
Convert a Tab Separated Values file to a neat ASCII table.
Convert an ASCII table to a Tab Separated Values file.
Convert a Tab Separated Values file to an SQL query.
Convert a Tab Separated Values file to an SQLite database.
Export tables from an SQLite database as TSV files.
Convert a TSV file to a PSV (Pipe Separated Values) file.
Convert a PSV (Pipe Separated Values) file to a TSV file.
Convert a TSV file to a HSV (Hash Separated Values) file.
Convert a HSV (Hash Separated Values) file to a TSV file.
Convert a TSV file to a SSV (Semicolon Separated Values) file.
Convert a SSV (Semicolon Separated Values) file to a TSV file.
Convert a TSV file to a 0SV (Null Separated Values) file.
Convert a 0SV (Null Separated Values) file to a TSV file.
Create multiple TSV files from the given TSV file.
Merge together two Tab Separated Values files.
Remove columns that have no values in a TSV file.
Remove rows that have no values in a TSV file.
Remove lines in a TSV file that are blank.
Delete TSV lines that are comments.
Filter rows and columns that match a pattern.
Find certain values in TSV cells.
Extract repeated rows in a TSV file.
Combine duplicate rows in a TSV file.
Remove repeated rows from a TSV file.
Delete duplicate rows from a TSV file.
Minify a TSV file and remove extra spaces and indentation.
Diff two TSV files and visually display the differences.
Rotate TSV columns to the left or right.
Rotate TSV rows up or down.
Cut a fragment from a TSV file.
Extract a slice (rows/columns/cells) of a TSV file.
Shuffle all data values in a TSV file.
Shuffle the order of TSV columns.
Shuffle the order of TSV rows.
Sort values in a TSV rows.
Find how many columns there are in the given TSV data.
Find how many rows there are in the given TSV data.
Find how many total entries there are in a TSV file.
Add colors to TSV data for easy visual overview of the file.
Create random errors in a TSV file for fuzz testing.
Generate a custom TSV with n rows and m columns.
Open a TSV file directly in your browser.
Subscribe to our updates. We'll let you know when we release new tools and features, and when we organize online workshops.
Enter your email here
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling, we love to make developers' lives easier, so we created this collection of online TSV 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 our TSV tools are actually powered by our programming tools that we created over the last couple of years. Check them out!
