広告が嫌いですか? 行く広告なし今日 

TSVからJSONへのコンバーター

データ開発者

広告・取り除く？

入力

自動処理

出力

クライアント側

広告・取り除く？

ガイド

TSVからJSONへのコンバーター

Convert tab-separated values (TSV) data to JSON instantly. Paste spreadsheet data or TSV files and get clean, structured JSON output — as an array of objects with headers as keys, or as a simple array of arrays. Handles quoted fields, type inference, and configurable formatting.

使い方

Paste your TSV data into the input area. If your first row contains column headers, keep “First row as headers” checked to generate an array of objects with those headers as keys. Enable type inference to automatically convert numbers, booleans, and null values. The JSON output updates instantly — copy it with one click or adjust the indentation to your preference.

特徴

ヘッダー検出 – Use the first row as object keys to generate meaningful JSON with named properties instead of raw arrays.
Type Inference – Automatically detects and converts numbers, booleans (true/false), and null values instead of leaving everything as strings.
Two Output Formats – Array of Objects (with headers as keys) or Array of Arrays (raw data) depending on your needs.
Quoted Field Handling – Correctly parses fields wrapped in double quotes, including embedded tabs, newlines, and escaped quotes within quoted fields.
Empty Value Control – Choose how to handle empty cells: convert to null, keep as empty string, or exclude the key entirely.
設定可能なインデント – 2 spaces, 4 spaces, tabs, or minified output for production use.
リアルタイム変換 – Output updates instantly as you paste data or change any option.

このツールを使用するタイミング

Use this tool when you need to convert spreadsheet exports, database dumps, or clipboard data from tab-separated format into JSON for APIs, configuration files, or data processing pipelines. It’s especially useful when copying data from Excel or Google Sheets (which copies as TSV by default), converting log files with tab delimiters, or preparing data for import into web applications and NoSQL databases.

広告・取り除く？

 よくある質問

What is TSV format?

TSV (Tab-Separated Values) is a simple text format for storing tabular data where each row is a line and columns are separated by tab characters. It's one of the most common data exchange formats — when you copy cells from Excel or Google Sheets, the clipboard data is in TSV format. TSV is similar to CSV but uses tabs instead of commas, which avoids issues with commas appearing inside data values.
What is the difference between TSV and CSV?

Both TSV and CSV store tabular data as plain text, but they use different delimiters. CSV uses commas to separate columns, while TSV uses tab characters. TSV has an advantage when your data contains commas (like addresses or descriptions) since tabs rarely appear in natural text. CSV is more widely supported by tools and libraries, but TSV is what you get when copying from spreadsheets. Both can use quoted fields to handle special characters.
What is type inference in data conversion?

Type inference automatically detects the data type of each value instead of treating everything as a string. When enabled, the converter recognizes that '42' is a number (not the string "42"), 'true' is a boolean, and empty cells can be null. This produces cleaner JSON that's ready for use in applications without additional parsing. You can disable type inference if you want all values preserved as strings.
How do I copy TSV data from a spreadsheet?

When you select and copy cells in Excel, Google Sheets, or most spreadsheet applications, the clipboard automatically contains TSV-formatted data — columns are separated by tabs and rows by newlines. Simply select your data range, press Ctrl+C (or Cmd+C on Mac), and paste directly into this tool. The converter will parse the tab-separated columns automatically. This is the fastest way to convert spreadsheet data to JSON.