Convert TSV to JSON
Convert tab-separated values to a JSON file. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Convert TSV to JSON
- 1. Paste your TSV data. Paste tab-separated rows, whether copied straight out of a spreadsheet or exported from a database tool. Each row becomes one object in the resulting JSON array.
- 2. Set the header and type options. Turn on First row is header to use the first line as property names instead of data, and Parse numbers and booleans to convert values like 36 or true into their real JSON types rather than strings.
- 3. Pick the output indent and copy. Choose 2 spaces, 4 spaces or tabs for the Indent setting, then copy the resulting JSON array and paste it into your application code, config, or API request body.
When to use Convert TSV to JSON
Convert TSV to JSON is for turning spreadsheet-shaped data, copied directly out of a tool like Excel or Google Sheets, into a JSON array of objects that an application can consume. It handles the header row and type conversion so you do not write a parser for every export.
- Turning a copied spreadsheet range into test data. You selected and copied a range of rows out of Google Sheets and want it as a JSON array of objects to use as fixture data in a test suite.
- Importing a database export into an application. A database tool exported query results as tab-separated text, and your application's seed script or API expects a JSON array to load instead.
- Converting a product catalog for an e-commerce API. A merchandising team maintains product data in a spreadsheet and hands you a TSV export that needs to become a JSON array for a product import endpoint.
- Preparing survey results for analysis code. Survey responses were exported from a spreadsheet as tab-separated rows, and your analysis script reads JSON records rather than a flat table.
Examples
Convert tab-separated rows
Input
name age Ada 36
Output
[
{
"name": "Ada",
"age": 36
}
]About the Convert TSV to JSON tool
Convert TSV to JSON is a free online tool that works entirely inside your web browser. Convert tab-separated values to a JSON file. Because the processing happens on your own device, nothing you enter is uploaded, logged or stored anywhere.
This page is one of 90 JSON utilities on EditSafely. Each one does a single job well, and all of them follow the same rule: your input stays on your machine.
You can shape the output with 3 settings, including First row is header, Parse numbers and booleans and Indent, and the result refreshes the moment you change one. A worked example further down the page shows exactly what the tool produces for a real input.
Because nothing leaves your device, the tool is suitable for sensitive content such as internal documents, credentials or customer data. It also responds instantly, since every keystroke is handled on your own machine rather than by a remote API.
Frequently asked questions
Is Convert TSV to JSON free to use?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
Everything happens locally. Your browser downloads the tool's code once, then does all the processing itself; nothing you enter is transmitted, stored or logged. You can even go offline after the page loads and it will still work.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
No. The tool works in any modern browser on desktop, tablet or phone. There is no account to create, no extension to add and no software to install.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.