WebToolsPlanet
Converter Tools

TSV to JSON Converter

Paste TSV data (or copy directly from Excel or Google Sheets) and convert it to JSON instantly. Output as an array of objects with column headers as keys, or as a raw array of arrays.

Last updated: May 21, 2026

Client-Side Processing
Input Data Stays on Device
Instant Local Execution

Find this tool useful? Support the project to keep it free!

Buy me a coffee

What is TSV to JSON Converter?

TSV (Tab-Separated Values) is a plain-text format where fields are separated by tab characters. It is the format Excel and Google Sheets use when you copy cells to the clipboard — making TSV the easiest way to get spreadsheet data into a program without exporting a file.

This converter turns TSV rows into JSON. With a header row, each row becomes an object with the header values as keys — the most useful format for APIs and data processing. Without a header, rows become arrays of strings. The output is valid, pretty-printed JSON ready to use in code.

How to Use TSV to JSON Converter

1

Copy cells from Excel or Google Sheets, or paste TSV text manually

2

Toggle "Header Row" if the first row contains column names

3

Choose output format: Array of Objects or Array of Arrays

4

Copy the JSON output or download it as a .json file

Common Use Cases

  • Developers copying spreadsheet data from Excel or Google Sheets and converting it to JSON for use in code.
  • Data engineers converting TSV database exports to JSON for API ingestion.
  • Analysts preparing TSV data files as JSON for loading into JavaScript applications.
  • Backend developers converting TSV configuration tables to JSON config files.
  • Teams converting TSV test data fixtures to JSON format for test suites.
  • Developers processing TSV report exports by converting them to JSON for filtering and transformation.

Example Input and Output

TSV data copied from a spreadsheet (or exported as TSV) is converted to a JSON array of objects.

TSV input
name	city	role
Alice	London	Engineer
Bob	Paris	Designer
Carol	Berlin	Manager
JSON output
[
  { "name": "Alice", "city": "London", "role": "Engineer" },
  { "name": "Bob", "city": "Paris", "role": "Designer" },
  { "name": "Carol", "city": "Berlin", "role": "Manager" }
]

Privacy

All conversion runs in your browser. No data is uploaded to any server.

Tip: paste from spreadsheet

Select any range of cells in Excel or Google Sheets, copy (Ctrl+C), and paste directly into the input. The tab and newline characters are preserved automatically.

Frequently Asked Questions

Can I paste directly from Excel or Google Sheets?
Yes. When you copy cells in Excel or Google Sheets, the clipboard contains tab-separated values with newline-separated rows — exactly TSV format. Paste directly into the input and the converter will process it.
What is the difference between Array of Objects and Array of Arrays?
Array of Objects (with Header Row on) produces [{"name":"Alice","city":"London"},...] — each row is an object with column names as keys. Array of Arrays produces [["Alice","London"],...] — each row is a plain list of values without keys.
What happens to empty cells?
Empty cells become empty strings ("") in the JSON output. They are not converted to null — if you need null for missing values, use the JSON Cleaner tool afterwards to remove empty strings.
Is my data sent to a server?
No. All conversion runs in your browser. Your data never leaves your device.

Related Tools

CSV to JSON Converter
Convert CSV files to JSON arrays instantly — with header mapping, delimiter options, and type inference.
JSON to CSV Converter
Convert a JSON array of objects to CSV. Flattens nested objects with dot-notation columns and handles arrays within values.
CSV to TSV Converter
Convert CSV (comma-separated values) to TSV (tab-separated values) online. Supports custom delimiters, quoted fields, and auto-detection.
XML to JSON Converter
Parse and convert XML to clean JSON instantly — attributes, namespaces, and nested elements handled.
JSON Formatter
Format, validate, and beautify JSON instantly — with clear error messages, Tree View, Diff mode, and Schema validation.
CSV Viewer
View, search, and sort CSV data as an interactive table. Supports comma, semicolon, tab, and pipe delimiters.