TSV to JSON Converter

This tool turns TSV (tab-separated values) spreadsheets into JSON you can paste into APIs, configuration files, or JavaScript code. Parsing runs entirely in your browser: paste or upload TSV, toggle whether the first row should become object keys, and copy or download formatted JSON.

What is TSV?

TSV stores tables as plain text. Each row is a line, and columns are separated by tab characters. Many spreadsheet apps export TSV when you choose tab-delimited text. It is a simple, line-oriented format without the quoting rules that CSV often needs for commas inside cells.

What is JSON?

JSON is a structured text format built from objects (key-value maps) and arrays (ordered lists). Web APIs and modern apps frequently use JSON because it maps cleanly to data structures in JavaScript, Python, and many other languages.

How this converter behaves

First row as keys (default on): Row one becomes property names; each following row becomes one JSON object in an array.
First row as keys off: Output is a JSON array of rows, where each row is an array of string cell values.
Empty lines: Greedy empty-line skipping removes blank rows so they do not create empty arrays.
Duplicate headers: If two columns share the same header text, later columns get a numeric suffix so keys stay unique.

Typical uses

Turning spreadsheet exports into JSON fixtures for tests or demos.
Preparing tabular data for REST payloads or document databases.
Quickly comparing spreadsheet rows side by side in a structured JSON viewer.

Frequently Asked Questions

Does this tool send my data to a server?

No. Conversion runs locally in your browser. Nothing is uploaded unless you explicitly use other site features outside this tool.

Are numbers converted from strings to JSON numbers?

Values stay as strings in the JSON output so the mapping from spreadsheet cells is lossless. If you need numeric types, post-process in your language or pipeline.

Can I convert JSON back to TSV?

Use a dedicated JSON-to-TSV tool for the reverse direction. This page only handles TSV to JSON.

What if my file uses commas instead of tabs?

That file is CSV, not TSV. Use a CSV-to-JSON converter instead so delimiters and quoting are handled correctly.

Report Tool or Give Us Suggestions