Turn a JSON array into tab-separated rows you can paste straight into a spreadsheet
Runs in your browser. Nothing you type is sent anywhere. Updated on 24 Oct 2026.Tabs are what a spreadsheet puts on the clipboard, so TSV is the format to use when the destination is a paste into Excel, Sheets or Numbers rather than a file. A JSON array of objects becomes one row per object, with a column for every key any object has. Nested objects become dotted columns, and lists become JSON text in the cell.
The page starts with JSON to TSV already chosen.
Paste a JSON array of objects into the input pane.
Leave Find the list selected so each object becomes a row, or press One row to put the whole document in a single row.
Check the Table preview below the panes for the rows and columns.
Press Copy TSV and paste into Excel or Google Sheets, where each value lands in its own cell.
This converter moves structured data between JSON, YAML, XML, CSV, TSV, TOML and INI in every direction that makes sense: forty of the forty-two possible pairs. Paste the data or open the file and it works out which format it is from the content itself, not from the name on the end of it, then offers the conversion people usually want next. If the guess is wrong, one tap fixes it.
The difficult part is not parsing. It is being honest about shape. CSV and TSV are rows of columns; JSON, YAML, TOML and XML are values inside values; INI is one flat level of named sections. Moving between those shapes always decides something on your behalf, so every conversion prints one line saying what it decided: which list became the rows, which nested objects became dotted columns such as address.city, which keys were left out and why. A list inside a cell becomes JSON text rather than disappearing.
Excel is a way in and a way out rather than an eighth format. Open an .xlsx and one sheet is read in your browser and shown as CSV, so you can see exactly what will be converted; choose Excel in the To row and the result is saved as an .xlsx with typed cells, a bold header row and fitted column widths. XML to Excel is the common case: the repeating element becomes the rows, exactly as it does for CSV.
The rest of the article, and all 8 questions about Data Converter, are on the Data Converter page.
JSON, YAML, XML, CSV, TSV, TOML and INI, in forty of the forty-two possible directions. The two it refuses are CSV to INI and TSV to INI, because INI holds named sections and spreadsheet rows have no names, so every row would need an invented heading such as [row_1].
A spreadsheet needs rows, so the converter looks for the list that is the table. A JSON array of objects becomes one row per object. If the array sits inside an object, that array is used and the other top-level keys are named so you can see exactly what is not in the sheet. Nested objects become dotted columns such as address.city.
Both. Drop or open a .json, .yaml, .xml, .csv, .tsv, .toml, .ini or .cfg file and it is read on your device. The format is worked out from the content rather than the extension, so a file saved with the wrong name is still read correctly, and the tool says when the name and the content disagree.
Yes. Choose Excel in the To row and press Download Excel: the table is saved as an .xlsx with a bold header row, real numbers and dates, and codes like 007 kept as text. To go the other way, open an .xlsx of up to 10 MB; one sheet is read in your browser and shown as CSV, ready to become XML or JSON. Formulas come across as their saved results.
Still stuck? Ask about Data Converter and anybody who knows can answer. No account needed.
Same job, other tools: TSV to JSON – Convert tab-separated values, such as a paste from Excel, into JSON · JSON to YAML – Turn JSON into clean, readable YAML for configs.
In the collections JSON Tools · Developer Converters.