Skip to content
ToolQivo

TSV to JSON

Convert tab-separated data — or a spreadsheet paste — straight into JSON.

Developer Tools Reviews Free · no sign-up

Quick Tool Overview

The TSV to JSON converter reads tab-separated data — including anything copied straight out of a spreadsheet — into an array of objects, typing the values and flagging rows whose column count does not match the header.

What it does
Converts tab-separated data into JSON
You give it
A TSV file or a spreadsheet copy-paste
You get back
An array of objects keyed by the header row
Best for
Getting spreadsheet data into code or a test fixture
Developer Tools Free, unlimited use No sign-up Runs in your browser

About the TSV to JSON

Copy any block of cells out of Excel, Google Sheets or Numbers and what lands on the clipboard is tab-separated text. This converts it directly to JSON, so there is no saving a file and no import step in between.

The header row becomes the object keys, and each subsequent row becomes an object. Values are typed by default — numbers become numbers, true and false become booleans, blanks become null — with the sensible exception of anything with a leading zero, which stays a string so postcodes, SKUs and phone numbers survive. Rows whose column count does not match the header are flagged by line number, which is how a stray tab inside a cell announces itself.

Key features of the TSV to JSON

No export step

A copy from Excel, Sheets or Numbers is already tab-separated, so pasting it works directly.

Delimiter detected

Tab, comma, semicolon and pipe are all recognised, and the guess can be overridden when the data is unusual.

Identifiers stay text

A value with a leading zero keeps it, so postcodes, SKUs and phone numbers survive — the thing spreadsheets themselves get wrong.

Ragged rows flagged

A row with the wrong column count is reported by line number, which is how an unquoted tab inside a cell announces itself.

Headerless data supported

Turn the header option off and columns are named column_1, column_2 and so on, so nothing is dropped.

How to use the TSV to JSON

  1. 1

    Paste your data

    Straight from a spreadsheet, or a .tsv file's contents.

  2. 2

    Confirm the delimiter

    Tab is detected automatically; comma, semicolon and pipe are also supported.

  3. 3

    Choose type handling

    Typed values give real numbers and booleans; turn it off to keep every field a string.

  4. 4

    Copy the JSON

    An array of objects, formatted and ready to use.

Frequently asked questions

Yes. A spreadsheet copy is tab-separated text, which is exactly what this reads. No file export is needed.

Reviews of the TSV to JSON

What people who use the TSV to JSON think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the TSV to JSON. It takes half a minute and no account.

Write the first review

More developer tools