TSV to JSON Converter
Turn tab-separated data (with a header row) into a JSON array of objects.
How to use the TSV to JSON Converter
- Paste TSV with the column names on the first row.
- Each following row becomes an object keyed by those names.
- Copy the JSON.
About the TSV to JSON Converter
The TSV to JSON Converter turns tab-separated data into a JSON array of objects. Put your column names on the first row, and every following row becomes one object keyed by those headers. TSV is what you get when you copy a range straight out of a spreadsheet, so this is a quick bridge from a sheet into structured data your code can consume.
The converter is a little smarter than a plain split: cells that look like numbers are converted into real JSON numbers rather than being left as quoted strings. That means a column of prices or counts arrives ready to use in calculations, without a separate parsing step. Each row is matched to the header row position by position, keeping the mapping predictable.
Conversion happens entirely in your browser, so the data you paste is never uploaded. Paste your TSV, copy the JSON, and you are done. If your data is comma-separated instead, the CSV to JSON Converter handles that, and to go from JSON back to a spreadsheet-friendly format use the JSON to TSV Converter.
Frequently asked questions
Where do the object keys come from?
The first row of your TSV is treated as the header. Its values become the keys, and every following row becomes one object using those keys, matched column by column in order.
Are numbers converted automatically?
Yes. Cells that look numeric are turned into real JSON numbers rather than strings, so numeric columns are ready for arithmetic and comparisons without an extra parsing step in your code.
What is the difference between TSV and CSV here?
TSV separates columns with tab characters, which is what you get when copying directly from a spreadsheet. If your data uses commas instead, the CSV to JSON Converter is the right tool.
Do I need a header row?
Yes. The first row supplies the keys for every object, so the converter expects your column names there. Without a header row the resulting objects would have no meaningful field names.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser and nothing is sent to a server, so pasting internal or sensitive spreadsheet data is safe.