Code Utils

About TSV to JSON Converter

TSV (Tab-Separated Values) is the format you get when you copy cells directly from Excel or Google Sheets—each column is separated by a tab character instead of a comma. This makes TSV ideal for data that contains commas within values, like addresses or descriptions. Our TSV to JSON Converter transforms tab-separated data into a properly structured JSON array, with options for type parsing and header handling. Paste your copied spreadsheet data or upload a .tsv file and get JSON output instantly, entirely in your browser.

Key Features

• Excel and Google Sheets Compatible: Copy cells directly from any spreadsheet and paste—the tab delimiter is auto-detected
• Header Row Support: Use the first row as JSON object keys automatically
• Type Parsing: Optionally convert numeric strings to numbers and "true"/"false" to booleans for proper JSON typing
• Pretty-Printed Output: JSON output is formatted with indentation for easy reading
• File Upload: Upload .tsv or .txt files directly for conversion
• Download as JSON: Save the output as a .json file with one click
• Privacy First: 100% client-side processing—your data never leaves your browser

How to Use This Tool

Method 1: Paste from Excel or Google Sheets

1. Select the cells in Excel or Google Sheets that you want to convert
2. Copy them with Ctrl+C (the data is automatically tab-separated)
3. Paste into the input area of this tool
4. The JSON output appears automatically
5. Copy or download the JSON result

Method 2: Upload a TSV File

1. Click "Upload" or drag and drop a .tsv or .txt file
2. The file converts automatically
3. Download the .json output or copy it to clipboard

Common Use Cases

Exporting Spreadsheet Data for Web Applications

When you copy data from Excel or Google Sheets, it is automatically formatted as TSV. This makes TSV the fastest way to get spreadsheet data into JSON format without saving as a CSV file first. Copy your table data, paste it here, and get structured JSON ready for use in a web application, API test, or data processing script—no file export step needed.

Converting Data That Contains Commas

TSV is preferable to CSV when your data contains commas within values—addresses, product descriptions, financial figures with comma-formatted numbers, and notes often contain commas that would break CSV parsing. TSV sidesteps this problem entirely since tabs are rarely used within data values. Convert comma-heavy datasets via TSV for clean, unambiguous parsing.

Processing Database Query Results

Many database clients (MySQL Workbench, pgAdmin, DBeaver) export or copy query results as tab-separated text. Paste the copied result directly into this tool to get a JSON array of objects with column names as keys—perfect for quickly converting database output for API mocking, test fixtures, or data exploration.

Tips & Best Practices

• Copy directly from spreadsheets: When copying from Excel or Google Sheets, you do not need to save as a file—the clipboard data is already tab-separated and can be pasted directly into this tool
• Enable type parsing for numeric data: Without type parsing, all values are strings—enable "Parse numbers" to convert "30" to 30 for proper numeric handling in your code
• Include the header row: Ensure you copy the column header row along with the data—it becomes the JSON object key names and makes the output self-documenting
• Check for trailing tabs: Some spreadsheet exports add a trailing tab at the end of each row, creating an extra empty column in the output—trim your data if you see unexpected empty keys in the JSON

Frequently Asked Questions

Q: What is the difference between TSV and CSV?

A: Both are plain-text tabular data formats. CSV uses commas to separate columns; TSV uses tab characters. TSV is simpler to parse (tabs are almost never used in data values) but less common in file exports. The most practical advantage of TSV is that it handles data containing commas without needing to quote the values.

Q: Why does copying from Excel produce TSV instead of CSV?

A: Excel uses tab as the clipboard delimiter when you copy cells because it avoids ambiguity—data values often contain commas, but almost never contain tab characters. When you paste copied Excel cells into a text editor, you see tab characters between columns. This tool accepts that clipboard format directly.

Q: Is my TSV data private?

A: Yes. All conversion happens in your browser using JavaScript. Your data is never uploaded to any server or stored anywhere.

Q: Do I need an account to use this?

A: No. The tool is completely free with no registration required.