Format Code Now
/
ConvertJSON to TSV Next: Pug to HTML ›

JSON to TSV Converter

CV-104

Paste a JSON array and get tab-separated values: a header row of keys, then one line per item. Large numbers keep every digit.

Runs in your browser. Nothing is uploaded.

JSON array of objects or arrays

TSV

How to use it

  1. Paste a JSON array of objects, or of arrays.
  2. Leave the apostrophe option off unless a spreadsheet would run your cells as formulas.
  3. Press JSON to TSV.
  4. Copy the result into a sheet, or download the .tsv file.

How the columns are chosen

For an array of objects, the header is every key found, in the order first seen, and a missing key leaves an empty cell. An array of arrays is written line by line with no header. A single object is treated as one row. Nested objects and arrays are written as JSON text in their cell, null becomes an empty cell, and numbers are written exactly as typed, so a 20-digit ID is not rounded.

Tabs, quotes and line breaks

Plain TSV has no way to carry a tab or a line break inside a value, so a value that holds one, or a double quote, or a space at either end, is wrapped in double quotes with quotes doubled. Excel and Google Sheets read that correctly, but a strict TSV reader may not. The apostrophe option prefixes cells that start with =, +, - or @ so a spreadsheet does not run them as formulas. It changes those values, so it is off by default.

Error messages and what to do

MessageWhat it meansFix
Expected an array of objects or an array of arrays.The array holds plain values such as numbers or strings.Wrap each value in an object or in an array.
Mixed arrays and objects are not supported.The array holds both objects and arrays.Use one kind of item throughout.

Questions people ask

How do I convert JSON to TSV?

Paste a JSON array of objects and press JSON to TSV. The keys become the first line and each object becomes a line of tab-separated values. Paste the result into a spreadsheet or download the .tsv file.

What is the difference between TSV and CSV?

Both are plain text tables. CSV separates values with commas, TSV with tab characters. Tabs rarely appear in normal text, so TSV needs quoting less often, and it pastes cleanly into spreadsheet cells.

Are big numbers rounded?

No. Numbers are copied exactly as you typed them, so an ID with 20 digits stays intact. That is not true of tools that pass numbers through a floating-point value first.

What happens to nested objects?

They are written as JSON text inside the cell. TSV is flat, so there is no column per nested key. Flatten your JSON first if you need nested fields in their own columns.

Why did some cells get an apostrophe?

You ticked the formula option. It prefixes values that start with =, +, - or @, which a spreadsheet could otherwise run as a formula. Turn it off to keep the values untouched.

About this tool

Takes an array of objects (the header is every key seen, first seen first, and a missing key leaves an empty cell) or an array of arrays, and writes one line per item with tabs between values. A single object is treated as one row. A value that holds a tab, a double quote, a line break or a space at either end is wrapped in double quotes with quotes doubled, because plain TSV has no other way to carry it, so the program you paste into must read quotes. Nested objects and arrays are written as JSON text, null becomes an empty cell, and numbers keep the exact digits you typed, so large integers are not rounded. The apostrophe option prefixes cells that start with = + - or @ so a spreadsheet does not run them as formulas; it changes those values, so it is off by default.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.