TSV to JSON Converter

Summary

Paste or upload a TSV file and convert it to a formatted JSON array of objects instantly — all processing happens in your browser.

How it works

1. Paste your TSV text into the input area, or click "Load File" to open a .tsv or .txt file from your device.
2. The first row is automatically used as the header — each column name becomes a JSON object key.
3. Toggle "Trim whitespace" to strip leading and trailing spaces from each field value.
4. Toggle "Parse numbers & booleans" to coerce numeric strings and true/false values to their native JSON types.
5. Click "Convert" to see the formatted JSON output.
6. Use "Copy" to copy the JSON to your clipboard, or "Download .json" to save the file.

Use cases

• Converting spreadsheet exports (Google Sheets, Excel) saved as TSV to JSON for web apps.
• Transforming database query results exported as tab-delimited text into JSON for APIs.
• Preparing test fixture data by converting a TSV sample to JSON arrays of objects.
• Moving data between tools that only accept JSON (dashboards, charting libraries, NoSQL databases).
• Quickly inspecting the structure of an unfamiliar TSV file as readable JSON.
• Generating JSON datasets for prototyping front-end interfaces.
• Converting TSV configuration files to JSON for use with config parsers.
• Validating that a TSV export is well-formed before importing it into another system.

Frequently Asked Questions