json-to-tsv

Convert a JSON array of objects to tab-separated values you can paste straight into Excel or Google Sheets. Runs in your browser — nothing is uploaded.

  • 100% Free
  • Files stay private
  • Works in your browser
Try it now·json-to-tsv
InputJSON
OutputTSV

The TSV header is the union of every object's keys. Tabs and newlines inside values are escaped so the grid stays intact.

How it works

  1. Paste your JSON

    Type or paste a JSON array of objects into the Input box marked JSON. Each object becomes one row of the table.

  2. Check the TSV output

    The Output box fills with tab-separated text as you type. Its header row collects every key from your objects.

  3. Copy or download TSV

    Press Copy result to copy the tab-separated text, or Download .tsv to save it. Tiles show Input, Output, Rows and Columns.

Turn a JSON array of objects into a clean tab-separated grid you can paste straight into a spreadsheet. It runs entirely in your browser, so nothing is uploaded.

What is JSON to TSV?

JSON to TSV converts structured JSON data into tab-separated values, the plain-text table format that Excel, Google Sheets, and databases import without fuss. It builds a header from every key in your data and writes one row per object. That makes it the fastest way to move machine-readable JSON into a human-friendly table.

Who Benefits from This Tool

  • Data analysts: pour API responses into a spreadsheet for filtering, pivots, and charts.
  • Developers: export fixture or seed data into a table teammates can review at a glance.
  • Ops and support: convert exported records into rows that are easy to scan and share.
  • Analysts working with BI tools: prepare tab-delimited files for bulk import.
  • Anyone auditing data: flatten nested JSON into columns to spot missing or odd values.

Key Features

  • Union headers: the header row is the union of every object's keys, in first-seen order.
  • Flexible input: handles arrays of objects, arrays of arrays, arrays of scalars, or a single object.
  • Safe cell escaping: tabs, newlines, and returns inside values are escaped so the grid stays intact.
  • Nested value handling: arrays and objects inside a field become compact JSON in one cell.
  • Live output: the TSV updates as you type, with input, output, row, and column stats.
  • Copy and download: copy to the clipboard or save the result as a .tsv file.
  • Try a sample: load example JSON to preview the expected structure.

How to Use

  1. Paste your JSON array of objects into the input panel on the left.
  2. Watch the tab-separated output appear on the right as you type.
  3. Review the stats for row and column counts to confirm the shape.
  4. Copy the TSV or download it as a .tsv file.
  5. Paste it into your spreadsheet or database import tool.

Common Use Cases

  • Moving a REST API response into Excel or Google Sheets for analysis.
  • Preparing a tab-delimited file for a bulk database or CRM import.
  • Sharing structured data with a non-technical colleague as a simple table.
  • Flattening exported JSON logs into columns for quick review.
  • Building a lookup table from configuration data stored as JSON.

Tips and Best Practices

  • Make sure your top-level value is an array of objects for the cleanest column mapping.
  • If objects have different keys, expect a wide header that covers every field seen.
  • Load the sample first to confirm how nested fields collapse into single cells.
  • Paste TSV output directly; spreadsheets split tab-separated columns automatically.
  • Keep values free of stray tabs where possible, though the tool escapes them for safety.
  • For very large datasets, split the JSON so the input stays under the size cap.

Limitations and Notes

Conversion happens locally in your browser and your data is never uploaded. Because TSV is a flat grid, nested arrays and objects are not expanded into extra columns. They are serialized to JSON text inside a single cell. Tabs, newlines, carriage returns, and backslashes inside values are escaped so a round trip preserves them, which means the raw TSV may look slightly encoded compared to hand-typed text. Inputs above roughly two megabytes are rejected to keep the page responsive.

FAQs

An array of objects gives the cleanest table, but arrays of arrays, arrays of scalars, and single objects are also supported.

It is the union of every key across all objects, kept in the order each key first appears.

Nested arrays and objects are written as compact JSON inside one cell rather than spread across columns.

Yes. Download the .tsv file or paste the tab-separated text and your spreadsheet will split it into columns.

No. Everything is processed in your browser and nothing leaves your device.

Tabs and newlines are escaped so values with those characters do not break the row-and-tab grid.

More Development Tools

Other tools in Development Tools.

All Development Tools