CSV Delimiter Converter
Convert comma, semicolon, tab, or pipe-delimited data
CSV Delimiter Converter — what it does
Convert delimited text between comma, semicolon, tab and pipe separation, with automatic detection of the source delimiter. Regional Excel settings are the usual reason a perfectly valid CSV opens as one long column, and switching the separator is normally all it takes to fix it.
When this tool helps
- Turning a comma CSV into semicolon-separated data for Excel installations in locales where the comma is the decimal mark.
- Converting a tab-separated export from a database client into standard CSV for a web importer.
- Switching to pipe separation when the data itself is full of commas and quoting is causing trouble.
How to use it
- Choose a file or paste the delimited text.
- Set the source delimiter, or leave it on auto detect.
- Choose the output delimiter.
- Process and copy or download the converted data.
Accuracy, limits, and good practice
- Values containing the new delimiter are quoted in the output, which is correct CSV behaviour and expected by every compliant parser.
- Semicolon files are standard in much of continental Europe, where a comma inside numbers would otherwise break every row.
- Tab-separated data survives copy and paste into spreadsheets more reliably than commas, since tabs rarely appear inside values.
Frequently asked questions
Why does Excel put my whole CSV in column A?
Excel splits on the list separator from your regional settings. Convert to semicolons, or use Data then Text to Columns to override it.
Is a TSV file just a CSV with tabs?
Essentially yes, and it is often safer, because real-world text contains commas far more often than it contains tab characters.
Does auto detect ever get it wrong?
Rarely, but text heavy with semicolons or pipes inside values can mislead it. Set the source delimiter explicitly if the preview looks wrong.
Related tools on this site
- Excel Row Filter — Filter worksheet rows and export matching data
- JSON Flattener — Convert nested JSON into flat key-value paths
- CSV Date Normalizer — Convert one CSV date column to a consistent format
Everything above runs inside this page. CSV Delimiter Converter needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 分隔符轉換能做什麼
在逗號、分號、Tab 與直線分隔之間轉換資料，並可自動偵測來源分隔符。一份完全正確的 CSV 在 Excel 裡變成一整欄，多半是地區設定造成的，換掉分隔符通常就能解決。
什麼時候用得上
- 把逗號 CSV 轉成分號分隔，供以逗號作小數點的地區版 Excel 使用。
- 把資料庫工具匯出的 Tab 分隔檔轉成標準 CSV，供網頁匯入器使用。
- 資料本身充滿逗號、引號處理老是出錯時，改用直線分隔。
使用步驟
- 選擇檔案或貼上分隔文字。
- 設定來源分隔符，或維持自動偵測。
- 選擇輸出分隔符。
- 執行轉換後複製或下載結果。
精確度、限制與實務建議
- 含有新分隔符的值在輸出中會加引號，這是正確的 CSV 行為，所有合規解析器都能處理。
- 分號格式在歐洲大陸相當標準，因為當地數字中的逗號否則會把每一列都切壞。
- Tab 分隔的資料在複製貼上到試算表時比逗號更穩，因為值中很少出現 Tab 字元。
常見問題
為什麼 Excel 把整份 CSV 塞進 A 欄？
Excel 依地區設定的清單分隔符切欄。改成分號，或用「資料」→「資料剖析」手動指定即可。
TSV 就是把逗號換成 Tab 的 CSV 嗎？
基本上是，而且通常更安全，因為真實文字中出現逗號的機率遠高於 Tab。
自動偵測會判斷錯嗎？
很少，但值中大量出現分號或直線時可能誤判。預覽看起來不對時，請直接指定來源分隔符。
本站相關工具
- Excel 資料列篩選 — 依條件篩選資料列並匯出結果
- JSON 扁平化 — 將巢狀 JSON 轉換成扁平鍵值路徑
- CSV 日期格式統一 — 將指定日期欄位轉換成一致格式
以上步驟全部在這個頁面內完成，CSV 分隔符轉換 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。