How to Convert TSV to JSON
TSV — tab-separated values — is what you get when you copy a range straight out of Excel or Google Sheets, and it's a common export format from databases and analytics tools. JSON, meanwhile, is the language of the modern web and almost every API. This converter bridges the two instantly. Paste your tab-separated data and it uses the first row as keys to build a clean array of objects, converting numbers and booleans into real JSON types along the way. Prefer raw rows? Turn the header off for an array of arrays. Choose pretty printing for readability or minified output for transport, then copy or download. Everything runs in your browser, so even sensitive data stays on your device.
Paste your TSV
Paste tab-separated data or load the sample; it's parsed locally with nothing uploaded.
Choose the options
Set the header, type detection, trimming and pretty vs minified output.
Copy or download
Grab the JSON with one tap or save it as a .json file.
TSV vs JSON — What's the Difference?
TSV — tab-separated values
A flat, plain-text grid where columns are separated by tab characters and rows by line breaks. It's compact, opens directly in any spreadsheet, and is what you get when you copy cells from Excel. Because the delimiter is a tab, values can freely contain commas and spaces without needing quotes — one reason people prefer it over CSV for messy text.
JSON — JavaScript Object Notation
A structured, hierarchical format built from objects and arrays with real data types — strings, numbers, booleans and null. It's the standard for APIs, config and app state because it maps directly onto the data structures programming languages use. Converting TSV to JSON turns a flat grid into typed records your code can consume immediately.
Common Use Cases
Spreadsheet to API
Copy a range from Excel or Sheets and turn it into JSON your API or app can accept.
Seed & fixture data
Convert a quick table of records into JSON to seed a database or test suite.
Analytics exports
Reshape tab-delimited exports from analytics and BI tools into structured JSON.
Config generation
Build JSON config from a simple maintained spreadsheet instead of editing by hand.
Mock data for front-ends
Produce realistic JSON arrays to power UI prototypes and demos.
Data inspection
See flat tabular data as structured, typed JSON to understand its shape at a glance.
Migrations
Move tab-delimited dumps between systems that expect JSON input.
Quick transforms
A fast, no-install way to reshape data during everyday development.
Tips & Best Practices
Copy straight from a spreadsheet
Selecting cells in Excel or Google Sheets and pasting gives you perfect TSV — no need to save a file first.
Keep a clean header row
Use short, unique header names without tabs; they become your JSON keys, so clear names make cleaner objects.
Leave type detection on for data
It keeps IDs, counts and flags as real numbers and booleans. Turn it off if you need every value to stay a string.
Minify for transport, pretty for reading
Use minified output when sending JSON over the wire, and pretty printing when a human needs to read it.
Trim to avoid stray spaces
Trimming removes accidental spaces around values that can otherwise sneak into your keys and data.
Troubleshooting
Everything landed in one column
Your data is probably separated by commas or multiple spaces, not tabs. Make sure the columns are truly tab-delimited — copying from a spreadsheet guarantees this.
Numbers came out as strings
Turn on type detection. If a value still stays a string, it likely has stray characters or spaces — enable trimming too.
Keys look wrong
Check that the first row really is your header and that header cells don't contain tabs. Toggle the header option if your data has no header.
Extra empty object at the end
A trailing blank line can create an empty row; remove the final newline or it will be ignored automatically in most cases.
Frequently Asked Questions
How do I convert TSV to JSON for free?
Paste your tab-separated data above and JSON appears instantly. Copy it or download a .json file — free, no signup.
What is TSV?
TSV stands for tab-separated values: a plain-text table where columns are separated by tab characters and rows by line breaks. It's what you get when you copy cells from a spreadsheet.
Does it output an array of objects?
Yes. With the header option on, each row becomes an object keyed by the header names — the structure most APIs and apps expect.
Can I get an array of arrays instead?
Yes. Turn off the header option and each row becomes an array of values, useful for raw tabular data.
Are numbers and booleans converted?
Yes. With type detection on, values like 42 and true become real JSON numbers and booleans rather than strings.
Can I keep everything as strings?
Yes. Turn off type detection and every value is kept as a string, which is safer for things like ZIP codes or IDs with leading zeros.
Does it handle commas in values?
Yes. Because TSV splits strictly on tabs, values containing commas or spaces stay intact in a single field.
Can I minify the JSON?
Yes. Turn off pretty printing for compact, minified JSON that's ideal for sending over a network.
What does trimming do?
It removes leading and trailing spaces from each value, which keeps your keys and data clean.
Is my data sent to a server?
No. Everything happens inside your browser, so your data never leaves your device — safe even for sensitive files.
Can I download the result?
Yes. Save the output as a .json file, or copy it straight to your clipboard.
How large a file can it handle?
It comfortably converts tables with many thousands of rows, all in your browser.
Does the first row have to be a header?
No. If your data has no header, turn the option off and you'll get arrays instead of keyed objects.
What if a row has fewer columns?
Missing trailing values are filled with empty strings so every object keeps the same keys.
Does it work on phones?
Yes, in any modern browser on Windows, Mac, Android or iPhone with nothing to install.
Is this converter really free?
Completely free, forever — no account, no ads and no premium wall.
100% free · No signup · Processed in your browser · Data never sent
Last updated: August 2026 · FlipMyFormat TSV to JSON Converter
Written and maintained by the FlipMyFormat team · Runs entirely in your browser