TheFileTool
HomeData & subtitles

CSV → TSV

Drop CSV files here

Advanced settingsOutput settings
Excel/Google sheet methodTSV uses tabs and line breaks to separate cells and lines, so if that character is present in a value, it must be handled in one of two ways.
If it is not UTF-8, it is read as EUC-KR.It also automatically reads UTF-16 BOMs and saves the results as UTF-8. Select it manually only if the encoding of the file without BOM does not match.
Most programs that read a TSV do not expect a BOM. Turn it on only for files that will be opened in Excel.
Values starting with =, +, -, and @ can be executed as formulas in Excel and Google Sheets, so put a single quotation mark (') in front of them. Leave numbers like -5 as is.
Conversion details

Convert comma-separated tables to tab-separated tables to make them easier to paste into spreadsheets or databases.

Quality and preservation

Tab/line break within a cell (when in space mode)

Values that look like formulas (single quotes added when setting defense)

Related tools

CSV → JSONTSV → CSV

All tools