CSV 转分隔文本转换器
将 CSV 导出为逗号、制表符、竖线、分号、空格或固定宽度文本。选择目标系统所需的精确分隔符和引号方式，预览结果，一键下载。
此处将实时预览数据表格。
Pick your separator in the 输出为 menu — this page starts on a custom delimiter so you control it.
Turn CSV into the delimited format you need
Not every system reads comma CSV. Databases, ETL tools and older software often expect tab-delimited, pipe-delimited or fixed-width text instead. This converter rewrites your CSV into whichever delimited format the destination requires.
Paste or upload the CSV, choose the output separator (or type a custom one), and the tool re-serializes the data with correct quoting. The live preview confirms the columns line up before you export, and everything runs locally so your data stays private.
For a specific target, jump straight to comma, tab, pipe or fixed-width output.
How to use it
粘贴或上传
Add your text or drop a file — it is read locally in your browser, never uploaded.
Preview & adjust
Check the live table and the row / column counts, then tweak the delimiter or options if a column looks off.
Copy or download
Grab the result with Copy or Download. You can reopen recent conversions from this device too.
Input and output example
The same CSV exported with a semicolon delimiter; switch to tab, pipe or fixed width anytime.
id,name,city
1,Ada,NY
2,Lin,LAid;name;city
1;Ada;NY
2;Lin;LAWhich delimiter should you use?
每种分隔符适合不同工具 — 以下是简单指南。
Comma and semicolon
Comma is the universal default. 分号 is common in regions where the comma is a decimal mark, and many European Excel installations import semicolon files more cleanly. Choose semicolon if commas appear inside your values and you want to avoid quoting.
Tab (TSV) and pipe
Tab-separated text is the safest when fields contain punctuation, because tabs rarely appear inside data. 竖线 (|) is a long-time favorite for database loads and system-to-system feeds for the same reason.
Quoting rules
With 按需添加 quoting, a field is wrapped in quotes only if it contains the delimiter, a quote or a line break. Use 全部加引号 for strict importers, or 不加引号 when you have guaranteed the delimiter never appears in your data.
Fixed-width output
Choose 固定宽度 and each column is padded to its widest value, producing aligned text for mainframe and report formats. Pair it with a monospaced viewer to check alignment.
Line endings and encoding
Switch between LF (Unix) and CRLF (Windows) endings to match the receiving system, and enable UTF-8 BOM when the file will be opened in Excel.
Tips and edge cases
- Not sure what the other system wants? Tab or pipe are the safest general-purpose choices.
- Keep 全部加引号 on for strict parsers; it never hurts correctness, only file size.
- For the reverse job — delimited text into CSV — use delimited text to CSV.
CSV to Delimited Text Converter — FAQ
Which delimiter is best for Excel?
Comma CSV works everywhere; semicolon can import more cleanly in comma-decimal locales. Enable UTF-8 BOM for correct encoding.
Which is best for databases or legacy systems?
Tab or pipe, because those characters rarely appear inside values, avoiding the need for quoting.
Can I use a custom delimiter?
Yes. Choose Custom delimiter and type any character, such as ;, ~ or a caret.
How do I keep quotes and commas inside fields?
Leave quoting on 按需添加 or 全部加引号; values containing the delimiter or quotes are protected automatically.