JSON to TSV Converter
Convert JSON arrays or objects into TSV (Tab-Separated Values) format for databases, spreadsheets, and command-line data tools.
Conversion Options
Recommended Settings
Pro Tips
- •Columns are built from the union of keys across every object in the array
- •TSV uses tabs instead of commas, so it needs no quote-escaping like CSV does
- •Enable 'Escape tabs and newlines' if any value might contain a literal tab or line break, which would otherwise break TSV columns
- •Nested objects and arrays are converted to compact JSON strings in a single cell
- •Missing keys and null/undefined values become empty cells
Most Popular
Most users keep tab/newline escaping enabled to guarantee valid TSV output
When to Use This Tool
Convert JSON API responses or exports into TSV for database COPY/LOAD commands. TSV is often preferred because it avoids comma-delimiter ambiguity entirely.
Turn JSON data into TSV for clean import into Microsoft Excel, Google Sheets, or LibreOffice Calc, especially when values contain commas that would complicate CSV.
Convert JSON to TSV for analysis in R, Python pandas, or Apache Spark, where tab-delimited files are simpler and less error-prone than comma-delimited ones.
Generate TSV from JSON for processing with grep, awk, cut, and other Unix tools, where tab delimiters make field extraction more reliable.
How It Works
Parse the JSON input and normalize it into a list of records (a single object becomes a one-row list)
Build column headers from the union of keys across every object
Convert each value to text, turning nested objects and arrays into compact JSON strings
Escape tabs, carriage returns, and newlines inside values if enabled, so they can't be mistaken for delimiters
Join columns with tab characters and rows with newlines to produce the final TSV
100% Private
Files never leave your device. All processing happens locally in your browser.
Lightning Fast
Powered by Pure JavaScript for optimal performance on modern browsers.
Secure
No data collection, no tracking, no sign-up required.
Frequently Asked Questions
What JSON structures does this tool accept?
Either an array of objects (each object becomes a row) or a single flat object (treated as one row). An array of primitive values is also supported and becomes a single 'Value' column.
What's the difference between TSV and CSV?
TSV (Tab-Separated Values) uses tab characters to separate columns instead of commas. Since tabs rarely appear in normal text, TSV avoids most of the quote-escaping complexity that CSV needs for values containing commas.
What happens if a value contains a tab or newline?
With 'Escape tabs and newlines' enabled, any literal tab, carriage return, or newline inside a value is converted to a visible \t, \r, or \n sequence so it can't be mistaken for a column or row separator. Disable this only if you're sure your data has none of these characters.
How are missing keys or null values handled?
Column headers are built from the union of keys across all objects. If a particular object is missing a key, or that value is null or undefined, its cell is left empty in the TSV output.
Will Excel or Google Sheets open the generated TSV?
Yes. Excel, Google Sheets, and LibreOffice Calc all detect tab delimiters automatically when importing a .tsv file, splitting columns without any extra configuration.