TSV to JSON Converter
TSV (tab-separated values) is what Excel and Google Sheets paste to the clipboard. Convert any TSV table to a JSON array of objects — keys from the header row, values from each data row. Useful for moving data from spreadsheets into JSON-consuming tools.
How to use the TSV to JSON Converter
Paste TSV copied from a spreadsheet. The first row is read as keys and each following row as an object. Choose whether to auto-detect types and pick the indent width, then copy the JSON.
Turning spreadsheet rows into JSON
When you copy a range of cells from Excel or Google Sheets, the clipboard holds tab-separated values — columns split by tabs, rows by newlines. That pastes neatly into a text box but is not something a JSON API or a JavaScript array can consume directly.
This converts pasted TSV into a JSON array of objects, using the header row as keys and each data row as a record, with optional type detection so numbers, booleans, and empty cells become real JSON types instead of strings. If you need CSV rather than JSON, the TSV to CSV converter changes only the delimiter; to turn the array into newline-delimited records, the JSONL converter.
Common use cases
- Spreadsheet to JSON — paste cells from Excel or Sheets and get JSON.
- Seed test data — build a JSON fixture from a quick table.
- Feed an API — turn rows into a JSON request body.
- Detect types — cast numbers and booleans instead of leaving strings.
- Choose formatting — 2- or 4-space indent, or minified output.