How do I turn a JSON array into TSV?

Paste a JSON array of objects into the input box, like [{"name":"Ada","age":36},{"name":"Linus","age":54}]. The tool reads every object, builds one column per key (name, age), and writes a tab between cells with a newline between rows. The result for that example is a header line name age, then Ada 36, then Linus 54. Copy it, click into cell A1 in Excel or Google Sheets, paste, and it lands across columns instantly.

Why pick TSV over CSV?

CSV uses commas, and the moment a value contains a comma you need quoting and escaping, which is where pasted data breaks. TSV uses tabs, and real-world text almost never contains a tab, so cells stay clean with no quoting at all. That is exactly why pasting into Excel or Google Sheets works better with TSV: the spreadsheet splits on tabs by default. Use TSV when the destination is a spreadsheet paste; use CSV when a program downstream expects a .csv file.

What if a field itself contains a tab or a newline?

That is the one case that can break a paste, so you choose the behavior. The default escape mode wraps any cell holding a tab, newline, or quote in double quotes and doubles inner quotes, the same convention spreadsheets understand. The replace mode swaps every tab and newline inside a value for a single space so the row can never spill into extra cells or rows. Pick replace when you are pasting into Sheets and want zero surprises; pick escape when you need the original characters preserved.

How are nested objects and arrays handled?

A cell can only hold one value, so nested structures get JSON-stringified into that cell. An object like {"city":"London"} becomes the text {"city":"London"} and an array like ["a","b"] becomes ["a","b"]. Nothing is dropped, and the cell stays re-parseable if you later read it back with JSON.parse. If you would rather flatten nested keys into dotted columns such as address.city, run the JSON through the JSON to CSV tool, which has a flatten toggle.

Can I paste the output directly into Excel?

Yes, that is the point. Click Copy TSV, open Excel or Google Sheets, select the top-left cell, and paste with Ctrl+V or Cmd+V. The data spreads across columns and rows because both apps treat a pasted tab as a column break and a newline as a row break. If you instead need a file to open, click Download .tsv and open it from the spreadsheet, where TSV imports without the comma-versus-semicolon delimiter prompt that CSV often triggers in non-US locales.

Does the column order stay consistent across rows?

Yes. The header is the union of every object's keys, kept in the order each key first appears across the whole array. So if the first object has name and age and a later object adds city, the columns come out name, age, city, and any row missing city simply gets an empty cell in that column. This keeps heterogeneous data such as mixed API responses lined up under the correct headers instead of shifting columns row to row.

Paste an API response straight into a spreadsheet

You hit an endpoint that returns a JSON array of records and you need it in a sheet for a quick pivot or a stakeholder review. Paste the JSON, copy the TSV, click cell A1 in Google Sheets, and paste. The rows land across columns with no import wizard, no delimiter prompt, and no comma-inside-a-value breaking the layout. Thirty seconds from raw JSON to a sortable table.

Hand structured data to a non-technical teammate

A colleague in finance or ops lives in Excel and does not run scripts. You have the data as JSON. Convert it to TSV, paste it into a workbook, and send the file. They get clean columns they can filter and chart, while you never had to write an export script or stand up a tool just to move one dataset across the desk.

Stage data for a bulk import that expects tab-delimited input

Many database loaders and admin import screens default to tab-delimited uploads because tabs dodge the quoting headaches of CSV. Turn your JSON into TSV with the header row on (or off, if the importer maps positions), choose replace mode so no embedded tab can shift a column, download the .tsv, and feed it straight into the loader.

Diff two JSON datasets as flat tables

Comparing two JSON dumps key by key is painful in raw form. Convert each to TSV with a stable, union-based column order, drop both into adjacent spreadsheet tabs, and the columns align so a row-by-row or column-by-column comparison becomes trivial. The first-seen key order keeps both tables laid out the same way.

JSON to TSV Converter: Paste Straight Into Excel

Turn a JSON array into tab-separated values you can paste straight into Excel or Google Sheets, with header toggle and safe escaping, all in your browser

Runs locally
Category Format Converter
Best for Turning pasted content or local files into a handoff-friendly format.

Tab / newline in a valuereplace is safest for a Sheets paste

Include header row

JSON input

TSV output

What this tool does

Free online JSON to TSV converter. Paste a JSON array of objects and get back tab-separated values, one column per key. TSV is the format spreadsheets actually want when you paste: a tab between cells, a newline between rows, no quoting puzzle to get wrong. The column header is the union of every object's keys in first-seen order, so records with missing fields still line up under the right columns. Nested objects and arrays get JSON-stringified into a single cell so nothing silently disappears. When a value contains a tab, newline, or quote, pick how to handle it: wrap the cell in quotes and escape it the spreadsheet way, or swap the tab and newline for a space so a paste into Sheets never breaks across cells. Toggle the header row off when you only want data, copy the result with one click, or download a real .tsv file. Everything runs locally in your browser tab, so your JSON never touches a server.

