TSV ↔ JSON
Convert between TSV and JSON
TSV Input1 lines • 58 chars
JSON Output0 lines • 0 chars
About TSV to JSON Converter
1What is it?
Convert Tab-Separated Values (TSV) into structured JSON data. TSV is often used in research datasets and clipboard data from Excel/Sheets. This tool reliably parses TSV and outputs a JSON array of objects, handling tabs and special characters correctly.
2Use Cases
- Convert data copied directly from Excel/Google Sheets (which often pastes as TSV)
- Process linguistic or research datasets stored in TSV
- Import legacy data dumps into modern NoSQL databases
- Visualize tabular data in web applications
3Examples
TSV to JSON
Input
Name Age John 30
Output
[{"Name":"John","Age":"30"}]?Frequently Asked Questions
Why TSV instead of CSV?
TSV is simpler because tabs rarely appear in actual data content, unlike commas (used in text, numbers). This makes TSV less prone to parsing errors without needing complex quoting rules.
Can I paste directly from Excel?
Yes! When you copy cells in Excel and paste them into a text editor, they are usually tab-separated. Paste that directly here to get JSON.