tsv-to-json

Paste tab-separated rows and get clean, structured JSON back instantly. Runs entirely in your browser, so your data never leaves your device. Free to use.

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

Cells are split on tabs; the first row becomes the object keys. Everything is converted live in your browser.

How it works

  1. Paste your TSV

    Paste tab-separated rows into the Input box, or press Try a sample. Conversion runs live in your browser.

  2. Set the JSON shape

    Turn First row is a header on to key each object by your column names, or off to get rows as plain lists. Pretty-print JSON adds indentation.

  3. Copy or download JSON

    The JSON appears in the Output box. Press Copy result, or Download .json to save it as a file.

Paste tab-separated rows and get clean, structured JSON back in an instant. It runs entirely in your browser, so your data stays on your device.

What is TSV to JSON?

TSV to JSON converts tab-separated values, the format you get from spreadsheets and many database exports, into JSON that APIs, scripts, and apps can consume. With a header row it produces an array of objects keyed by your column names; without one it produces an array of arrays. It is the quickest way to make a plain table programmable.

Who Benefits from This Tool

  • Developers: turn a spreadsheet export into seed data or an API payload in seconds.
  • Data engineers: reshape tab-delimited dumps into JSON for ingestion pipelines.
  • Analysts: convert exported tables into JSON for tools that expect structured input.
  • QA testers: build JSON fixtures from a quick spreadsheet mock-up.
  • No-code builders: feed automation platforms that require JSON rather than tables.

Key Features

  • Header-aware: use the first row as column names to get an array of keyed objects.
  • Arrays mode: turn the header toggle off to keep each row as an array of strings.
  • Pretty-print: output indented, readable JSON or compact single-line JSON.
  • Escape decoding: escaped tabs and newlines inside cells are restored on the way out.
  • Blank-line handling: empty lines are skipped so stray gaps do not create empty rows.
  • Live conversion: results and row and column stats update as you type.
  • Copy and download: copy the JSON or save it as a .json file.

How to Use

  1. Paste your tab-separated data into the input panel.
  2. Choose whether the first row is a header of column names.
  3. Toggle pretty-print on for readable JSON or off for compact output.
  4. Read the JSON result on the right as it updates live.
  5. Copy the output or download it as a .json file.

Common Use Cases

  • Converting a Google Sheets or Excel export into an API request body.
  • Generating JSON fixtures for automated tests from a quick table.
  • Preparing tab-delimited data for a tool that only accepts JSON.
  • Transforming a data dump into objects your script can iterate over.
  • Reshaping a lookup table into keyed JSON for configuration.

Tips and Best Practices

  • Copy directly from a spreadsheet. Cells are separated by tabs, which this tool expects.
  • Keep the header toggle on when your first row holds field names.
  • Use compact output when the JSON feeds an API and readability is not needed.
  • Check the column count stat to confirm every row lines up as expected.
  • If a value contains a real tab or newline, encode it as an escape so it survives conversion.
  • Load the sample to see how a header row maps onto object keys.

Limitations and Notes

All conversion happens locally in your browser and nothing is uploaded. The tool splits strictly on tabs, so comma-separated data will not parse as expected. Use a CSV tool for that. Every cell is treated as a string; numbers and booleans are not automatically inferred, because TSV carries no type information. Escaped sequences like \t and \n inside cells are decoded back to real tabs and newlines. Blank lines are ignored, and very large inputs above roughly two megabytes are rejected to keep the page responsive.

FAQs

No. Keep the header toggle on for keyed objects, or turn it off to get an array of arrays instead.

No. Every cell becomes a JSON string, since tab-separated data does not record whether a value is a number.

Not directly. This tool splits on tabs only; convert commas to tabs first or use a dedicated CSV tool.

They are skipped, so extra spacing in your input will not produce empty objects or rows.

Encode them as \t; the tool decodes recognized escapes back into real tabs and newlines on output.

Yes. Conversion runs entirely in your browser and your data never leaves your device.

More Development Tools

Other tools in Development Tools.

All Development Tools