分隔文本转 CSV 转换器
已有分隔文本？将制表符、竖线、逗号、分号或空格分隔的数据转换为标准 CSV。选择输入分隔符（或自动检测），预览列，并导出干净的 CSV。
此处将实时预览数据表格。
Set 输入分隔符 to match your data — this page starts on 制表符; switch to pipe, comma, semicolon or space.
Convert separated text into CSV
When your text is already organized by a delimiter — tab delimited, pipe delimited, comma separated, semicolon or space — you just need it re-exported as proper CSV. This converter parses your delimited text and writes valid, quote-safe CSV.
Paste or upload the data, tell the tool which delimiter the input uses (or leave it on auto), and watch the live table confirm the columns. Fields that contain commas or quotes are protected automatically when the CSV is built, so the result re-imports cleanly.
If your columns are aligned by spaces rather than a delimiter, use fixed width to CSV instead. To go the other way, see CSV to delimited text.
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
Tab-delimited text re-exported as standard, quote-safe CSV.
name city
Ada NY
Lin LAname,city
Ada,NY
Lin,LAParsing each kind of delimited text
告诉转换器字段之间用什么分隔，剩余工作由它完成。
Tab- and comma-separated text
Tab-separated (TSV) data — the format you get when copying from a spreadsheet — converts to CSV directly. Comma-separated text is effectively already CSV, but running it through normalizes quoting and line endings so strict importers accept it.
Pipe-, semicolon- and space-separated text
Pipe (|) and semicolon (;) are common in exports; pick them under 输入分隔符. Space-separated text works too, though if a single space also appears inside values, fixed-width parsing is usually more reliable.
Multiple or inconsistent delimiters
If rows split into different numbers of columns, the preview flags it. That usually means the delimiter varies or values contain the delimiter. Switch the input delimiter explicitly, or clean the source, until the column count is consistent.
Quotes, empty values and headers
Quoted fields in the input are respected, empty cells are preserved as empty CSV fields, and ticking 首行为表头 keeps your column names in place.
Tips and edge cases
- Copied from Excel or Sheets? That is tab-separated — choose Tab (or leave Auto-detect).
- If columns shift, your data may contain the delimiter inside a field; try a different input delimiter.
- Export needs a non-comma separator instead? Use CSV to delimited text.
Delimited Text to CSV Converter — FAQ
How do I specify the input delimiter?
Use the 输入分隔符 menu to pick comma, tab, pipe, semicolon or space, or leave it on Auto.
How are quotes and empty values handled?
Quoted input fields are parsed correctly and empty cells stay empty in the CSV output.
Why do my columns look misaligned?
Usually the delimiter appears inside a value, or the input mixes delimiters. Set the input delimiter explicitly or use fixed-width parsing.
Is the conversion done locally?
Yes, entirely in your browser.