TSV (Tab-Separated Values) is a simple tabular format ideal for pasting into spreadsheets. This tool converts a JSON array of objects to TSV with a header row taken from the object keys. All processing happens in your browser — no data is uploaded.
TSV — tab-separated values — is the format spreadsheets actually want when you paste tabular data. CSV needs careful quoting around commas and newlines, but TSV's only rule is "one record per line, columns separated by a tab", which makes it a much better target for the clipboard → Excel workflow. This converter takes a JSON array of objects and produces TSV with the header row as the union of every object's keys, in first-seen order.
Embedded tab characters inside values are replaced with single spaces so the column count never breaks on paste — if you genuinely need to preserve tabs, JSON to CSV is the better tool. A top-level single object is wrapped to a one-row array automatically. Conversion is pure client-side, so the TSV string is safe even when your JSON contains tokens, secrets or PII.
Because most spreadsheets (Excel, Google Sheets, LibreOffice, Numbers) treat tabs as their default cell-delimiter when you paste. TSV avoids the quoting headaches of CSV — no need to wrap fields containing commas — and pastes into the right cells immediately.
It is replaced with a single space, so the column count stays correct on paste. If you need lossless tab preservation, switch to JSON to CSV — CSV can quote arbitrary characters, TSV by convention cannot.
The header row is the union of every key seen, in first-appearance order. Missing fields produce empty cells, so heterogeneous arrays paste cleanly.
Nested values are coerced to their default String() form (objects become [object Object]). For nested-friendly output, use the JSON to CSV page, which JSON-stringifies nested values into the cell.
Explore the full suite of DATA FORMATS tools and 290+ other free utilities at Chunky Munster.