TSV to JSON Converter
Convert TSV (tab-separated values) to JSON and back, bidirectionally.
How this tool works
Choose a direction
TSV to JSON, or JSON to TSV.
Paste your data
Tab-separated rows with a header row, or a JSON array of flat objects.
Values are type-inferred
"true"/"false" become booleans and numeric strings become numbers automatically.
Copy the result
The converted output is ready to copy, with row and column counts shown.
Quick facts
- Category
- Converters
- Best for
- Converting spreadsheet data (which pastes as TSV) into JSON, or exporting JSON back to TSV
About this tool
Convert tab-separated values to a JSON array of objects, or the reverse, using the first row as headers the same way csv-json-converter treats a CSV header row. TSV's parsing logic is meaningfully simpler than CSV's: because a literal tab character rarely appears inside real-world tabular data (unlike a comma, which shows up constantly in ordinary text), TSV doesn't need CSV's quoting and escaping rules for fields that contain the delimiter - a field is just whatever text sits between two tab characters, with no quote-aware parser required to correctly split rows. On the JSON-to-TSV direction, any literal tab or newline character that does show up inside a value is replaced with a space rather than escaped, since TSV has no standard escaping convention the way CSV's double-quote rule does. Values are type-inferred the same way as the CSV converter - "true"/"false" become booleans, numeric strings become numbers - so round-tripping data preserves its types rather than flattening everything to strings. Useful for converting data copied from a spreadsheet (which pastes as TSV by default) into JSON, or exporting JSON as TSV for a quick paste back into a spreadsheet. Runs entirely client-side.
Why use this tool
Simpler parsing than CSV
No quoting/escaping rules needed - a tab rarely appears inside real data the way a comma does.
Spreadsheet-friendly
Matches the format most spreadsheet apps use when you copy and paste cells directly.
Automatic type inference
Booleans and numbers convert to their real JSON types instead of staying as strings.
Bidirectional
Convert TSV to JSON or JSON back to TSV from the same tool.
Frequently asked questions
The core conversion logic is the same - first row as headers, values type-inferred into booleans/numbers/strings - but the delimiter and escaping rules differ. CSV needs a quote-aware parser to correctly handle fields containing commas, quotes, or newlines; TSV skips all of that since a literal tab is uncommon inside real data, making the parser simpler and the format a natural fit for data copied straight out of a spreadsheet, which pastes as tab-separated by default.
When converting JSON to TSV, any tab or newline character inside a value is replaced with a space, since TSV has no standard quoting or escaping convention the way CSV does with double quotes. This means a value containing an intentional tab character won't round-trip perfectly - if that's a concern for your data, CSV's quote-based escaping is the more robust format.
Most spreadsheet applications (Excel, Google Sheets, Numbers) use tab-separated values as their internal clipboard format when you copy a range of cells, since it avoids any ambiguity with commas that might appear inside cell content. This is exactly why a TSV-specific converter is useful - pasting spreadsheet data directly into this tool works without needing to first re-save it as a CSV file.
Explore more free tools
Formatters, converters, validators, and generators - all free and running entirely in your browser.
Browse more tools