TSV & CSV Converter
Convert tab-separated data and CSV text in either direction
TSV & CSV Converter — what it does
Convert between tab-separated and comma-separated data in either direction, with quoting applied where values need it. TSV is what a spreadsheet puts on your clipboard when you copy a range, and CSV is what most importers expect — the gap between them comes up constantly.
When this tool helps
- Turning a range copied out of a spreadsheet into CSV for an import.
- Converting a CSV into tab-separated text so it pastes cleanly into a spreadsheet.
- Normalising a database client's TSV export into standard CSV.
How to use it
- Choose the conversion direction.
- Paste the input text.
- Process the conversion.
- Copy or download the result.
Accuracy, limits, and good practice
- TSV is safer for text containing commas, because tab characters almost never occur inside real values.
- Converting to CSV quotes any value containing a comma, quote or line break, which keeps the file parseable everywhere.
- When a CSV opens as one long column in a spreadsheet, converting to TSV and pasting is often faster than fighting the import dialog.
- Paste through a plain text editor first if the data came from a word processor; smart quotes and non-breaking spaces travel with it and break parsing.
Frequently asked questions
Why does my spreadsheet paste as TSV?
Copying a range puts tab-separated text on the clipboard, which is why pasting into a text editor gives columns split by tabs.
Which format should I keep files in?
CSV for interchange, since more tools accept it. TSV for pasting into spreadsheets and for data full of commas.
Does it handle quoted fields?
Yes, quoting is applied and interpreted so values containing separators survive the round trip.
Does it change the line endings?
Lines are written with standard breaks. If a downstream tool is strict about Windows or Unix endings, check the file after converting.
Related tools on this site
- CSV File Difference — Compare two CSV files by a key column and export differences
- CSV Column Type Detector — Detect likely text, number, date, boolean, and empty column types
- Excel to JSON — Convert a selected worksheet into object arrays or row arrays
Everything above runs inside this page. TSV & CSV Converter needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
TSV 與 CSV 互轉能做什麼
在 Tab 分隔與逗號分隔資料之間雙向轉換，並在必要時為值加上引號。從試算表複製一個範圍時，剪貼簿裡放的是 TSV，而多數匯入程式要的是 CSV——兩者之間的落差天天都會遇到。
什麼時候用得上
- 把從試算表複製的範圍轉成 CSV 以便匯入。
- 把 CSV 轉成 Tab 分隔文字，貼進試算表時才乾淨。
- 把資料庫工具的 TSV 匯出統一成標準 CSV。
使用步驟
- 選擇轉換方向。
- 貼上輸入文字。
- 執行轉換。
- 複製或下載結果。
精確度、限制與實務建議
- 含逗號的文字用 TSV 更安全，因為真實值裡幾乎不會出現 Tab 字元。
- 轉成 CSV 時，含逗號、引號或換行的值都會加引號，確保檔案到哪都解析得了。
- CSV 在試算表中擠成一欄時，轉成 TSV 再貼上，往往比跟匯入對話框搏鬥更快。
- 資料若來自文書軟體，請先貼過純文字編輯器；智慧引號與不換行空格會一路跟著跑，並弄壞解析。
常見問題
為什麼試算表貼出來是 TSV？
複製範圍時剪貼簿放的就是 Tab 分隔文字，所以貼進文字編輯器會看到以 Tab 分欄。
檔案該存成哪種格式？
交換用 CSV，因為支援的工具較多；要貼進試算表、或資料充滿逗號時用 TSV。
支援有引號的欄位嗎？
支援，轉換會正確加上與解讀引號，含分隔符的值來回轉換都能保住。
會改變換行符嗎？
輸出使用標準換行。若下游工具對 Windows 或 Unix 換行有嚴格要求，轉換後請再確認檔案。
本站相關工具
- CSV 檔案差異比較 — 依鍵值欄位比較兩個 CSV 並匯出差異
- CSV 欄位類型偵測 — 偵測文字、數字、日期、布林與空白欄位類型
- Excel 轉 JSON — 將指定工作表轉換為物件陣列或二維陣列
以上步驟全部在這個頁面內完成，TSV 與 CSV 互轉 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。