Tool details

Input: Text + Structured content; The page exposes text boxes, numeric controls, file pickers, or structured inputs depending on the tool.
Output: Live result + Copy + Download; The result area focuses on usable output, with copy, download, or preview actions when supported.
Privacy: Browser-side processing; The main tool logic does not call an external API, so inputs normally stay in the current tab.
Save / share: Shareable URL state; Key settings are encoded in the URL so another person can reopen the same setup.
Performance budget: Initial JS <= 9 KB; No WASM budget is declared, keeping the tool quick to open on mobile.
Best fit: Format Converter · Developer; Category and role tags drive related tools, internal links, and quick fit checks.

How to use

1. Input

Paste or drop your content into the tool panel.
2. Process

Click the button. All processing is local in your browser.
3. Copy / Download

Copy the result or download to disk in one click.

How JSON to TSV Converter fits into your work

Use it when the main problem is getting content from one practical format into another.

Conversion jobs

Turning pasted content or local files into a handoff-friendly format.
Previewing a conversion before you use it in a larger workflow.
Cleaning small format mismatches without opening a full editor.

Conversion checks

Try a small sample first when the source format is messy.
Check character encoding, separators, and line endings after conversion.
Keep the source until the converted output has been reviewed.

Good next steps

These links move the current task into a more complete workflow.

Real-world use cases

Paste an API response straight into a spreadsheet
You hit an endpoint that returns a JSON array of records and you need it in a sheet for a quick pivot or a stakeholder review. Paste the JSON, copy the TSV, click cell A1 in Google Sheets, and paste. The rows land across columns with no import wizard, no delimiter prompt, and no comma-inside-a-value breaking the layout. Thirty seconds from raw JSON to a sortable table.
Hand structured data to a non-technical teammate
A colleague in finance or ops lives in Excel and does not run scripts. You have the data as JSON. Convert it to TSV, paste it into a workbook, and send the file. They get clean columns they can filter and chart, while you never had to write an export script or stand up a tool just to move one dataset across the desk.
Stage data for a bulk import that expects tab-delimited input
Many database loaders and admin import screens default to tab-delimited uploads because tabs dodge the quoting headaches of CSV. Turn your JSON into TSV with the header row on (or off, if the importer maps positions), choose replace mode so no embedded tab can shift a column, download the .tsv, and feed it straight into the loader.
Diff two JSON datasets as flat tables
Comparing two JSON dumps key by key is painful in raw form. Convert each to TSV with a stable, union-based column order, drop both into adjacent spreadsheet tabs, and the columns align so a row-by-row or column-by-column comparison becomes trivial. The first-seen key order keeps both tables laid out the same way.

Common pitfalls

Pasting a single JSON object instead of an array. The tool expects a top-level array of objects like [{...},{...}]. A bare object {...} becomes a single one-row table, which is usually not what you wanted. Wrap your records in square brackets so each becomes its own row.
Leaving escape mode on when the destination is a Sheets paste. If a value legitimately contains a newline, escape mode quotes it, but some paste targets still split on the inner newline. When you are pasting into Google Sheets and want zero risk of a row spilling, switch to replace mode so tabs and newlines inside cells become spaces.
Expecting nested objects to flatten into separate columns. This tool stringifies a nested object or array into one cell on purpose, to stay lossless. If you need address.city and address.zip as their own columns, use the JSON to CSV tool with its flatten toggle instead.

Privacy

Parsing the JSON and building the TSV are plain JavaScript that run inside your browser tab. Your data is never uploaded, and nothing is logged about what you converted. The one thing to know: the shareable link mirrors your input into the URL only while it stays short, so a short example travels in the link but a large dataset stays local and is never written to the URL. For anything sensitive, use the copy or download button rather than sharing the link.

FAQ

Tool combos

Folks in your role tend to reach for these alongside this tool.

Developer

Browse all tools for this role

JSON to TSV Converter: Paste Straight Into Excel

What this tool does

Tool details

How to use

1. Input

2. Process

3. Copy / Download

How JSON to TSV Converter fits into your work

Conversion jobs

Conversion checks

Good next steps

Real-world use cases

Paste an API response straight into a spreadsheet

Hand structured data to a non-technical teammate

Stage data for a bulk import that expects tab-delimited input

Diff two JSON datasets as flat tables

Common pitfalls

Privacy

FAQ

Unit Converter

Percentage Calculator

JSON to CSV Converter

TSV to CSV Converter

CSV ⇄ JSON Converter

JSON to XML Converter

Angle Converter

Base64 Encoder & Decoder

Base64 to File Converter

BBCode to HTML Converter

Chinese Numeric Converter

Chinese Pinyin Converter